Power BI Specialist at Mayfly Agri (Pty) Ltd

• A full-service law firm providing legal advice to UK and international businesses, as well as individuals and families, is seeking a Power BI Specialist to develop, manage, and optimise the firm's business intelligence and reporting capabilities. Working closely with legal, finance, operational, and IT stakeholders across the UK and South Africa, the successful candidate will transform complex data into meaningful insights that support strategic decision-making, improve operational efficiency, and enhance business performance. This role is critical in driving a data-led culture throughout the firm.

Minimum requirements for the role:

• Must have a Bachelor's Degree in Information Systems, Data Science, Computer Science, Statistics, or a related field
• Minimum 3 years' professional experience developing and supporting Power BI solutions
• Advanced Power BI expertise, including dashboard development, data modelling, and report optimisation
• Strong SQL skills with experience querying and managing relational databases
• Experience working with Microsoft Azure environments and data warehousing solutions
• Proficiency in DAX (Data Analysis Expressions) for complex calculations and business reporting requirements

The successful candidate will be responsible for:

• Designing, developing, and maintaining interactive Power BI dashboards, reports, and visualisations to support legal, financial, and operational teams.
• Gathering business requirements from stakeholders and translating them into effective reporting and analytics solutions.
• Developing and maintaining robust data models, ensuring data integrity, consistency, and accuracy across reporting platforms.
• Analysing trends, patterns, and business performance metrics to provide actionable insights and recommendations.
• Supporting reporting requirements relating to case management, client activity, business performance, resource utilisation, and financial forecasting.
• Collaborating with UK-based IT and data teams to optimise data pipelines, reporting processes, and data architecture.
• Developing and maintaining automated reporting solutions to improve efficiency and reduce manual intervention.
• Writing and optimising SQL queries to extract, manipulate, and analyse data from multiple sources.
• Utilising DAX to create advanced calculations, measures, and reporting functionality within Power BI.
• Supporting the ongoing development of data warehousing and reporting environments within Microsoft Azure.
• Providing training, guidance, and user support to staff, promoting effective adoption and utilisation of Power BI solutions.
• Troubleshooting reporting issues and proactively identifying opportunities for process improvement and enhanced analytics capabilities.