Power BI & Data Migration Specialist

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

Job summary

A leading data solutions company in the UK is seeking a skilled Power BI & Data Migration Specialist. The role involves designing and maintaining Power BI reports, delivering data migration solutions, and translating data into actionable insights. Candidates should have hands-on experience with Power BI, SQL, and data migration projects. This position requires collaboration with stakeholders to ensure accurate data delivery and understanding of Azure solutions. Competitive salary offered with flexible onsite requirements.

Qualifications

• Strong hands-on experience with Power BI.
• Proven ability to design robust data models.
• Solid SQL skills and understanding of relational models.

Responsibilities

• Design, develop, and maintain Power BI reports and dashboards.
• Deliver end-to-end data migration solutions from source systems.
• Support data migration activities including validation and reporting.

Skills

Power BI

SQL

Data migration projects

Data modelling with DAX

Azure SQL

Data validation

Tools

Azure Data Factory

Microsoft Fabric

Azure Data Lake

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