Lead Analytics Engineer — Data Architecture & Standards

Lockton; Kansas City (MO); On-site; USD 150,000 - 210,000; Full time

Job summary

Lockton in the United States is seeking a Lead Analytics Engineer to establish the Analytics Engineering discipline, shaping data modeling patterns and implementation standards while staying hands-on in design and implementation.

You will guide architectural decisions, mentor Analytics Engineers, and collaborate with Data Engineers and business stakeholders to deliver scalable data solutions enterprise-wide.

Qualifications

• Advanced SQL and data modeling experience.
• Experience designing and maintaining enterprise-scale analytical data models.
• Experience implementing business logic, metrics, semantic definitions, and reusable data assets.
• Experience with modern cloud-based analytics platforms (e.g., Databricks).
• Strong understanding of data quality, validation, testing, and governance practices.
• Experience mentoring technical team members and leading solution design.
• Strong analytical and problem-solving skills.
• Ability to balance business needs with maintainability and scalability.

Responsibilities

• Lead the design and stewardship of enterprise data products, analytical data models, shared metrics, semantic definitions, and reference data.
• Define and evolve the Analytics Engineering architecture, data modeling patterns, and implementation practices the team follows.
• Guide technical design decisions and evaluate tradeoffs related to scalability, maintainability, quality, performance, and long-term support.
• Establish review practices for significant changes to core data assets, metrics, dimensions, and business rules.
• Establish and evolve standards for data modeling, transformations, testing, validation, documentation, naming conventions, and semantic definitions.
• Promote consistent use of standards and reusable assets through technical reviews, guidance, and mentorship.
• Establish quality control and change management practices that improve the reliability and maintainability of data assets.
• Lead complex troubleshooting and root cause analysis efforts.
• Partner with Data Engineers, Analytics Engineers, and business stakeholders to deliver scalable and sustainable data solutions.
• Provide technical direction on solution design, implementation approaches, and technical prioritization.
• Identify opportunities to improve development processes, architecture, reuse, and long-term supportability.
• Ensure business logic, metrics, and semantic definitions are implemented consistently across data assets and analytical models.

Skills

Advanced SQL

Data modeling

Governance

Mentorship

Analytical thinking

Problem solving

Tools

Databricks

Job description

Lockton in the United States is seeking a Lead Analytics Engineer to establish the Analytics Engineering discipline, shaping data modeling patterns and implementation standards while staying hands-on in design and implementation.

You will guide architectural decisions, mentor Analytics Engineers, and collaborate with Data Engineers and business stakeholders to deliver scalable data solutions enterprise-wide.