Hiring: Associate Analytics Engineer Company: Lockton Location: Kansas City, MO Job Posted Time: 2026-09-17 09:27:41 Target Skills & Keywords : Databricks, Git, SQL About the job Required Skills: •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. •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. Qualifications: •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. •Operational 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. •Demonstrated capacity to translate business requirements and definitions into clear, consistent data logic. •Strong analytical, problem-solving, and communication skills. •Demonstrated capacity to collaborate with business stakeholders, Analytics Engineers, and Data Engineers. Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!