Power BI & Data Migration Specialist

Zip Hustle; Birmingham; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading data solutions provider in Birmingham is searching for a Power BI & Data Migration Specialist to develop insightful reporting and execute data migration initiatives. This role requires a deep understanding of Power BI for building reports and dashboards, as well as strong experience with data migration processes and SQL. The candidate will work closely with various stakeholders to ensure a seamless data flow and deliver actionable insights. A competitive salary is offered for this position.

Qualifications

• Strong hands-on experience with Power BI for reports and dashboards.
• Proven ability to design robust data models for analytical use cases.
• Experience with ETL/ELT data migration projects and validation.

Responsibilities

• Design and maintain Power BI reports and dashboards.
• Deliver end-to-end data migration solutions into modern platforms.
• Build and optimize datasets using data modeling and DAX.

Skills

Power BI

Data migration

SQL

Data validation

DAX

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.