Power BI & Data Migration Specialist - MS Fabric

Crimson Limited; Birmingham; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading tech firm is seeking a Power BI & Data Migration Specialist in Birmingham to deliver high-quality reporting and support data migration initiatives. The successful candidate will design and develop Power BI solutions, manage data migrations, and ensure data accuracy. Essential skills include hands-on experience with Power BI, solid SQL skills, and familiarity with Azure-based platforms. This role is onsite for two days a month and offers a competitive salary.

Benefits

Competitive salary

Referral bonus

Flexible working options

Qualifications

• Experience in building and optimising Power BI datasets.
• Understanding of relational data models and data warehousing concepts.
• Experience validating data migrations and working with datasets.

Responsibilities

• Design and maintain Power BI reports and dashboards.
• Deliver end-to-end data migration solutions.
• Define KPIs, metrics, and visualisation standards.

Skills

Strong hands-on experience with Power BI

Proven ability to design robust data models

Strong hands-on experience with data migration projects

Solid SQL skills

Experience consuming data from Azure-based platforms

Tools

Power BI

Azure Data Factory

Microsoft Fabric

Job description

Power BI & Data Migration Specialist

Birmingham - x2 days per month onsite

Competitive Salary

(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.

Key Responsibilities

• 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.

Essential Skills & Experience

• 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.

Nice to Have

• 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 DevOps 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.