End-to-End Data Platform Engineer

Lockton; Kansas City (MO); On-site; USD 110,000 - 160,000; Full time

Job summary

Lockton is seeking experienced Full-Lifecycle Data Engineers to design, build, and operate a next-generation data platform across ingestion, transformation, modeling, serving, and production operations in Kansas City. You will combine software, data, and analytics engineering to deliver scalable data products powering analytics, applications, and machine learning.

You will contribute to building reliable, scalable data pipelines and services, enabling self-serve analytics and integrated data

Qualifications

• Strong programming skills.
• Advanced SQL and data modeling expertise.
• Experience with data processing frameworks.
• Hands-on experience with cloud platforms (Azure).
• Experience with modern data warehouses.
• Familiarity with orchestration tools.
• Understanding of distributed systems and data architecture patterns.
• Ability to build both backend-style data systems and analytics pipelines.

Responsibilities

• Build and maintain scalable batch and streaming data pipelines.
• Design ETL/ELT transformations and modular data workflows.
• Design and maintain data warehouses and lakehouse architectures.
• Build data services or APIs for downstream consumers.
• Own scheduling, orchestration, and data observability.
• Collaborate with analytics, product, and engineering teams.

Skills

Programming

SQL

Data modeling

ETL/ELT

Databricks

Azure

Data warehousing

Orchestration tools

Distributed systems

Backend data systems

Tools

Databricks

Azure

Airflow

CI/CD

Job description

Lockton is seeking experienced Full-Lifecycle Data Engineers to design, build, and operate a next-generation data platform across ingestion, transformation, modeling, serving, and production operations in Kansas City. You will combine software, data, and analytics engineering to deliver scalable data products powering analytics, applications, and machine learning.

You will contribute to building reliable, scalable data pipelines and services, enabling self-serve analytics and integrated data