AI-Ready Analytics Engineer: Semantic BI & Modeling

Flint Hills Resources; Wichita (KS); On-site; USD 90,000 - 130,000; Full time

Job summary

Koch Engineered Solutions (KES) is seeking an Analytics Engineer to design and deliver semantic models and BI solutions from Wichita, KS. You will work with analysts, business partners, and data engineering to transform raw data into trusted analytics assets that enable AI-ready discovery and use across the enterprise.

You will build dimensional models, develop Power BI reports, and implement best practices for data governance, documentation, and model maintenance in an Agile environment.

Qualifications

• Proven experience building dimensional data models for BI applications.
• Hands-on Power BI semantic model and report development.
• Experience with Power Query (M) and understanding of when/how to use it.
• Experience using Git in a team environment (branches, PRs, code reviews).

Responsibilities

• Collaborate closely with analysts and business stakeholders to understand data gaps, define metrics, and design robust, scalable analytics solutions.
• 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
• 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)

Skills

Dimensional modeling

Power BI

SQL

Git

CI/CD

Metadata management

Data governance

dbt

Snowflake

Power Query (M)

Tools

dbt

Snowflake

Git

Job description

Koch Engineered Solutions (KES) is seeking an Analytics Engineer to design and deliver semantic models and BI solutions from Wichita, KS. You will work with analysts, business partners, and data engineering to transform raw data into trusted analytics assets that enable AI-ready discovery and use across the enterprise.

You will build dimensional models, develop Power BI reports, and implement best practices for data governance, documentation, and model maintenance in an Agile environment.