Data Engineer III - Hybrid Remote
Company
Love's Travel Stops
Location
York ON
Type
Full Time
Job Description
BASIC PURPOSE :
As a Data Engineer III 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 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 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
EDUCATION AND EXPERIENCE:
- Required Experience:
- Strong experience with cloud data warehouses, such as Snowflake
- 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
- 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 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
The Love's Experience
Love's was founded in 1964 on the values of integrity, customer focus, strong work ethic, innovation and perseverance. We are looking for these in every person we hire. No matter what job you do for Love's, your commitment to these values will not only continue our legacy of growth, it will also ensure your successful career.
Nearest Major Market: Oklahoma City
Nearest Secondary Market: Oklahoma
Job Segment: Testing, Cloud, Data Warehouse, Open Source, Database, Technology
Date Posted
10/18/2022
Views
7
Similar Jobs
Strategic Customer Success Manager - Rokt
Views in the last 30 days - 0
mParticle by Rokt a leading customer data platform is seeking a Strategic Customer Success Manager The role involves building strong relationships wit...
View DetailsEnterprise Customer Success Manager - Rokt
Views in the last 30 days - 0
mParticle by Rokt a leading customer data platform is seeking an Enterprise Customer Success Manager The role involves serving as a trusted consultant...
View DetailsAWS Alliance Driver, Director - PwC
Views in the last 30 days - 0
The text describes a role for an AWS Alliance Director at PwC The individual will lead the AWS Alliance across various sectors focusing on the overall...
View DetailsBusiness Account Executive - Spectrum
Views in the last 30 days - 0
The Business Account Executive role involves selling primary and ancillary communications solutions to small and mediumsized businesses within a speci...
View DetailsSenior Software Engineer, Devices Automation - Block
Views in the last 30 days - 0
Square a company that has evolved since its inception in 2009 is seeking a Software Engineer with extensive experience in embedded devices and test en...
View DetailsSoftware Engineering Lead - Dotdash Meredith
Views in the last 30 days - 0
Dotdash Meredith is seeking a skilled Engineering Lead for a missioncritical role in designing and scaling their nextgeneration publishing platform Th...
View Details