MHC Kenworth logo
MHC Kenworth Verified
Automotive, Trucking, Retail, Transportation

Data Engineer

Kansas, United StatesOnsiteFull TimePosted 2 months ago

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Role summary

Murphy-Hoffman Company (MHC), a leading Kenworth truck dealership and leasing group, is seeking a Data Engineer to design and develop data infrastructure. This role involves implementing systems for batch or near-real-time data integration (ETL), preparing data for analytics and modeling, and collaborating with data architects and business analysts. The Data Engineer will build and maintain enterprise data warehouses/lakes, create data models for improved performance and accuracy, and ensure data availability across the organization. The position requires expertise in data modeling, transformation, database systems, data mining, and specific technologies like Snowflake, Azure Data Factory, Python/PySpark, and SQL. This is a fully onsite role in Leawood, KS.

Description:
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.

  • 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.
  • Performs other duties as assigned by supervisor.

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.
  • Ability to work in a team environment and independently as
  • Ability to work effectively in fast-paced changing environment and effectively manage multiple priorities within established time
  • Proven ability to effectively communicate issues and potential resolutions to business units, other team members, project managers, and leaders as necessary.

Benefits:

  • Competitive Salary
  • Medical, Dental and Prescription Insurance
  • Disability and Life Insurance
  • Paid Time Off program
  • 401k and Profit Sharing with Employer Match
  • Flexible Spending Account
  • Internal Promotion Opportunities
  • On the Job Training
Ready to apply?
You'll be redirected to MHC Kenworth's application page.

Similar roles