Data Engineer

Job 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 designs, builds, and supports scalable data products and platform capabilities that enable trusted, timely, and governed data across the organization. This role develops and maintains batch and real-time data pipelines, integrates data from operational and third-party systems, and transforms raw data into analytics-ready assets for reporting, self-service analytics, operational intelligence, and advanced analytics use cases. The Data Engineer partners closely with data architecture, analytics, and business teams to deliver robust solutions across the modern data stack. This position is fully in office 5 days a week in Leawood, KS. Designs, develops, tests, deploys, and maintains scalable data pipelines, ingestion solutions, and data integration processes that support batch and real-time / streaming workloads using tools and services such as Azure Data Factory (ADF), Azure Kubernetes Service (AKS), Confluent Cloud, Kafka, and Flink. Implements and supports change data capture (CDC), event-driven, and streaming architecture patterns, including Kafka topics, schema-aware ingestion, and near-real-time data delivery to downstream consumers. Develops data transformations and curated datasets using SQL, T-SQL, dbt, Python, and PySpark to support reporting, analytics, data science, and AI / machine learning use cases. Creates and maintains data models, lakehouse / warehouse structures, and semantic-ready datasets that enable scalable, trusted, and high-performing downstream analytics and reporting. Collaborates with data architects, analysts, application teams, and business stakeholders to define source-to-target mappings, business rules, data contracts, and solution designs that align with enterprise standards and business needs. Builds and maintains reusable frameworks, templates, engineering standards, and deployment practices; including CI/CD, version control, and release processes for notebooks, dbt models, SQL objects, and pipeline definitions to improve consistency, scalability, speed, and long-term maintainability across the data platform. Applies data quality, testing, reconciliation, monitoring, and documentation practices to ensure data completeness, accuracy, freshness, reliability, supportability, knowledge transfer, and auditability. Troubleshoots data platform issues, production incidents, and root causes; communicates impacts and recommended resolutions clearly to technical and business stakeholders; and stays current on modern data engineering patters, platform capabilities, and security / governance requirements to recommend improvements that increase platform maturity and business value. Performs other duties as assigned by supervisor. 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 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