Hybrid BI Developer: Power BI Dashboards & Insights

Ucas; Washington (District of Columbia); Hybrid; USD 48,000 - 59,000; Full time

Benefits offered by this job

Hybrid working

35-hour week

30 days leave

Onsite gym

Free parking Cheltenham

Perkbox discounts

Training & certifications

Ex-gratia bonus

Job summary

UCAS is seeking a BI Developer to join the Digital Services team, shaping data into self-serve outputs for both technical and non-technical audiences. You will build reporting pipelines and PowerBI dashboards to deliver UCAS data to stakeholders.

The role requires strong numerate and analytical skills, with experience in Python/R/SAS/C#, SQL, DAX, and AWS. A collaborative mindset and mentoring abilities are valued as you work across teams.

Qualifications

• 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 programming in Python, R, SAS or C# (or equivalents) and the ability to write readable, efficient code.
• 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.
• Good working knowledge of AWS components, including S3 buckets.
• Good working knowledge of manipulating datasets programmatically, for example through python, R, SAS or C#.
• 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.

Responsibilities

• 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 intonthe 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.
• Coach peers and Junior BI developers/Data Scientists, sharing knowledge and best practice.

Skills

Bachelor's degree

Python/R/SAS/C#

PowerBI

DAX

Data modelling

ETL (PowerBI)

SQL

Dashboard UX

AWS S3

Data wrangling

Communication

Mentoring

Curiosity

Numerate thinking

Self-starter

Data transformation

Education

Bachelor's degree in a numerate discipline

Tools

PowerBI

AWS

Job description

UCAS is seeking a BI Developer to join the Digital Services team, shaping data into self-serve outputs for both technical and non-technical audiences. You will build reporting pipelines and PowerBI dashboards to deliver UCAS data to stakeholders.

The role requires strong numerate and analytical skills, with experience in Python/R/SAS/C#, SQL, DAX, and AWS. A collaborative mindset and mentoring abilities are valued as you work across teams.