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.
#J-18808-Ljbffr