BI Developer

General information Reference 001673 Publication start date 03/09/2024 Post Description BI Developer Location South West, Gloucestershire, Rosehill - Hybrid Job Profile Digital Services - Data Science and Statistics Title BI Developer Contract Type Full Time About us About UCAS 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. Business Unit description The Digital Services business unit is at the heart of UCAS’ technical innovation, data and infrastructure. It focuses on leveraging data science, technology, and enterprise architecture to enhance UCAS' digital products and services. The unit is dedicated to developing and improving customer-centric digital solutions, ensuring seamless and secure online experiences for all users. By providing insightful data and analysis, often made available to anyone with free-to-use intuitive dashboard, Digital Services empowers the Higher Education sector and those interested in the sector with valuable information to make informed decisions. By working in collaborative, expert led, multi-disciplinary teams, Digital Services drives UCAS’ mission to connect students with their next opportunities through advanced technological solutions. About the role Contractual Hours 35.00 About the role 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: · Support 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. · Collaborate with the Data Platform team to establish reporting requirements as new data sources are integrated into the Data Platform. · Transform data models in the Data Warehouse into schemas suitable for use in PowerBI reporting. · Utilise PowerBI to build automated, interactive dashboards and reports, establishing high-quality self-serve BI across the business, and high-quality reporting externally. · Adhere to and enhance BI standards within the team and wider business unit. · Identify and implement areas of improvement. For full job description, please see attached role profile. 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 £36,500 · 30 days annual leave (plus 3 concessionary days over Christmas and your bank holidays) · Flexibility – UCAS positively supports Hybrid working for its employees, meaning you can work between home and the office in a way that suits you and the business and also has a comprehensive Flexible Working Policy · A generous pension scheme · Hundreds of high street discounts and offers with Perkbox · Internal training and development · Subsidised gym and café · Be rewarded for going above and beyond with our ex-gratia bonus scheme and Celebrating U, our quarterly employee recognition scheme · Dedicated volunteer employee networks promoting wellbeing, awareness and inclusion 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 still 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 careersucas.ac.uk and one of us will be in touch. Working Arrangements Is fully remote working an option? No