Analytics Engineer: AI-Ready BI & Semantic Modeling

Koch Engineered Solutions, LLC.; Wichita (KS); On-site; USD 85,000 - 120,000; Full time

Benefits offered by this job

Medical

Dental

Vision

Flexible spending and health savings

Life insurance

ADD

Disability

Retirement

Paid vacation/time off

Educational assistance

Infertility assistance

Paid parental leave

Job summary

Koch Engineered Solutions, LLC. is seeking an Analytics Engineer in Wichita, KS to design semantic models and BI solutions enabling AI-ready analytics for decision-makers.

You'll collaborate with analysts, business partners, and data engineers to convert raw data into trusted assets, build dimensional models, and develop Power BI reports with scalable, reusable layers. Strong Git workflows and CI/CD practices are required.

Qualifications

• Proven SQL data transformation experience for BI.
• Experience building dimensional data models for BI solutions.
• Hands-on Power BI semantic model and report development.
• Experience with Power Query (M) for data shaping.
• Team-based Git workflows (branches, PRs, reviews).

Responsibilities

• Collaborate with analysts and stakeholders to understand data gaps, define metrics, and design scalable analytics solutions.
• Design and build dimensional models that are clean and performant for end users.
• Develop and optimize SQL transformations converting raw data into reusable dimensional model objects.
• Create and maintain semantic models to support self-service analytics.
• Develop and maintain enterprise Power BI reports and dashboards with usability and performance in mind.
• Apply professional development practices: Git workflows, CI/CD, testing and validation.
• Coordinate with data engineers and architects to align on naming, documentation, data quality, and governance.
• Support adoption through documentation, stakeholder training, and improved discoverability.
• Troubleshoot data issues across models and reports, driving reliability.

Skills

SQL data transformation

Dimensional data modeling

Power BI report development

Power Query (M)

Git collaboration

Tools

dbt

Snowflake

Git-based version control

Job description

Koch Engineered Solutions, LLC. is seeking an Analytics Engineer in Wichita, KS to design semantic models and BI solutions enabling AI-ready analytics for decision-makers.

You'll collaborate with analysts, business partners, and data engineers to convert raw data into trusted assets, build dimensional models, and develop Power BI reports with scalable, reusable layers. Strong Git workflows and CI/CD practices are required.