The firm Birketts is a full service, UK Top 50 law firm. With a heritage spanning 160 years, we have more than 700 lawyers and legal professionals based in Bristol, Cambridge, Chelmsford, Ipswich, London, Norwich and Sevenoaks. We advise businesses, government and public sector organisations and individuals in the UK and internationally across four principal practice groups: property, corporate services, litigation and private client advisory. We are defined by our Next Level Law proposition. We work with our clients as a proactive partner, horizon scanning and thinking ahead to the changes, challenges or opportunities that they may face. Next Level Law is also applied to our people. Our collegiate culture means everyone is encouraged to achieve their next level in everything they do. RollOnFriday recently ranked us as the 5th best law firm to work at in 2024. With our ambition to succeed, comes a strong desire to make a positive contribution to the communities we serve, and we are committed to delivering the objectives set out in our ESG strategy. Diversity plays an integral part in all that we do, with female partners comprising 40% of our partnership. Purpose of job We are seeking a highly skilled and experienced Lead Power BI Analyst to join our dynamic Projects and Strategic Development Team. The successful candidate will play a pivotal role in driving data visualisation, analytics, and business intelligence initiatives, empowering stakeholders to make informed decisions. A strong knowledge of Microsoft Fabric will be an advantage as we continue to adopt cutting-edge technologies in our data strategy. The Lead Power BI Analyst will be responsible for the development and maintenance Business Intelligence reporting systems, delivering robust and accessible intelligence products to guide and inform evidence-based decision-making. This will require working directly with senior managers, service leads, partner organisations, external consultants, system suppliers and colleagues in the IT’s Data Systems Team as needed. Accountabilities Design, develop, and maintain Power BI dashboards and reports : Create visually appealing and user-friendly dashboards that effectively communicate key insights. Ensure these dashboards meet the needs of various stakeholders and are tailored for specific business use cases. Continuously improve and update reports to reflect changing business requirements. Collaborate closely with IT colleagues to ensure data availability, quality, and integration across systems : Work with IT teams to establish robust data pipelines and ensure seamless data flow. Troubleshoot and resolve data-related issues promptly. Maintain strong relationships with IT to align technical efforts with business objectives. Work with stakeholders to gather and understand requirements, translating them into effective data solutions : Conduct workshops, meetings, and interviews to identify business needs. Translate these needs into technical specifications, ensuring that data solutions are aligned with organisational goals. Drive the adoption of new tools and technologies, including Microsoft Fabric, to enhance data capabilities : Stay abreast of emerging technologies and trends. Advocate for and lead the integration of new tools and platforms to enhance data infrastructure and analytics capabilities. Provide mentorship and technical leadership to junior analysts within the team : Guide and support less experienced team members in developing their technical and analytical skills. Foster a collaborative and supportive team environment. Ensure compliance with data governance policies and security protocols : Uphold organisational standards for data privacy, security, and governance. Implement processes to ensure data is handled responsibly and complies with relevant regulations. Monitor and optimise the performance of Power BI reports and datasets : Regularly review and improve the performance of dashboards and datasets. Identify and resolve bottlenecks, ensuring fast and reliable access to data for all users. Support the Head of Data and Business Intelligence in strategic planning and project execution : Assist in defining and executing the data strategy. Contribute to the planning and delivery of key projects, ensuring alignment with organisational objectives. Qualifications/Experience At least 5 years proven experience in a similar role, with expertise in Power BI development and administration : Demonstrated track record of creating impactful Power BI solutions and leading analytics initiatives. Extensive experience in managing and optimising Power BI environments. Strong proficiency in DAX, Power Query, and data modelling : Advanced skills in writing DAX formulas, using Power Query for data transformation, and designing efficient data models to support complex analyses. Experience in data integration from multiple sources, including databases, APIs, and cloud services : Proficiency in integrating data from various platforms and ensuring its consistency and reliability. Familiarity with data extraction, transformation, and loading (ETL) processes. Strong analytical and problem-solving skills, with a focus on delivering actionable insights : Ability to dissect complex data sets, identify trends, and deliver insights that drive business decisions. Knowledge of Microsoft Fabric and its components (Synapse, Dataflows, Data Activator, etc.) is a significant advantage : Awareness of the capabilities of Microsoft Fabric tools and their applications in enhancing data management and analytics processes. Familiarity with SQL, data warehousing concepts, and ETL processes : Solid understanding of relational databases, data warehousing techniques, and ETL tools. Proficiency in writing and optimising SQL queries. Ability to work collaboratively within a cross-functional team environment : Experience working in multi-disciplinary teams, fostering collaboration and aligning diverse perspectives to achieve shared goals. Equal opportunities At Birketts, our culture is driven by ambition and a commitment to positively impact all the communities we serve. We are dedicated to the success, development, and wellbeing of our colleagues, helping them achieve their goals and seize the opportunities that come with our growth. Alongside a flexible and inclusive work environment, we offer the following core benefits: 25 days holiday (FTE) plus Bank Holidays (rising to 30 days) Long Service holiday award – 1 extra week every 10 years continuous service Private Healthcare with BUPA (offered after probation is passed) Scottish Widows Pension Scheme (5% employer / 5% Employee) Staff Profit Share and Individual Performance Bonus Scheme Salary sacrifice (Pensions, Staff Profit Share) Life Assurance - 4 x salary / Permanent Health Insurance Paid CSR Day Enhanced Maternity/Paternity Leave Subsidised gym membership Electric car scheme Agile/Hybrid Working Policy Dress for your Day Policy https://www.birketts.co.uk/recognition-reward-benefits/ Birketts is a flexible business which has embraced a hybrid working model where our colleagues enjoy a mix of home and office working. We welcome applications from people looking for flexible, agile, and part-time roles and we are happy to explore your preferred working patterns as part of your application. Please note that this job profile is not an exhaustive list of duties but merely an outline of the key components of the role. You may be required by your line manager to take on additional responsibilities when requested. Birketts is committed to being an Equal Opportunity Employer. Our policy is unequivocal: we do not tolerate discrimination based on age, disability, sex, race, religion or belief, gender reassignment, marriage or civil partnership, pregnancy or maternity, or sexual orientation. We pride ourselves on being an inclusive organisation that actively promotes equality of opportunity for all, valuing the right mix of talent, skills, and potential. We welcome applications from a diverse range of candidates, and selection for roles is based solely on individual merit.