Lockton

Full Lifecycle Data Engineer

Lockton$110K — $130K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of experience in data engineering or related fields
  • Strong programming skills with a focus on data-driven applications
  • Advanced SQL expertise and proficiency in data modeling techniques
  • Hands-on experience with cloud platforms, preferably Azure
  • Experience integrating and processing data using multiple frameworks
  • Familiarity with planning, orchestration, and distributed systems

Responsibilities

  • Build and maintain scalable data pipelines for both batch and streaming data
  • Integrate diverse data sources, including APIs and databases, into a cohesive platform
  • Design and implement efficient data transformation pipelines with ELT/ETL methods
  • Create and optimize data storage solutions like warehouses and lakes
  • Develop APIs to provide curated datasets for various business needs
  • Implement observability practices to monitor and ensure data reliability
  • Collaborate with cross-functional teams to translate requirements into data solutions

Benefits

  • Flexible work environment with opportunities for remote work
  • Access to professional development resources and training programs
  • Support for work-life balance initiatives
  • Collaboration with a diverse and innovative team
  • Opportunity to work with cutting-edge technologies and tools
Full Job Description
Job Summary:

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 workflow

Requirements:
• Strong programming skills
• AdvancedSQLand 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 buildingdata 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

About Lockton

Lockton Companies is the world's largest privately held insurance brokerage firm, providing insurance, risk management, employee benefits and retirement services. The company was founded in 1966 and is headquartered in Kansas City, Missouri. Lockton has more than 7,500 associates in over 100 offices worldwide. The company serves clients in a variety of industries, including construction, healthcare, hospitality, manufacturing, real estate, and technology. Lockton is known for its innovative solutions and exceptional customer service.
Learn more about Lockton
Size
7,500 employees
Industry
Founded
1966

Similar Jobs

More Jobs at Lockton

More Information Technology Jobs

Find similar Full Lifecycle Data Engineer jobs: