Analytics Engineer

Koch Engineered Solutions (KES) is seeking an Analytics Engineer to join our global Information Technology (IT) capability. 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 and partner with internal teams and external solution providers to accelerate progress toward KES objectives. 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 professional development practices: Git‑based version control, branching/PR workflows, testing/validation, CI/CD. 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. 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 models 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 Medical, dental, and vision coverage. Flexible spending and health savings accounts. Life insurance and disability coverage. Retirement plan. Paid vacation and time off. Educational assistance. Potential infertility assistance, paid parental leave, and adoption assistance (subject to eligibility). Equal Opportunity Employer Equal Opportunity Employer, including disability and protected veteran status. Except where prohibited, some offers of employment are conditioned upon successfully passing a drug test. This employer uses E‑Verify. For Illinois E‑Verify information, click here, aquí, or tu. #J-18808-Ljbffr Koch