BI Analyst Business Area: IT Place of Work: Liverpool Contract Type: Fixed Term Contract When you join USS, the size and scale of our pension scheme means you will have numerous opportunities to learn and develop your career. Given our size, you'll have real autonomy and influence as you collaborate closely with a wide-ranging team of experts. Our office is a vibrant place to work, and we offer flexibility of office/homeworking due to our hybrid model. About the role In your role as BI Analyst, you will make a meaningful and valued contribution from the outset. This role will provide a great opportunity to be responsible for developing and maintaining advanced data models, dashboards, and reports using Microsoft Power BI. The role requires strong technical expertise in DAX, Power Query (M), and SQL to transform complex datasets into insightful visualisations that support business decision-making. You will work with data from multiple sources - both cloud-based and on-premise - and ensure the accuracy, performance, and scalability of reporting solutions. Familiarity with pensions data is highly desirable, as you will be expected to handle sensitive and regulated information with precision and compliance. A key objective of this role is to lead the transition of reporting solutions into an end-user ownership model. This will involve designing intuitive, self-service analytics tools, providing documentation and training, and empowering business users to independently explore and interpret data. The successful candidate will demonstrate a strong understanding of data governance, ETL processes, and stakeholder engagement, ensuring that solutions are not only technically robust but also sustainable and user-friendly. What you will be doing As a trusted part of the IT you will: Design, develop, and maintain interactive dashboards and reports using Power BI Desktop and Power BI Service. Collaborate with stakeholders to gather requirements and translate them into effective data visualisations. Build and optimise SQL queries, stored procedures, and views to support reporting needs. Integrate data from multiple sources such as SQL Server, Excel, SharePoint, and cloud-based platforms. Ensure data quality, consistency, and governance across all reporting solutions. Support the development and maintenance of semantic data models and DAX measures. Participate in the attestation and governance processes as outlined in the Power BI Framework and Software Development Policy. Provide training and support to business users to effectively handover the Power BI solutions for ongoing user ownership & management. Work collaboratively with stakeholders to ensure reporting solutions meet requirements. Engage with report consumers to assess and define the best approach to building value add reports. Produce the reporting solution in line with a consumer ownership model to enable stakeholder handover for ongoing management. About you We know that sometimes people can be put off applying for a job if they don't tick every box, if you're excited about working for us and have most of the skills or experience we're looking for, then please apply, regardless of whether you meet all the requirements outlined in this profile. To be successful in the role you will have: Proven experience with Microsoft Power BI (Desktop and Service). Strong SQL skills, including experience with SQL Server, SSIS, Azure, Fabric and data modelling. Familiarity with data governance, security, and compliance standards. Experience working with large datasets and complex data transformations. Ability to communicate technical concepts to non-technical stakeholders. Experience in the pensions sector or financial services is highly desirable. Excellent communication skills: able to present complex business solutions, both written and verbal, to key stakeholders Why join us? At USS, every individual contributes to building a secure financial future for our members and their families. ? We strive to create a work environment where everyone can thrive professionally while making a meaningful impact on the lives of others. ? We're also committed to helping you build your career by providing opportunities for development. We put a focus on recognising and supporting each individual's unique career path, driving this forward with the support of an engaged and proactive management team. ? Here at USS, we want you to thrive in and out of work with a friendly team, flexible culture and excellent range of benefits! How we will reward you ? ? Great starting salary Generous annual leave package Access to a high quality pension scheme provided through Universities Superannuation Scheme Supportive people policies (including enhanced occupational sickness pay and family friendly pay) Financial contributions towards your personal development to help you maintain your physical and mental wellbeing Access to a range of health and wellbeing services i.e., private healthcare, discounted gym membership Learning and development opportunities to develop your skills, knowledge and talent Employee Volunteer Days to support the communities where you work and live Cycle to Work Scheme Our culture and values Our people are what makes us different. We work together to create a diverse and inclusive culture that embraces individuality, where people are welcomed and feel comfortable in the knowledge that they can be themselves. ? Our purpose firmly states the importance of members, putting them front and centre of what we do. This is embedded through our values: Integrity Collaboration Excellence About us Universities Superannuation Scheme (USS) was established in 1974 as the principal pension scheme for universities and higher education institutions in the UK. We work with around 330 employers to help build a secure financial future for more than 528,000 members and their families. We are one of the largest pension schemes in the UK, with total assets of around £75.5bn (at 31 March 2023). USSL is proud to be an equal opportunity employer. We strive to ensure our recruitment process is as flexible and inclusive as possible so we can attract diverse candidates and recruit the best talent.