Data Engineer III - Hybrid Remote

Req ID: 401337 

BASIC PURPOSE: As a Data Engineer III for Love’s, the successful candidate will play a pivotal role in building, managing, and optimizing data pipelines, utilizing a modern data platform and technologies.  This role will be the key interface in operationalizing data & advanced analytics for the Refined Trading & Supply Team and helping them drive towards their 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 5-7 years of experience in the responsibilities listed below.

MAJOR RESPONSIBILITIES/SKILLS:

• Architect, build, and maintain data pipelines through acquisition, ingestion, staging, and modeling
• Provide architectural input to program leadership for project teams to develop solutions that align with long-term data warehouse strategy
• Strong 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
• Strong experience working with large, heterogeneous datasets in building data pipelines and integrating datasets using traditional and modern 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
• Lead data assessment and mapping activities, and develop the underlying migration framework to extract, transform, validate, enrich, and load the source data
• Define reusable solution architectures using standard modeling practices
• Design and deliver solutions that are reliable and scalable and focused on driving automation and improving productivity
• Fundamental understanding of data warehousing principles
• Ability to understand impacts of a solution architecture on corresponding design, build, and test efforts
• Ability to analyze large data sets to determine relevance and identify anomalies   

EDUCATION AND EXPERIENCE:

• Required Experience:
  • Strong experience with cloud data warehouses, such as Snowflake
  • Strong experience with cloud storage, such as S3
  • Strong experience working with complex SQL code
  • Moderate experience working with open-source or commercial message queuing technologies, such as Azure Service Bus, Apache Nifi, Apache Kafka, etc.
  • Strong 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
  • Strong experience with ETL tools
  • Strong experience in Python

• Preferred Experience:
  • SQL Server 2012+ experience 
  • SAP Hana experience
  • Tableau experience
  • Power BI experience
  • dbt experience
  • Azure Data Factory (ADF) experience
  • Familiarity with building forecasting models including linear regression and time-series analysis

• 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 Travel Stops & Country Stores is the industry-leading travel stop network in the United States. For more than 55 years, we’ve provided customers with highway hospitality and “Clean Places, Friendly Faces.” We’re passionate about serving drivers with clean, modern facilities stocked with fuel, food and supplies. We offer meals from popular restaurant chains, trucking supplies, showers and everything needed to get back on the road quickly. The Love’s Family of Companies includes:

• Gemini Motor Transport, one of the industry’s safest trucking fleets
• Speedco, the light mechanical and trucking service specialists
• Musket, a rapidly growing, Houston-based commodities supplier and trader
• Trillium, a Houston-based alternative fuels expert