Senior Power BI & Microsoft Dynamics 365 Reporting Consultant.

We are looking for an experienced Power BI consultant to support the development of enterprise‑grade reporting and analytics based on Microsoft Dynamics 365 and identity/governance data from Microsoft Entra ID and Entra ID Governance.

The consultant will work closely with internal architects, IT, and business stakeholders to design and implement secure, scalable, and governance‑aligned Power BI reports, including integration with third‑party data source systems such as Probroker.

Key Responsibilities

Power BI Development

• Design, develop, and maintain Power BI datasets, reports, and dashboards for business and compliance use cases

• Implement robust data models (star schema, fact/dimension modeling) optimized for performance and reuse

• Apply best practices for DAX, calculated measures, and data transformations

• Support both self‑service BI and centrally governed reporting

Microsoft Dynamics 365 Data Integration

• Extract, transform, and model data from Microsoft Dynamics 365 / Dataverse

• Work with standard and custom Dynamics 365 entities

• Ensure correct handling of relationships, history, and ownership in CRM data

• Collaborate with architects and application owners on data semantics and definitions

Identity & Governance Reporting

• Integrate and use data from:

  • Microsoft Entra ID

  • Microsoft Entra ID Governance (e.g. access reviews, entitlement management, lifecycle data)

• Build reports supporting:

  • Access control visibility

  • Governance and compliance reporting

  • Identity lifecycle and access insights

Third‑Party System Integration

• Integrate data from external systems, such as Probroker, into Power BI solutions

• Design and maintain data ingestion pipelines (e.g. via APIs, exports, or intermediate storage)

• Ensure data quality, reconciliation, and traceability across systems

Security, Governance & Quality

• Implement row‑level security (RLS) and role‑based access in Power BI

• Align reporting solutions with information security, data protection, and governance requirements

• Document data models, report logic, and dependencies

• Support testing, validation, and handover to internal teams

Required Competence & Experience

Must‑Have

• Strong hands‑on experience with Power BI (datasets, reports, DAX, Power Query)

• Proven experience working with Microsoft Dynamics 365 / Dataverse as a reporting source

• Solid understanding of data modeling and BI best practices

• Experience integrating identity and access data, preferably from Microsoft Entra ID

• Ability to work independently in a complex enterprise environment

• Strong communication skills, able to collaborate with both technical and non‑technical stakeholders

Nice‑to‑Have

• Experience with Microsoft Entra ID Governance reporting (access reviews, entitlements, lifecycle)

• Experience integrating financial or trading systems such as Probroker

• Familiarity with Microsoft Fabric, Azure Data Lake, or Synapse

• Experience from regulated environments (e.g. finance, compliance, risk, security)

• Understanding of data governance, audit, and compliance reporting

Technical Environment (Indicative)

• Microsoft Power BI

• Microsoft Dynamics 365 / Dataverse

• Microsoft Entra ID & Entra ID Governance

• Azure / Microsoft Fabric (where applicable)

• Third‑party source systems (e.g. Probroker)

• Devops