Analytics Engineer Des Moines, IA

Analytics Engineer

We are looking for an Analytics Engineer to join a business services team in Urbandale, Iowa on a contract basis with the potential for a permanent role. This role focuses on building scalable data models and business intelligence solutions that turn complex information into clear, reliable insights. The ideal candidate brings strong experience in data warehousing concepts, BI semantic modeling, and modern analytics platforms across both on-premises and cloud environments.

Responsibilities:

• Design and maintain dimensional data models that support reporting needs, including star and snowflake structures, fact tables, dimension tables, and slowly changing dimensions.
• Develop relational models using sound database design principles, ensuring appropriate use of keys, entity relationships, and data integrity standards.
• Create and enhance semantic layers for reporting and analytics in Power BI, Microsoft Fabric, and tabular modeling environments.
• Build calculations, measures, and reusable logic that improve reporting consistency and support trusted business definitions.
• Partner with stakeholders to translate business questions into scalable BI models and actionable analytical solutions.
• Apply data governance practices to improve model quality, consistency, and alignment with enterprise reporting standards.
• Use DAX and Power Query to prepare, model, and optimize data for dashboards, reporting, and self-service analytics.
• Contribute to analytics solutions that connect on-premises data environments with cloud-based platforms such as Fabric, Synapse, Databricks, or similar technologies.