Business Intelligence Developer

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

I'm currently working with a leading construction organisation that is looking to hire an experienced Business Intelligence Developer to join its BI team.

Working closely with the Business Intelligence Manager, you'll play a key role in delivering end-to-end BI solutions, covering data ingestion, transformation, modelling and visualisation.

You'll work closely with stakeholders to understand business requirements, define KPIs and translate these into effective technical solutions. The role will involve hands‑on development across Power BI, including semantic models, DAX, Power Query and dashboards.

You'll also be responsible for maintaining and optimising the Power BI environment, championing data quality and governance, and supporting the organisation's adoption of AI‑enabled analytics such as Copilot and natural‑language insight.

If you're an experienced BI Developer with strong Power BI, SQL and data modelling skills and want to have a genuine impact on how an organisation uses data, this could be an excellent opportunity.

Key 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.

Essential Skills and Experience

• 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.
• Understanding of source control, deployment processes and testing/validation.
• Excellent communication skills and the ability to explain technical concepts to non‑technical stakeholders.
• Strong business acumen and problem‑solving ability.
• Experience within the construction industry.
• Knowledge of construction operational and financial metrics.
• Experience with Microsoft Fabric and/or Azure data services such as Data Factory, Synapse or Databricks.
• Experience with Copilot, natural‑language Q&A or other AI features within Power BI/Microsoft 365.
• Microsoft PL-300 certification or willingness to work towards it.

Package and Benefits

• Up to £50,000 salary depending on experience.
• Hybrid working (1-2 days a week in the Doncaster office).
• Exposure to modern Microsoft data and AI technologies.
• Opportunity to contribute to the organisation's wider BI and data strategy.
• Strong scope for professional development and progression.