Analytics Engineer

Your Job

As an Analytics Engineer at Koch Engineered Solutions (KES), you will design and deliver high-quality semantic models and BI solutions that drive decision-making across KES.

You will work closely with analysts, business partners, and data engineering teams to transform raw data into trusted, reusable, AI-ready analytics assets.

Your work will directly shape how users and AI-enabled tools discover, understand, and use data across the enterprise.

This role will work out of our Wichita, KS office, and is not eligible for visa sponsorship.

Our Team

As a member of the IT capability, you will thrive in a fast-paced, innovative environment.

You will collaborate across teams to develop solutions, validate their value through experimentation, and scale them across our businesses.

Creativity, collaboration, and a focus on delivering measurable business outcomes are essential.

Working in an Agile environment, you will partner with internal teams and external solution providers to accelerate progress toward KES objectives .

What You Will Do


* Collaborate closely with analysts and business stakeholders to understand data gaps, define metrics, and design robust, scalable analytics solutions.

This includes proposing alternative solutions, with their pros and cons to help guide the workstream forward.


* Design and build dimensional models that are clean, performant, and easy to use


* Develop and optimize SQL transformations to convert data into business friendly and reusable dimensional model objects


* Create and maintain semantic models that enable clear and efficient self-service analytics


* Develop enterprise Power BI reports and dashboards with a focus on usability, performance, and consistent business definitions


* Implement and follow professional development practices: Git based version control, branching/PR workflows, testing/validation, CI/CD, etc.


* Collaborate with data engineers, architects, and other analytics engineers to align on standards for naming, documentation, data quality, and model governance


* Support adoption by documenting models and metrics, enabling stakeholder training, and improving discoverability


* Troubleshoot data issues with data models and reports and continuously improve reliability and performance

Who You Are (Basic Qualifications)



* Demonstrated ability to use SQL skills for data transformation


* Demonstrated experience building dimensional data models for BI applications


* Hands - on experience with Power BI semantic model and report development


* Experience with Power Query (M) and understanding of when/how to use it effectively


* Experience using Git in a team environment (branches, PRs, code reviews)

What Will Put You Ahead



* Deep knowledge of dimensional modeling best practices and optimization techniques


* Experience with dbt (models, tests, documentation, macros, exposures)


* Experience collaborating with a Financ...