Lead BI developer in Gloucester

UCAS is at the heart of connecting people to higher education. UCAS is the world’s leading shared admissions service for higher education. We provide application services for UK universities and colleges as well as delivering a wide range of research, consultancy and advisory services to schools, colleges, careers services, professional bodies and employers. We’re a successful and fast-growing organisation, which helps hundreds of thousands of people every year. We’re committed to delivering a first-class service to all of our customers — they’re at the heart of everything we do.

About The Role

35.00 contractual hours. As part of the UCAS Business Intelligence and Reporting team, you’ll lead on shaping UCAS data into useable self-serve outputs for both technical and non-technical audiences, through development of reporting pipelines and reports. You will build reports, often in PowerBI, to deliver UCAS data to key stakeholders, both internally and externally. You’ll have excellent numerate, analytical, and logical thinking skills, and a drive to find out things that really matter from data.

Key accountabilities

• Lead the team on maintenance and development of UCAS’ Business Intelligence platform, including dashboard development, establishing flows of data from the Data Platform to dashboards, and governance of the BI estate.
• Foster strong relationships with colleagues around the business, enabling you to collaborate, define and refine PowerBI reporting requirements.
• Lead the team on collaboration with the Data Platform team to establish reporting requirements as new data sources are integrated into the Data Platform.
• Lead the team on transforming data models in the Data Warehouse into schemas suitable for use in PowerBI reporting.
• Lead the team on utilising PowerBI to build automated, interactive dashboards and reports, establishing high-quality self-serve BI across the business, and high-quality reporting externally.

Skills, Qualifications, And Experience

• Qualified to a high level in a numerate discipline, such as mathematics, statistics, computer science, operational research, data science, or a related field – evidenced through a Bachelor’s degree (or higher) or demonstrable experience.
• Good working knowledge of PowerBI and Data Analysis Expressions (DAX).
• Good working knowledge of data model design principles.
• Good working knowledge of ETL processes in the PowerBI service, and the PowerBI service more broadly.
• Good working knowledge of SQL.
• Good working knowledge of dashboard UI/UX best practices.
• A collaborative nature and the ability to communicate effectively with both technical and non-technical audiences.
• A natural curiosity and drive to find things out that really matter from data.
• A high level of numerate, analytical and logical thinking.
• Pick up new areas of work quickly, are unphased by challenges, and work at pace as a self-starter.
• Proven experience in efficiently transforming data to be used for different purposes.
• Experience of coaching peers or junior members of staff.

Package

• Salary up to £45,000
• Purpose-driven work in a charity-led organisation connecting people to education and opportunity
• Internal training, mentoring, and access to industry-recognised certifications through our development academies
• Hybrid working model built on trust and flexibility, with a 35-hour week and flexible contracts
• 30 days annual leave, 3 concessionary days over Christmas, bank holidays, and the option to purchase additional leave
• Everyday wellbeing support through Perkbox, offering discounts and wellness tools
• Onsite facilities including a subsidised gym, café, and free parking at our Cheltenham office
• Inclusive culture supported by employee networks, wellbeing champions, and Mental Health First Aiders
• Recognition and reward through our quarterly employee scheme and an ex-gratia bonus for going above and beyond

Studies have shown that some groups of people are less likely to apply to a role unless they tick every box. At UCAS we recognise that talent comes in various forms and we are committed to delivering a fair and equitable recruitment process where applicants have an equal opportunity to demonstrate their skills. So, if you are interested in this vacancy, but don’t necessarily meet every single point on the job description, please apply.

If you have any questions and would like to find out more about the role before applying please email the Talent Acquisition team via careers@ucas.ac.uk.

Working Arrangements

Is fully remote working an option? No