Data Engineer

Job Overview

Murphy-Hoffman Company, LLC is North America’s largest Kenworth truck Dealership and Leasing group. As MHC continues to grow, we have an opening for a Data Engineer. The Data Engineer is responsible for designing and developing data infrastructure to ensure availability of data throughout the organization, as well as implementing systems to integrate (replicate, extract, transform, load) data in batch or near-real-time. The data engineer works with the data architect and business analysts on source-to-target mappings to populate a data warehouse and writes code to transform the data and load it into the target data models. This position is fully in office 5 days a week in Leawood, KS.

Essential Functions

• Develops, tests, and maintains data pipelines and Extract, Transform, Load activities.
• Prepares data for various business use cases including data science, prescriptive and predictive modeling.
• Collaborates with the data architect to build and maintain the data systems specified by the data architect’s data framework.
• Designs, builds, and implements enterprise data warehouse and/or data lake for data storage and modeling in downstream analytics and reporting.
• Creates and maintains data models designed according to best practices which improve performance, flexibility, and accuracy used for analytics and reporting.

Qualifications

• Bachelor’s degree in Data Management, Data Science, BI Analytics, or related
• Proven expertise in data modeling and data transformation
• Strong knowledge of database structure systems and data mining
• Experience working with Snowflake, Azure Data Factory, Qlik Replicate, SQL, T-SQL, DBT, Microsoft Fabric, Python/PySpark.

About

About Us
MHC is an expansion of the original company, Ozark Kenworth, Inc. Ozark Kenworth started in Springfield, Missouri, in January 1975. Opening for business without a Parts or Service department and only three employees in a temporary facility. From there, the company grew and expanded. MHC is now a multi-state network of full-service diesel truck dealerships, leasing and rental operations, transport refrigeration locations, and a finance company which offers a complete array of finance and insurance services. We believe in fostering an environment that helps employees realize their full potential – a place where you can grow as a person and a professional. Equal Opportunity Employer / Veterans / Disabled