BI Engineer - Data Modelling (12 month FTC)

Harnham - Data & Analytics Recruitment; City Of London; Hybrid; GBP 50,000 - 75,000; Full time

Benefits offered by this job

Hybrid work

Job summary

Harnham - Data & Analytics Recruitment in London is seeking a BI Engineer to support the development of data models, ETL processes and reporting solutions. The role collaborates with analysts and developers to deliver high-quality BI solutions in a hybrid environment (3 days in the office).

The successful candidate will develop and maintain ETL processes and data warehouses, build semantic models, optimise SQL and assist with testing and data validation, ensuring robust BI delivery for the

Qualifications

• Strong SQL Server and T-SQL development experience.
• Experience with SSAS multidimensional and Tabular models, including DAX.
• Knowledge of ETL processes, data warehousing and dimensional modelling.
• Familiarity with Azure data services and modern data platforms.
• Experience with data validation, testing and quality assurance.
• Understanding of established BI development standards and architectural patterns.

Responsibilities

• Develop and maintain ETL processes, data warehouses and SSAS cubes.
• Build and enhance data and semantic models, including advanced DAX calculations.
• Write and optimise SQL queries and stored procedures.
• Support testing, quality assurance, bug fixing and data validation.
• Troubleshoot data issues and support client queries.
• Collaborate with analysts and developers to deliver scalable, reliable BI solutions.

Skills

SQL Server

T-SQL

SSAS multidimensional

SSAS tabular

DAX

ETL

Data warehousing

Dimensional modelling

Azure data services

QA testing

BI development standards

Tools

Azure Data Factory

Job description

BI Engineer

Contract: 12 month FTC (possibility of going permanent)

Location: London Working Pattern: Hybrid (3 days in the office)

I'm currently representing my client, who is looking for a BI Engineer to support the development of data models, ETL processes and reporting solutions, working closely with analysts and developers to deliver high-quality BI solutions.

The Role:

• Develop and maintain ETL processes, data warehouses and SSAS cubes.
• Build and enhance data and semantic models, including advanced DAX calculations.
• Write and optimise SQL queries and stored procedures.
• Support testing, quality assurance, bug fixing and data validation.
• Troubleshoot data issues and support client queries.
• Collaborate with analysts and developers to deliver scalable, reliable BI solutions.

The Requirements:

• Strong SQL Server and T-SQL development experience.
• Experience with SSAS multidimensional and Tabular models, including DAX.
• Knowledge of ETL processes, data warehousing and dimensional modelling.
• Familiarity with Azure data services and modern data platforms.
• Experience with data validation, testing and quality assurance.
• Understanding of established BI development standards and architectural patterns.

What Will Make You Stand Out:

• Experience with Data Vault and Kimball modelling methodologies.
• Programming or scripting skills.
• Strong problem-solving abilities and a proactive approach to troubleshooting.
• Experience supporting junior developers through knowledge sharing and peer reviews.