BI Developer

• Maintain and develop our Business Intelligence platform, including dashboards, data flows from the Data Platform, and governance of the BI estate.
• Build strong relationships with colleagues across our organisation to collaborate on and refine Power BI reporting requirements.
• Work with the Data Platform team to establish reporting requirements as new data sources are integrated.
• Transform Data Warehouse models into schemas suitable for Power BI reporting.
• Build automated, interactive Power BI dashboards and reports to provide high-quality self-service BI across our organisation and reporting for external audiences.
• Coach peers and junior BI developers or Data Scientists, sharing knowledge and best practices.

Technologies:

• AWS
• Business Intelligence
• C#
• Data Warehouse
• DAX
• ETL
• Support
• Power BI
• Python
• SAS
• SQL
• UX UI Design
• Cloud
• LESS

More:

We are UCAS, the worlds leading shared admissions service for higher education, connecting people to higher education and providing application services for UK universities and colleges, alongside research, consultancy, and advisory services. Our Digital Services unit drives technical innovation, data, and infrastructure through collaborative, multidisciplinary teams. This full-time BI Developer role is part of our Business Intelligence and Reporting team, is based in South West Gloucestershire, Rosehill, and follows a hybrid working model. The role offers 35 hours per week and a salary of up to £40,000. Our benefits include purpose-driven work, training and mentoring, access to industry-recognised certifications, flexible working, 30 days annual leave plus concessionary days and bank holidays, optional additional leave, wellbeing support, a free gym, subsidised café and free parking at our Cheltenham office, employee networks, wellbeing champions, recognition schemes, and an ex-gratia bonus.

• Degree or equivalent demonstrable experience in a numerate discipline, such as mathematics, statistics, computer science, operational research, or data science.
• Good working knowledge of Python programming and the ability to write readable, efficient code; familiarity with R, SAS, C#, or equivalent is also relevant.
• Good working knowledge of Power BI and Data Analysis Expressions (DAX).
• Good working knowledge of data model design principles.
• Good working knowledge of ETL processes in the Power BI service and the service more broadly.
• Good working knowledge of SQL.
• Good working knowledge of dashboard UI/UX best practices.
• Good working knowledge of AWS components, including S3 buckets.
• Ability to manipulate datasets programmatically using tools such as Python, R, SAS, or C#.
• Collaborative approach and effective communication with technical and non-technical audiences.
• Natural curiosity and drive to uncover meaningful insights from data.
• Strong numeracy, analytical, and logical thinking skills.
• Ability to learn new areas of work quickly, handle challenges, work at pace, and act as a self-starter.
• Proven experience efficiently transforming data for different purposes.
• Experience coaching peers or junior staff.