Analytics Engineer

Koch Engineered Solutions
Wichita, United States of America
16 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Wichita, United States of America

Tech stack

Agile Methodologies
Artificial Intelligence
Data analysis
Azure
Business Intelligence
Code Review
Information Systems
Continuous Integration
Information Engineering
Data Transformation
Data Warehousing
Database Queries
Dimensional Modeling
Metadata
Power BI
SQL Databases
Macros
Snowflake
GIT
Powerquery
Data Layers
Build Management
Microsoft Fabric
Information Technology
Optimization Algorithms
Software Version Control

Job description

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

Requirements

Do you have experience in Version control?, Do you have a Bachelor's degree?, * 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

Benefits & conditions

Pulled from the full job description

  • Tuition reimbursement
  • Paid parental leave
  • AD&D insurance
  • Parental leave
  • Health insurance
  • Vision insurance
  • Health savings account

About the company

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 ., 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.

Apply for this position