Lead Analytics Engineer

Lockton Companies; Kansas City, Northern (MO, KY); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Health insurance

Wellbeing program

Job summary

Lockton Companies in Kansas City, MO seeks a Lead Analytics Engineer to establish the analytics engineering discipline, define data models, and set standards for enterprise data assets. You will lead architecture decisions, mentor engineers, and ensure scalable, governed analytics solutions.

The role emphasizes hands-on design, technical leadership, and continuous improvement in data quality and reuse across the organization.

Qualifications

• Advanced SQL and data modeling experience.
• Experience with enterprise-scale data models.
• Experience implementing business logic and metrics.
• Experience with cloud analytics platforms like Databricks.
• Strong data quality, validation, governance practices.
• Mentor and guide Analytics Engineers.
• Strong analytical and problem-solving skills.

Responsibilities

• Lead design and stewardship of enterprise data products and semantic definitions.
• Define analytics engineering architecture and data patterns.
• Guide design decisions balancing scalability, maintainability, and performance.
• Lead reviews of changes to core data assets.
• Partner with data engineers and stakeholders to deliver scalable data solutions.
• Provide technical direction and prioritize work.
• Mentor team members and promote best practices.

Skills

Advanced SQL

Data modeling

Databricks

Cloud data platforms

Quality governance

Mentoring

Analytical thinking

Tools

Databricks

Job description

Kansas City, Missouri, United States of America

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.

The Lead Analytics Engineer is responsible for establishing the Analytics Engineering discipline. This role defines and evolves the data modeling patterns, business logic frameworks, and implementation standards that guide the team's work. You remain hands-on in design and implementation, providing technical direction and serving as the authority on complex data decisions.

Key Responsibilities

Enterprise Data Products & Architecture

• 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.

Standards, Governance & Quality

• 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.

Analytics Engineering Delivery

• 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.

Leadership

• Provide technical leadership, mentorship, and guidance to Analytics Engineers.
• Serve as the technical escalation point for complex Analytics Engineering challenges.
• Help establish a culture of technical discipline, thoughtful design, and continuous improvement.

Qualifications

• Experience working within insurance, brokerage, financial services, or other complex data-intensive industries.
• 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 working with modern cloud-based analytics and data platforms, such as Databricks.
• Strong understanding of data quality, validation, testing, and governance practices.
• Experience mentoring technical team members and leading solution design efforts.
• Strong analytical and problem-solving skills.
• Ability to balance business needs, maintainability, scalability, and long-term support considerations.

Success Looks Like

• Shared business logic is reused rather than recreated.
• Standards and processes are consistently followed across the discipline.
• Data models, business rules, and semantic definitions remain maintainable and well documented.
• Analytics Engineers have clear technical direction and guidance.
• New solutions are built using common patterns rather than one-off approaches.
• Enterprise metrics, dimensions, and business rules remain consistent across data assets.
• Analytics Engineering practices continue to scale as adoption and demand grow.
• Data assets are easier to maintain, support, and evolve over time.

#LI-JM

Equal Opportunity Statement

Lockton Companies is proud to provide everyone anequal 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 learnsfrom, celebrates and thrives because of ourbreadth 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.

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.