Senior Power BI Developer Data Engineer

Ampa Group; Birmingham; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading analytics firm is seeking a Senior Power BI Developer & Data Engineer for a 12-month fixed-term contract. This role involves developing enterprise-grade analytics and data solutions while enabling flexible working conditions. The candidate will focus on Power BI development, data pipeline engineering, and financial modelling, while working with cross-functional teams. Strong experience in Power BI, Microsoft Fabric, and Azure is essential.

Benefits

Agile working environment

Flexible working arrangements

Diverse and inclusive workplace

Opportunities for professional development

Qualifications

• Proven delivery of enterprise Power BI solutions.
• Hands-on experience with Microsoft Fabric and Azure.
• Experience building financial and debt-related models.

Responsibilities

• Lead the design and optimize Power BI dashboards for finance.
• Engineer data pipelines using Microsoft Fabric.
• Deliver validated financial models and role-based reports.

Skills

Power BI solutions delivery

Microsoft Fabric

Azure fundamentals

Dimensional modelling

Financial/debt-related models

Tools

DAX

Power Query M

SQL

Job description

Senior Power BI Developer & Data Engineer

Department: Ampa Group Services - Chief Information Office - Applications & Development - Data & Analytics - 9311

Employment Type: Fixed Term - Full Time

Location: Flexible

Reporting To: James Parke

Description

Senior Power BI Developer & Data Engineer. 12month Fixed Term Contract. We have a blended work to your diary approach where we flex where, when and how we work, with attendance at our hub spaces 1 or 2 times a month – as team meetings and client. Join AMPA’s Data & Analytics team as a Senior Power BI Developer & Data Engineer, delivering enterprise grade analytics and data solutions across debt finance (DebtTrak/Aderant) and Peppermint CMS reporting. You’ll work closely with our Data Manager & Fabric Administrator to establish a scalable, governed data platform, flexing between development, engineering, and modelling as priorities shift. The role is remote-first, with UK hub attendance for collaboration.

What you will be doing:

• Power BI Development & Engineering: 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

Financial Modelling & Reporting

• 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

Platform Enablement & Collaboration

• 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

Key Competencies

• 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

Benefits, Agile Working and Additional information

We embrace agile working and offer a blended approach to where and how we work. We appreciate that people have different needs and preferences and we’re keen to be flexible, after all, we value what you do, not where you do it.

We have the following hubs across the UK: Birmingham, Bristol, Edinburgh, Leeds, Leicester, Lincoln, London, Milton Keynes, Nottingham, Sheffield, Solihull, Stratford upon Avon and in the South East; Brighton, Chichester, Crawley, East Grinstead, Eastbourne, Lewes, Peacehaven, Seaford, Storrington, Southampton & Tunbridge Wells.

Additional information
Want to find more about our benefits?

Please be aware, for some vacancies, where we receive high numbers of applications we may need to bring the close date forward.

Due to the nature of the work undertaken, confirmation of employment will be subject to a variety of checks which will be carried out once an offer of employment is accepted. Details of the checks can be found here.

Equal opportunities
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. We value and respect individuality and encourage a culture within our business where people can be themselves and be valued for their strengths and experiences. Everyone who either applies to or works for the firm is treated equally, regardless of their gender, age, ethnic origin, nationality, marital status, sexual orientation or religious beliefs.