Power BI Developer — AI-Driven Analytics (Hybrid)

Oscar; Doncaster; Hybrid; GBP 45,000 - 55,000; Full time

Benefits offered by this job

Hybrid working (1–2 days in Doncaster)

Exposure to MS data & AI tech

Professional development & progression

Job summary

Oscar is recruiting an experienced BI Developer to join the construction sector's BI team in Doncaster. You will deliver end-to-end BI solutions, covering data ingestion, transformation, modelling and visualisation, and work closely with stakeholders to define KPIs and translate needs into technical specs.

The role involves hands-on development across Power BI, including semantic models, DAX and Power Query, plus maintaining the BI environment and governance, with AI-enabled analytics support.

Qualifications

• 3+ years' professional experience in Business Intelligence, Analytics or a relevant technical field.
• Strong Power BI experience, including semantic modelling, DAX and Power Query (M).
• Experience with paginated reporting using SSRS and/or Power BI.
• Strong SQL experience, ideally SQL Server, Azure SQL Database and T-SQL.
• Experience with ETL/ELT and data integration tools, ideally Informatica.
• Strong understanding of dimensional modelling, including Star Schema.
• Experience optimising BI models, queries and reporting performance.
• Understanding of Power BI Service administration and governance.
• Experience working in an agile environment, ideally using Azure DevOps.
• Knowledge of construction metrics and data governance.

Responsibilities

• Design, build and maintain Power BI reports and dashboards aligned to business requirements.
• Develop and maintain data warehouse/lakehouse assets and ETL/ELT pipelines.
• Work with stakeholders to gather requirements, define KPIs and translate business needs into technical specifications.
• Develop semantic models and measures using Power BI, DAX and Power Query.
• Maintain and optimise BI solutions, including model performance, refresh reliability and accessibility.
• Present data-driven insights to stakeholders through clear data storytelling.
• Maintain technical documentation covering data definitions, lineage, model design and refresh processes.
• Champion data quality, governance and security, including access controls and row-level security.
• Apply best practices across semantic modelling, testing, source control and release management.
• Support Power BI Service administration, including workspaces, permissions, gateways and deployment pipelines.
• Support the adoption of AI-enabled analytics, including Copilot and natural-language Q&A.

Skills

Power BI

SQL

Data modelling

DAX

ETL/ELT

Azure

SSRS

Agile / Azure DevOps

Communication

Tools

Informatica

SSRS

Power BI Service

Azure Data Factory

Synapse

Databricks

Microsoft Fabric

Job description

Oscar is recruiting an experienced BI Developer to join the construction sector's BI team in Doncaster. You will deliver end-to-end BI solutions, covering data ingestion, transformation, modelling and visualisation, and work closely with stakeholders to define KPIs and translate needs into technical specs.

The role involves hands-on development across Power BI, including semantic models, DAX and Power Query, plus maintaining the BI environment and governance, with AI-enabled analytics support.