Analytics Engineer

Koch; Wichita (KS); Sur place; USD 95 000 - 140 000; Plein temps

Avantages offerts par ce poste

Medical, dental, vision

401(k) with company match

Paid time off

Educational assistance

Résumé du poste

Koch Engineered Solutions (KES) seeks an Analytics Engineer to design and deliver semantic models and BI assets that empower decision-making across the enterprise. You will collaborate with analysts, business partners, and data engineers to transform raw data into trusted, AI-ready analytics and ensure they are discoverable and reusable.

Based in Wichita, KS, the role operates in an Agile environment with Git-based workflows, CI/CD, and data governance.

Qualifications

• Demonstrated experience building dimensional data models for BI applications.
• Strong SQL skills and ability to optimize data transformations.
• Experience with Power BI reports and semantic modeling.
• Proficiency with Git-based version control and CI/CD workflows.

Responsabilités

• Design and deliver semantic models and BI solutions for decision making.
• Collaborate with analysts, business partners, and data engineers to transform data.
• Develop enterprise Power BI reports with usable, consistent definitions.
• Follow development practices: version control, PR workflows, testing, and governance.
• Support data discoverability and user adoption through documentation.

Connaissances

Dimensional modeling

Power BI

Power Query (M)

Git workflows

Collaboration with analysts

DBT

Snowflake

AI-ready analytics

Outils

Power BI Desktop

SQL

Git

dbt

Snowflake

Description du poste

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
• 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 Finance team or in the Financial Services industry
• Experience using Snowflake for data transformation for developing SQL ‑ based pipelines and reusable model layers
• Experience enabling AI ‑ capable models through strong metadata, consistent definitions, curated semantic layers, and documentation

At Koch companies, we are entrepreneurs. This means we openly challenge the status quo, find new ways to create value and get rewarded for our individual contributions. Any compensation range provided for a role is an estimate determined by available market data. The actual amount may be higher or lower than the range provided considering each candidate's knowledge, skills, abilities, and geographic location. If you have questions, please speak to your recruiter about the flexibility and detail of our compensation philosophy.

Hiring Philosophy

All Koch companies value diversity of thought, perspectives, aptitudes, experiences, and backgrounds. We are Military Ready and Second Chance employers. Learn more about our hiring philosophy here .

Who We Are

As a Koch company, Koch Engineered Solutions (KES) is a dynamic network of businesses that work together to create an ecosystem of domain expertise to increase operational efficiency, improve safety, reduce waste, and reduce emissions.

At Koch, employees are empowered to do what they do best to make life better. Learn how our business philosophy helps employees unleash their potential while creating value for themselves and the company.

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.

Equal Opportunity Employer, including disability and protected veteran status. Except where prohibited by state law, some offers of employment are conditioned upon successfully passing a drug test. This employer uses E-Verify. Please click here for additional information. (For Illinois E-Verify information click here , aquí , or tu ). #LI-MW1