Senior Data Intelligence Analyst – Microsoft Fabric, Power BI & AI

futureproof; United States; Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Freelance/B2B contract

Full-time engagement

Long-term cooperation

Fully remote within the EU

Job summary

futureproof is seeking a Senior Data Intelligence Analyst to transform clinical, operational, and commercial data into trusted metrics, actionable insights and production-ready analytical products. This is a hands-on, senior role blending Power BI, semantic modelling and stakeholder collaboration, with fully remote work across the EU.

You will gather requirements, design semantic data models, build dashboards, govern KPIs and deliver end-to-end BI solutions while coordinating with Data

Qualifications

• Senior experience in Business Intelligence, Data Analytics, Analytics Engineering or a similar field.
• Strong hands-on Power BI development experience.
• Advanced DAX skills.
• Strong SQL skills.
• Strong knowledge of semantic and dimensional data modelling.
• Experience designing fact tables, dimensions, relationships and star schemas.
• Proven experience defining and governing business KPIs.
• Ability to translate complex business requirements into practical analytical solutions.
• Experience owning BI or analytical products end to end.
• Strong data-validation and problem-solving skills.
• Excellent stakeholder-management and communication skills.
• Ability to work independently and challenge unclear or inconsistent business requirements.
• Professional English.

Responsibilities

• Gather and analyse requirements from business stakeholders.
• Translate business questions into KPIs, analytical models and reporting solutions.
• Design and maintain business and semantic data models.
• Develop governed measures and calculations using DAX.
• Build dashboards, reports and reusable analytical products in Power BI.
• Perform detailed analysis and translate findings into actionable business insights.
• Validate data, calculations and conclusions with relevant stakeholders.
• Ensure consistent KPI definitions across reports and business functions.
• Independently manage analytical solutions from requirement gathering to production delivery.
• Collaborate with Data Engineering on data availability, structure, quality and transformation requirements.
• Create clear documentation for semantic models, business definitions, KPIs and analytical products.
• Help prepare Power BI semantic models for AI-assisted and natural-language analytics.
• Contribute to the development of scalable and governed BI practices.

Skills

Power BI

DAX

SQL

Semantic modeling

Star schema

KPIs

Stakeholder mgmt

End-to-end BI

English

Tools

Microsoft Fabric

PBIP

Git

CI/CD

Snowflake

Power BI Direct Lake

OneLake

Delta tables

Fabric Lakehouse

Job description

This is a remote position. Our client, a European leader in reproductive medicine, is looking for a Senior Data Intelligence Analyst to transform complex clinical, operational and commercial data into trusted metrics, actionable insights and production-ready analytical products. This is a senior, hands-on role combining Power BI development, semantic data modelling, business analysis and stakeholder collaboration.

Responsibilities

• Gather and analyse requirements from business stakeholders.
• Translate business questions into KPIs, analytical models and reporting solutions.
• Design and maintain business and semantic data models.
• Develop governed measures and calculations using DAX.
• Build dashboards, reports and reusable analytical products in Power BI.
• Perform detailed analysis and translate findings into actionable business insights.
• Validate data, calculations and conclusions with relevant stakeholders.
• Ensure consistent KPI definitions across reports and business functions.
• Independently manage analytical solutions from requirement gathering to production delivery.
• Collaborate with Data Engineering on data availability, structure, quality and transformation requirements.
• Create clear documentation for semantic models, business definitions, KPIs and analytical products.
• Help prepare Power BI semantic models for AI-assisted and natural-language analytics.
• Contribute to the development of scalable and governed BI practices.

Requirements

• Senior experience in Business Intelligence, Data Analytics, Analytics Engineering or a similar field.
• Strong hands-on Power BI development experience.
• Advanced DAX skills.
• Strong SQL skills.
• Strong knowledge of semantic and dimensional data modelling.
• Experience designing fact tables, dimensions, relationships and star schemas.
• Proven experience defining and governing business KPIs.
• Ability to translate complex business requirements into practical analytical solutions.
• Experience owning BI or analytical products end to end.
• Strong data-validation and problem-solving skills.
• Excellent stakeholder-management and communication skills.
• Ability to work independently and challenge unclear or inconsistent business requirements.
• Professional English.

Preferred experience

• Microsoft Fabric.
• Fabric Lakehouse and OneLake.
• Power BI Direct Lake.
• Delta tables and medallion architecture.
• Dataflows Gen2 or Fabric Data Pipelines.
• Migration from Snowflake or another analytical platform to Microsoft Fabric.
• Power BI Projects-PBIP.
• Git, version control and CI/CD practices for Power BI.
• AI-augmented analytics or Power BI Copilot.
• Preparing semantic models for natural-language interaction.
• MCP-Model Context Protocol or comparable AI integration experience.
• Experience with clinical, healthcare, operational or multi-country business data.

Tech Stack

• Power BI
• DAX
• SQL
• Microsoft Fabric
• Semantic models
• Lakehouse / OneLake
• Direct Lake
• Git and PBIP
• AI-enabled analytics

Benefits

• Freelance/B2B contract
• Full-time engagement
• Long-term cooperation
• Fully remote within the European Union.