Analytics Engineer

Your Job

Koch Engineered Solutions (KES) is currently looking for an Analytics Engineer to join our global Information Technology (IT) capability. The IT capability is a vital component of the KES strategy to improve business performance through the application of technology and to profitably transform our business. Our team operates with a startup mentality—working as an integrated group with the Engineering, Operations, Commercial, and Finance teams to design, build, and scale innovative solutions that transform KES work processes.

This role 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 the business. 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.

As an Analytics Engineer, 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.

What You Will Do

• Partner 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 Power BI 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)

• 3+ years in analytics engineering, BI development, or a similar role with significant data modeling responsibilities
• Bachelor’s degree in a quantitative, analytical, or engineering field (e.g., Data Science, Computer Science, Information Systems, Engineering, Mathematics) or equivalent practical experience delivering analytics outcomes
• Strong 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)
• Strong communication skills and comfort working directly with stakeholders

What Will Put You Ahead

• Deep knowledge of dimensional modeling best practices and optimization techniques
• Experience with dbt (models, tests, documentation, macros, exposures)
• Experience using Snowflake for data transformation, including developing SQL based pipelines and reusable model layers
• Experience with Microsoft Fabric for data engineering and BI development
• Familiarity with Azure DevOps (Repos, Pipelines, Boards) and Agile SDLC practices
• Experience designing reusable semantic standards for enterprise reporting
• Exposure to data quality and observability practices
• Experience enabling AI capable models through strong metadata, consistent definitions, curated semantic layers, and documentation
• Experience with Agentic development and workflows

Our Benefits

Our goal is for each employee, and their families, to live fulfilling and healthy lives. We provide essential resources and support to build and maintain physical, financial, and emotional strength - focusing on overall wellbeing so you can focus on what matters most. Our benefits plan includes - medical, dental, vision, flexible spending and health savings accounts, life insurance, ADD, disability, retirement, paid vacation/time off, educational assistance, and may also include infertility assistance, paid parental leave and adoption assistance. Specific eligibility criteria is set by the applicable Summary Plan Description, policy or guideline and benefits may vary by geographic region. If you have questions on what benefits apply to you, please speak to your recruiter.

Additionally, everyone has individual work and personal needs. We seek to enable the best work environment that helps you and the business work together to produce superior results.