Business Intelligence Developer

Oscar Technology; Doncaster; Hybrid; GBP 36,000 - 60,000; Full time

Benefits offered by this job

Hybrid work

Career development

Job summary

Oscar Associates is seeking a Business Intelligence Developer to join its BI team in Doncaster, with 1–2 days onsite weekly. You will deliver end-to-end BI solutions using Power BI, DAX, and SQL, focusing on data ingestion, modelling, dashboards and governance.

You will collaborate with stakeholders to define KPIs, optimise Power BI environments and champion data quality, with some AI-enabled analytics initiatives.

Qualifications

• 3+ years' professional BI analytics experience.
• Strong Power BI with semantic modelling, DAX & Power Query.
• Paginated reporting experience (SSRS / Power BI Report Builder).
• Strong SQL skills (SQL Server / Azure SQL).
• ETL/ELT & data integration experience (Informatica).
• Dimensional modelling incl. Star Schema.
• BI models and performance optimisation experience.
• Power BI Service governance & administration knowledge.
• Experience in an Agile environment (Azure DevOps).
• Knowledge of source control, deployments & testing.
• Excellent communication & business acumen; strong problem solving.

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.
• Gather requirements, define KPIs and translate business needs into technical specs.
• Develop semantic models and measures using Power BI, DAX and Power Query.
• Maintain BI solutions, including model performance, refresh reliability and accessibility.
• Present data-driven insights to stakeholders through clear storytelling.
• Maintain technical documentation covering data definitions, lineage, model design and refresh processes.
• Champion data quality, governance and security, including access controls and RLS.
• 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 AI-enabled analytics adoption, including Copilot & natural-language Q&A.

Skills

Power BI

SQL

Data modelling

DAX

Power Query

ETL/ELT

SSRS

Azure DevOps

Informatica

Star Schema

Data governance

Data storytelling

Tools

Power BI

SSRS

Power BI Report Builder

Azure SQL Database

Informatica

SQL Server

Job description

Title: Business Intelligence Developer

Location: Doncaster (1-2 days a week)

Salary: Up to £60k DOE

Contract: 6-month FTC

Industry: Construction

The Opportunity

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 Report Builder.
• 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.

Desirable Skills

• 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 £60,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.

Oscar Associates (UK) Limited is acting as an Employment Agency in relation to this vacancy.

To understand more about what we do with your data please review our privacy policy in the privacy section of the Oscar website.