Power BI & Data Migration Specialist

Crimson, Birmingham, England, United Kingdom

Birmingham - x2 days per month onsite

(Sponsorship is not provided for this opportunity)

We are looking for a skilled Power BI centric Data Specialist to deliver high-quality reporting and insights alongside supporting data migration initiatives. The role will focus primarily on Power BI reporting and data migration activities
, working closely with technical and business stakeholders to ensure accurate, reliable and insightful data delivery.

• Design, develop and maintain Power BI reports, dashboards and semantic models aligned to business requirements.
• Design and deliver end‑to‑end data migration solutions from source systems into modern data platforms (Azure SQL, Data Lake, Fabric, etc.).
• Work closely with stakeholders to define KPIs, metrics and data visualisation standards
  .
• Build and optimise Power BI datasets using efficient data modelling and DAX.
• Support data migration activities
  , including data validation, reconciliation and post‑migration reporting.
• Translate raw and migrated data into clear, actionable insights for business users.
• Ensure data accuracy, performance and usability across BI solutions.
• Strong hands‑on experience with Power BI (reports, dashboards, datasets, DAX).
• Proven ability to design robust data models for analytical and reporting use cases.
• Strong hands‑on experience with data migration projects (ETL/ELT, data validation, cutover support).
• Solid SQL skills and understanding of relational data models.
• Experience consuming data from Azure‑based platforms (Azure SQL, Data Lake, Synapse, etc.).
• Experience supporting or validating data migrations and working with migrated datasets.

• Exposure to Microsoft Fabric (Lakehouse, Data Factory, Gen2 Dataflows, Direct Lake).
• Experience with Azure Data Factory and Synapse.
• Understanding of data warehousing concepts (Bronze/Silver/Gold layers).
• Familiarity with CI/CD or Dev Ops practices for data solutions.

Interested? Please submit your updated CV to Olivia Yafai at Crimson for immediate consideration.

Not interested? Do you know someone who might be a perfect fit for this role? Refer a friend and earn £250 worth of vouchers!

Crimson is acting as an employment agency regarding this vacancy.