Data Engineer I
Oklahoma City, OK, US, 73120
Love's Travel Stops
Love’s Travel Stops & Country Stores is headquartered in Oklahoma City, Oklahoma. Founded in 1964, Love’s has more than 510 locations in 41 states. Love’s provides professional truck drivers and motorists with 24-hour access to clean and safe...Req ID: 439336
BASIC PURPOSE: As a Data Engineer I for Loves, the successful candidate will play a pivotal role in building, managing, and optimizing data pipelines for the Enterprise Data & Analytics initiatives following industry standard practices and tools. This role will be the key interface in operationalizing data and analytics on behalf of the business unit(s) and organizational outcomes. The candidate will require both creative and collaborative skills working with IT and business, including data scientists, data analysts, and other data consumers, as well as 3rd party business partners and vendors.
The candidate should have 1-3 years of experience in the responsibilities listed below.
MAJOR RESPONSIBILITIES/SKILLS:
- Collaborate with program leadership to architect, build, and maintain data pipelines through acquisition, ingestion, staging, and modeling
- Moderate experience with various Data Management architectures like Data Warehouse, Data Lake, Data Hub, Data Vault and the supporting processes like Data Integration, Governance, and Metadata Management
- Moderate experience working with large, heterogeneous datasets in building data pipelines and integrating datasets using traditional data integration technologies, including ETL/ELT, data replication/CDC, message-oriented data movement, and API-based data acquisition
- Responsible for the identification and qualification of source data to satisfy master and transactional data requirements for the target warehouse
- Perform data assessment and mapping activities, and develop the underlying migration framework to extract, transform, validate, enrich, and load the source data
- Fundamental understanding of data warehousing principles
- Ability to understand impacts of a solution architecture on corresponding design, build, and test efforts
- Ship small features with minimal oversight
EDUCATION AND EXPERIENCE:
- Required Experience:
- Moderate experience with cloud data warehouses, such as Snowflake
- Moderate experience working SQL and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases (Microsoft SQL required)
- Moderate experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc.
- Moderate experience working with open-source or commercial message queuing technologies, such as Azure Service Bus, Apache Nifi, Apache Kafka, etc.
- Moderate experience working with DevOps capabilities like version control, automated builds, testing and release management using tools like Git
- Moderate experience working with replication software such as Fivetran or HVR
- Moderate experience with ETL tools
- Preferred Experience:
- SQL Server 2008+ experience a plus
- SAP Hana experience a plus
- Tableau experience a plus
- Power BI experience a plus
- R/Python experience a plus
- Dbt experience strongly preferred
- Education:
- HS Diploma or equivalent required
- Bachelor’s degree in Business with MIS or technology related degree (C.S.) required
INTERPERSONAL SKILLS & CHARACTERISTICS
- Capable of thinking big picture and sorting through an ambiguous environment
- Ability to manage numerous competing demands in a fast-paced environment
- Demonstrates good judgement, sense of urgency and commitment to high standards of ethics, regulatory compliance, customer service and business integrity
- Required to be highly creative and collaborative
- Excellent verbal and written communication skills
- Ability to communicate clearly and concisely to various levels in the organization
PHYSICAL DEMANDS:
- Requires prolonged sitting, some bending and stooping.
- Occasional lifting up to 25 pounds.
- Manual dexterity sufficient to operate a computer keyboard and calculator.
- Requires normal range of hearing and vision
Job Function(s): Information Technology
Love’s has been fueling customers’ journeys since 1964. Innovation and perseverance continue to lead the way for the family-owned and -operated business headquartered in Oklahoma City with more than 40,000 team members in North America and Europe. The company’s core business is travel stops and convenience stores with more than 630 locations in 42 states. Love’s continues its commitment to offer products and services that provide value for professional drivers, fleets, four-wheel customers, RVers, alternative fuel and wholesale fuel customers. Giving back to communities Love’s serves and maintaining an inclusive and diverse workplace are hallmarks of the company’s award-winning culture.
The Love’s Family of Companies includes:
- Gemini Motor Transport, one of the industry’s safest trucking fleets.
- Speedco and Love’s Truck Care, the largest oil change and preventive maintenance and total truck care network.
- Musket, a rapidly growing, Houston-based commodities supplier and trader.
- Trillium, a Houston-based alternative fuels expert.
- TVC Pro-driver, a commercial driver’s license (CDL) protection subscription service.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs Architecture Azure Data management Data pipelines Data warehouse Data Warehousing dbt DevOps Driver’s license ELT ETL FiveTran Gemini Git Java Kafka NiFi Open Source Pipelines Power BI Python R RDBMS Scala Snowflake SQL Tableau Testing
Perks/benefits: Team events
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Business Intelligence Engineer jobs
- Open Lead Data Analyst jobs
- Open Data Engineer II jobs
- Open Power BI Developer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Science Manager jobs
- Open Marketing Data Analyst jobs
- Open MLOps Engineer jobs
- Open Junior Data Scientist jobs
- Open Business Intelligence Developer jobs
- Open Business Data Analyst jobs
- Open Data Scientist II jobs
- Open Product Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Analyst Intern jobs
- Open Sr Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Sr. Data Scientist jobs
- Open Junior Data Engineer jobs
- Open Senior Data Architect jobs
- Open Data Engineering Manager jobs
- Open Big Data Engineer jobs
- Open Research Scientist jobs
- Open Data Quality Analyst jobs
- Open Manager, Data Engineering jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Data quality-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open NLP-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open LLMs-related jobs
- Open APIs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Airflow-related jobs