Senior Power BI Developer Data Engineer

Ampa - Legal & Professional Services; England; On-site; GBP 55,000 - 80,000; Full time

Job summary

A professional services company is looking for a Senior Power BI Developer & Data Engineer to deliver enterprise-grade analytics and data solutions. The role involves leading the design and optimization of Power BI dashboards, engineering data pipelines using Microsoft Fabric, and ensuring compliance with data governance. Ideal candidates will have proven experience in Power BI, SQL, and Azure fundamentals, along with strong analytical skills.

Qualifications

• Proven delivery of enterprise Power BI solutions (DAX, Power Query M, SQL).
• Hands-on experience with Microsoft Fabric (Lakehouse, Dataflows Gen2, Pipelines).
• Strong analytical problem-solving skills.

Responsibilities

• Lead the design, build, and optimize Power BI dashboards and reports.
• Engineer data pipelines using Microsoft Fabric and Azure integration.
• Document solutions, create user guides, and contribute to a knowledge base.

Skills

Power BI solutions delivery

Microsoft Fabric

Azure fundamentals

Dimensional modelling

Financial/debt-related models

Education

Microsoft Certified Power BI Data Analyst or Fabric Analytics Engineer

Job description

Join to apply for the Senior Power BI Developer Data Engineer role at Ampa - Legal & Professional Services

Senior Power BI Developer & Data Engineer

12-month Fixed Term Contract

Ampa’s Data & Analytics team is seeking a Senior Power BI Developer & Data Engineer to deliver enterprise-grade analytics and data solutions across debt finance (DebtTrak/Aderant) and Peppermint CMS reporting.

What you will be doing:

• Lead the design, build, and optimise Power BI dashboards, reports, and semantic models for finance, debt, and operation teams
• Engineer data pipelines using Microsoft Fabric (Lakehouse, Dataflows Gen2, Pipelines) and Azure integration
• Model data from DebtTrak, Aderant, and Dynamics-based CMS into governed, blended and scalable datasets
• Implement incremental refresh, composite models, calculation groups, and performance tuning
• Configure and manage Power BI workspaces, deployment pipelines, and access controls
• Automate reporting workflows and enable self-service analytics for business users
• Deliver validated financial models and role-based reports for debt, finance and legal services
• Integrate and reconcile data across multiple systems, ensuring accuracy and auditability
• Lead the transition from legacy reporting (SSRS) to Power BI, embedding best practices
• Champion the co-development of Fabric utilities, templates, and standards with the Fabric Administrator
• Drive adoption of data product conventions, Git integration, and monitoring/logging for scale
• Partner with Data Engineering, Finance, Legal Operations, and business stakeholders to mature the platform
• Document solutions, create user guides, and contribute to a knowledge base for repeatability

Governance & Compliance

• Embed GDPR, data protection, and least privilege access in solutions
• Certify datasets, apply sensitivity labels, and maintain audit-ready documentation
• Implement data quality checks, maintain data lineage documentation, and support audit readiness
• Ensure robust security and compliance across all reporting assets

What you will need:

Skills and experience Must have:

• Proven delivery of enterprise Power BI solutions (DAX, Power Query M, SQL)
• Hands-on experience with Microsoft Fabric (Lakehouse, Dataflows Gen2, Pipelines)
• Azure fundamentals (ADLS, managed identities, DevOps/Git)
• Dimensional modelling, data product thinking, performance optimisation
• Experience building financial/debt-related models and reports

Nice to have:

• Domain experience with Aderant and Dynamics/Peppermint
• Legal services data and finance process knowledge
• Automation of testing and documentation
• Microsoft Certified Power BI Data Analyst or Fabric Analytics Engineer
• Strong analytical problem-solving skills
• Ability to work with stakeholders across business and technical teams
• Excellent communication and presentation skills
• Collaborative and team-oriented approach
• Ability to drive process improvements proactively
• Adaptability in a fast-paced, evolving technological environment

Ampa Group is a committed equal opportunities employer. We seek to attract, develop and retain talented people from a diverse range of backgrounds and cultures.