Business Intelligence Engineer

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.