BI Engineer

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

Job summary

Harnham - Data & Analytics Recruitment is seeking a BI Engineer for a 12-month fixed-term contract in London. The role is hybrid, offering exposure to data integration projects for investment and financial services clients.

You will design, develop, and support data solutions using SQL Server, ETL pipelines, and dimensional modelling. The ideal candidate has strong SQL Server/T-SQL skills, experience with data warehousing, DAX, and familiarity with Azure data services.

Qualifications

• Experience building ETL pipelines and data integration processes.
• Proficient in SQL Server, T-SQL, and data modelling.
• Exposure to data warehousing concepts and dimensional modelling is essential.
• Familiarity with DAX, Azure data services, and Python is advantageous.

Responsibilities

• Design, develop, and support data solutions for client projects.
• Build and maintain ETL pipelines and data integration processes.
• Create and optimize semantic and tabular data models.
• Collaborate with analysts and stakeholders to translate requirements into technical solutions.
• Ensure data quality and resolve reporting issues.
• Support testing, QA, and deployment activities.

Skills

SQL Server

ETL development

Data warehousing

Dimensional modelling

DAX

Azure data services

Python

Job description

BI Engineer - 12 month FTC

London (Hybrid)

Up to £60,000

This is an excellent opportunity for a BI Engineer to join a growing data consultancy delivering complex data and analytics solutions for investment and financial services clients. You'll work on challenging data integration projects, gain exposure to a variety of modern data environments, and develop both your technical and consulting skills within a collaborative, high-performing team.

The Company

They are a specialist data and technology consultancy that helps organisations build trusted, scalable data platforms. Their work focuses on data integration, analytics, reporting, and operational efficiency, enabling clients to make better decisions through high quality data. With continued growth and a strong project pipeline, they offer an environment where BI Engineers can take ownership, work closely with stakeholders, and develop their expertise across a range of technologies and client environments.

The Role

As a BI Engineer, you will play a key role in designing, developing, and supporting data solutions for client projects.

Responsibilities include:

• Building and maintaining ETL pipelines and data integration processes.
• Developing, optimising, and troubleshooting complex SQL Server and T-SQL solutions.
• Creating and enhancing semantic and tabular data models.
• Supporting SSAS cube development and DAX calculations.
• Applying dimensional modelling and data warehousing best practices.
• Working with analysts and stakeholders to translate business requirements into technical solutions.
• Investigating and resolving data quality and reporting issues.
• Supporting testing, quality assurance, and deployment activities.
• Collaborating across project teams to deliver scalable and reliable data solutions.

Your Skills & Experience

You will have strong commercial experience with:

• SQL Server and SQL development.
• ETL development and data pipeline engineering.
• Data warehousing principles and dimensional modelling.
• Star schema, Kimball methodologies, semantic models, and tabular models.
• DAX.
• Working within fast-paced delivery environments.
• Communicating effectively with both technical and non-technical stakeholders.
• Experience within a consultancy environment would be highly beneficial.
• Exposure to Azure data services, Data Vault modelling, or Python would also be advantageous.