At a Glance
- Tasks: Lead the design and optimisation of Power BI dashboards and engineer data pipelines.
- Company: Ampa - a forward-thinking legal and professional services firm.
- Benefits: 12-month contract, competitive salary, and opportunities for professional growth.
- Other info: Join a diverse team committed to equal opportunities and innovation.
- Why this job: Make an impact by delivering enterprise-grade analytics in a dynamic environment.
- Qualifications: Proven Power BI experience and strong analytical skills required.
The predicted salary is between 36000 - 60000 £ per year.
Join to apply for the Senior Power BI Developer Data Engineer role at Ampa - Legal & Professional Services. This is a 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.
Senior Power BI Developer Data Engineer in England employer: Ampa - Legal & Professional Services
Ampa is an exceptional employer that fosters a collaborative and inclusive work culture, making it an ideal place for professionals seeking to grow in the field of data analytics. With a strong commitment to employee development, Ampa offers opportunities to work on cutting-edge technologies like Microsoft Fabric and Power BI, while ensuring a supportive environment that values diversity and innovation. Located in a vibrant area, employees benefit from a dynamic workplace that encourages creativity and professional advancement.
Contact Details:
Ampa - Legal & Professional Services Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Senior Power BI Developer Data Engineer in England
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work at Ampa or similar companies. A friendly chat can sometimes lead to insider info about job openings or even a referral.
✨Tip Number 2
Show off your skills! Prepare a portfolio showcasing your best Power BI projects and data engineering feats. When you get that interview, having tangible examples of your work can really set you apart from the crowd.
✨Tip Number 3
Be ready for technical challenges! Brush up on your DAX, Power Query M, and SQL skills. You might face some practical tests during interviews, so being well-prepared will help you shine.
✨Tip Number 4
Apply through our website! We love seeing applications directly from candidates who are genuinely interested in joining us. Plus, it gives you a better chance to stand out in the application process.
We think you need these skills to ace Senior Power BI Developer Data Engineer in England
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with Power BI and data engineering. Use keywords from the job description to show we’re on the same page about what you bring to the table.
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Share specific examples of how you've delivered enterprise Power BI solutions and worked with Microsoft Fabric. Let us see your passion for data!
Showcase Your Skills:Don’t just list your skills; demonstrate them! If you’ve built financial models or optimised performance, give us the details. We want to know how you can contribute to our team.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you don’t miss any important updates from us!
How to prepare for a job interview at Ampa - Legal & Professional Services
✨Know Your Power BI Inside Out
Make sure you’re well-versed in Power BI, especially DAX and Power Query M. Brush up on your experience with Microsoft Fabric and be ready to discuss how you've used these tools to deliver enterprise solutions.
✨Showcase Your Data Engineering Skills
Prepare examples of how you've engineered data pipelines and optimised performance. Be ready to explain your approach to dimensional modelling and how you’ve tackled challenges in building financial models.
✨Understand the Business Context
Familiarise yourself with the finance and legal services sectors, particularly around debt finance. This will help you connect your technical skills to the business needs of the role and demonstrate your ability to partner with stakeholders.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving skills and adaptability. Think of scenarios where you had to drive process improvements or manage compliance and security in your reporting assets, and be ready to share those experiences.
