Join Koch Engineered Solutions to design analytics-ready semantic models and Power BI reporting that help teams make confident decisions.

Collaborate with analysts and business stakeholders to understand data gaps, define metrics, and shape robust, scalable analytics solutions
Propose alternative approaches and outline pros and cons to move the workstream forward
Design and build dimensional models that are clean, performant, and easy to use
Develop and optimize SQL transformations to convert raw data into reusable dimensional model objects
Create and maintain semantic models that support clear, efficient self-service analytics
Develop enterprise Power BI reports and dashboards with emphasis on usability, performance, and consistent business definitions
Apply professional development practices including Git-based version control, branching/PR workflows, testing/validation, and CI/CD
Coordinate with data engineers, architects, and analytics engineers 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 tied to models and reports, then continuously improve reliability and performance

Demonstrated ability to use SQL 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, including branches, PRs, and code reviews

Deep knowledge of dimensional modeling best practices and optimization techniques
Experience with dbt (models, tests, documentation, macros, exposures)
Experience collaborating with a Finance team or in the Financial Services industry
Experience using Snowflake for data transformation and for developing SQL-based pipelines and reusable model layers
Experience designing reusable semantic standards for enterprise reporting
Experience enabling AI-capable models through strong metadata, consistent definitions, curated semantic layers, and documentation

Analytics Engineer

Job Description