EngineerJobs.io
← Back to all jobs

Job Description

What we offer

Robert Half is seeking an onsite Analytics Engineer for a contract opportunity in Urbandale, IA, with a path to permanent employment. The role centers on building scalable data models and BI solutions that turn complex information into clear, reliable insights across both on premises and cloud environments. This position emphasizes delivering dependable analytics to support informed business decisions.

Responsibilities

  • Design and maintain dimensional data models to support reporting needs, including star and snowflake schemas, fact tables, dimension tables, and slowly changing dimensions.
  • Develop relational models using solid database design principles, ensuring appropriate keys, entity relationships, and data integrity standards.
  • Create and refine semantic layers for reporting and analytics in Power BI, Microsoft Fabric, and tabular modeling environments.
  • Build calculations, measures, and reusable logic to improve reporting consistency and support trusted business definitions.
  • Collaborate 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 platforms such as Fabric, Synapse, Databricks, or similar technologies.

Requirements

  • 3+ years of experience in analytics engineering, business intelligence, or a closely related data-focused role.
  • Strong knowledge of dimensional modeling concepts, including star schemas, snowflake schemas, fact tables, dimension tables, and slowly changing dimensions.
  • Experience with relational database design, including entity relationship diagrams, normalization, denormalization, and referential integrity.
  • Hands-on expertise with Power BI and business intelligence modeling, including semantic models, tabular models, and advanced reporting logic.
  • Proficiency in DAX and Power Query (M) for data transformation and analytical model development.
  • Familiarity with Microsoft Fabric and at least one cloud analytics platform such as Azure Synapse, Databricks, or a comparable solution.
  • Understanding of data governance, master data concepts, and the importance of maintaining consistent business definitions.

Technologies

  • Power BI
  • Microsoft Fabric
  • Azure Synapse
  • Databricks
  • Power Query (M)
  • DAX
  • Tabular modeling

Benefits

  • medical, vision, dental, and life and disability insurance
  • 401(k) plan

Similar Jobs