Senior Power BI Developer Data Engineer

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 amazing 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. About Ampa Group Welcome to Ampa - a leading group of legal and professional services brands, home to leading legal services firms such Shakespeare Martineau, Lime Solicitors, Mayo Wynne Baxter, Marrons and others. Our ‘House of Brands’, is where legal and professional service brands converge to unlock exciting opportunities for career advancement, collaboration, and comprehensive business services support across various disciplines including HR, IT, finance, and marketing. Our overall purpose is to act as the cornerstone that facilitates the growth of every brand within our collective, empowering them with enhanced purchasing capabilities, access to specialised expertise, and a cohesive set of values and culture. At our core, we are dedicated to creating an environment where each brand thrives through mutual growth and co-operation. Through our shared infrastructure and central support, we enable our brands to flourish, using the strength of our collective resources. If you are passionate about driving positive change and immersing yourself in an inclusive, diverse, and supportive culture, then we invite you to join our team as we continue to unlock the potential in our people, clients, and investors.