Associate Analytics Engineer

Lockton Companies; Kansas City (MO); On-site; USD 85,000 - 115,000; Full time

Job summary

Lockton Companies in Kansas City, MO, seeks an Associate Analytics Engineer to modernize our reporting and data environment, starting with Power BI development and evolving toward centralized data layers.

You will work with Analytics Engineers, Data Engineers, and business stakeholders to deliver reliable, scalable data assets and governance across the organization.

Qualifications

• Experience developing Power BI reports, dashboards, and data models.
• Strong SQL skills and the ability to write clean, complex queries.
• Understanding of data warehousing and dimensional modeling concepts (star schemas/Kimball).
• Experience developing business logic and metrics within Power BI.
• Familiarity with modern cloud data platforms such as Databricks.
• Exposure to Git, version control, testing, or other software development practices is a plus.

Responsibilities

• Develop, maintain, and enhance Power BI reports, dashboards, and semantic models.
• Translate business requirements into Power BI solutions and analytics experiences.
• Migrate data models and business logic toward centralized data assets.
• Write SQL to transform data for analytics use and ensure data quality.
• Collaborate with Analytics Engineers, Data Engineers, and stakeholders to define metrics.

Skills

Power BI reports

SQL

Dimensional modeling

Analytics Engineering

Data modeling

Git

Data warehousing

Communication

Tools

Databricks

Git

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 Associate Analytics Engineer supports the modernization of the organization's reporting and data environment. Initially focused heavily on Power BI development and reporting, this role will progressively move data models and business logic upstream from individual reports into centralized, reusable data and semantic layers.

Working with Analytics Engineers, Data Engineers, and business stakeholders, the Associate Analytics Engineer will maintain and enhance existing Power BI solutions while developing the skills and practices needed to build reliable, scalable, and well-governed data assets.

Power BI & Analytics

• Develop, maintain, and enhance Power BI reports, dashboards, and semantic models.
• Translate business requirements into effective Power BI solutions and analytical experiences.
• Develop and maintain Power BI data models, measures, and business logic.
• Troubleshoot data, modeling, and report issues and improve report performance and usability.
• Partner with business stakeholders to understand reporting needs and translate business definitions into consistent metrics and logic.
• Identify opportunities to reduce duplicated logic and move reusable business logic upstream from individual Power BI reports.

Analytics Engineering & Data Modeling

• Progressively migrate data models, transformations, and business logic from Power BI into centralized data and semantic layers.
• Develop and maintain analytics-ready datasets using emerging Analytics Engineering practices and patterns.
• Apply dimensional modeling concepts, including star schemas and other established data modeling practices.
• Write clean, maintainable SQL to transform and prepare data for analytical use.
• Contribute to reusable enterprise data assets and standardized business logic.
• Partner with Analytics Engineers and Data Engineers to understand data structures, technical patterns, and implementation approaches.

Data Quality & Performance

• Validate data and business logic to ensure reporting and analytical solutions are accurate and reliable.
• Monitor and troubleshoot Power BI and query performance.
• Partner with Analytics and Data Engineers to improve performance, reliability, and maintainability.
• Support testing and validation of data models, metrics, and transformations.

Qualifications

• Experience developing Power BI reports, dashboards, and data models.
• Strong SQL skills and the ability to write clean, complex, and maintainable queries.
• Understanding of data warehousing and dimensional modeling concepts, including star schemas and Kimball methodologies.
• Experience developing business logic and metrics within Power BI.
• Familiarity with modern cloud data platforms such as Databricks.
• Exposure to Git, version control, testing, or other software development practices is a plus.
• Interest in developing an Analytics Engineering skill set and applying engineering practices to data.
• Ability to translate business requirements and definitions into clear, consistent data logic.
• Strong analytical, problem-solving, and communication skills.
• Ability to collaborate with business stakeholders, Analytics Engineers, and Data Engineers.

Growth in the Role

• Data modeling and transformation outside of Power BI.
• Reusable enterprise business logic and semantic definitions.
• Testing, validation, and technical documentation.
• Migration of reporting logic into centralized data assets.
• Code-based development and version-controlled data solutions.
• Technical design and implementation of analytics-ready data assets.

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.