Full Lifecycle Data Engineer

Working at Lockton

At Lockton, we’re passionate about helping our people achieve their ultimate potential. Our people are curious, action-oriented and always striving to make ourselves and those around us better. We’re active listeners working to ensure understanding and problem solvers developing innovative solutions. If you can see yourself delivering excellent service to clients, giving back to our communities and being a part of our caring culture, you belong here.

About the Position

Lockton is a global professional services firm with 6,500 Associates who advise clients on protecting their people, property and reputations. Lockton has grown to become the world's largest privately held, independent insurance broker by helping clients achieve their business objectives. To see the latest insights from Lockton's experts, check Lockton Market Update.

A few of the reasons Associates love working at Lockton include:

• Opportunities for growth and advancement, including paid training and professional development
• 12-week paid parental leave
• A huge emphasis on community involvement
• Frequent athletic and wellness events
• Incredibly generous rewards; US Associates receive a Rolex for their 10 year anniversary!

Your Responsibilities

We are looking for experienced Full-Lifecycle Data Engineers to design, build, and operate our next-generation data platform. This role owns the full data lifecycle—from ingestion and transformation through modeling, serving, observability, and production operations. Successful candidates combine software engineering, data engineering, and analytics engineering skills to deliver reliable, scalable data products that power analytics, applications, and machine learning. 

Key Responsibilities  Data Ingestion & Integration  •    Build and maintain scalable batch and streaming data pipelines  •    Integrate data from APIs, event streams, databases, SaaS tools, and third-party systems  •    Ensure reliable, fault-tolerant ingestion across multiple sources  Data Processing & Transformation  •    Design and implement transformation pipelines using ELT/ETL patterns  •    Develop modular, reusable data transformations (Databricks experience a plus)  •    Ensure data consistency, correctness, and reproducibility  Data Storage & Modeling  •    Design and maintain data warehouses, lakes, and lakehouse architectures  •    Build analytics-ready data models (star schema, wide tables, semantic layers)  •    Optimize data structures for performance and cost efficiency  Data Products & Serving Layer  •    Build data services or APIs that expose curated datasets to downstream consumers  •    Enable self-serve analytics via BI tools and semantic modeling layers  •    Support embedded analytics or product-facing data features when needed  Orchestration & Reliability  •    Own scheduling and orchestration systems  •    Implement monitoring, alerting, and data observability practices  •    Debug and resolve end-to-end data issues across the stack  Collaboration & Enablement  •    Partner with analytics, product, and engineering teams to define data needs  •    Translate business requirements into scalable data solutions  •    Support experimentation, reporting, and machine learning workflows 

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  Nice to Have  •    Experience building data APIs or internal data services  •    Infrastructure-as-code  •    CI/CD for data systems  •    Experience with ML data pipelines or feature stores  •    Front-end exposure for dashboards or internal tools  •    Data governance enablement  •    Security and privacy (HIPAA)  Soft Skills  •    Comfortable owning ambiguous, end-to-end problems  •    Clear communication with both engineers and business users

#LI-JM

Equal Opportunity Statement

Lockton Companies is proud to provide everyone an equal opportunity to grow and advance. We are committed to an inclusive culture and environment where our people, clients and communities are treated with respect and dignity.

At Lockton, supporting diversity, equity and inclusion is ingrained in our values, and we believe that we are at our best when we fully embrace everyone. We strive to cultivate a caring culture that learns from, celebrates and thrives because of our breadth of differences. As such, we recognize that recruiting, developing and retaining people with diverse backgrounds and experiences is vital and enabling our people to thrive personally and professionally is critical to our long-term success.

About Lockton

Lockton is the largest privately held independent insurance brokerage in the world. Since 1966, our independence has allowed us to serve our clients, take care of our people and give back to our communities. As such, our 13,100+ Associates doing business in over 155 countries are empowered to do what’s right every day.

At Lockton, we believe in the power of all people. You belong at Lockton.

How We Will Support You

At Lockton, we empower you to be true to yourself in all that you do. Your success is our success, and we provide opportunities to help you grow and create a rewarding career path, however you envision it.

We are ready to meet you where you are today, and as your needs change over time. In addition to industry-leading health insurance, we offer additional options to support your overall health and wellbeing.

Learn more about your Lockton experience

No Agencies Please

Any Employment Agency, person or entity that submits an unsolicited resume to this site does so with the understanding that the applicant's resume will become the property of Lockton Companies, Inc. Lockton Companies will have the right to hire that applicant at its discretion and without any fee owed to the submitting Employment Agency, person or entity. Employment Agencies, who have fee Agreements with Lockton Companies must submit applicants to the designated Lockton Companies Employment Coordinator to be eligible for placement fees.

Strong programming, advanced SQL and data modeling, data processing frameworks, Azure, modern data warehouses, orchestration tools, distributed systems, and data architecture expertise.

Key Responsibilities

• building pipelines
• designing warehouses
• operating platforms

Skills & Tools

SQL, Azure, Databricks, HIPAA

Job Details

• Category: Data and Analytics
• Seniority: Senior Level
• Commitment: Full Time
• Workplace: Remote — Kansas City, Missouri, United States
• Languages: English

Benefits

• Generous paid time off
• Generous parental leave

About Lockton Companies

A privately held independent insurance brokerage that advises clients on protecting their people, property, and reputations. — Industry: Finance