BI Developer (12-18 month FTC)

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 Developer for a London hybrid role with a 12-18 month FTC. You will build and maintain ETL pipelines, optimise SQL Server/T-SQL, and design dimensional models to support BI solutions across leading financial services clients.

The role also involves SSAS cube development, DAX calculations, and collaboration with analysts to translate requirements into scalable solutions while adapting to evolving client needs.

Qualifications

• Strong commercial experience with SQL Server and T-SQL development.
• Proven ETL development and data pipeline experience.
• Solid understanding of data warehousing principles and best practices.
• Experience with dimensional modelling, including star schema, semantic models, tabular models and Kimball methodologies.
• Exposure to DAX development.
• Experience working across complex data environments and multiple stakeholders.
• Strong problem-solving and communication skills.
• Consultancy experience is highly desirable, although candidates from fast-paced project environments will also be considered.
• Exposure to Python would be advantageous.

Responsibilities

• Build and maintain ETL processes and data pipelines.
• Develop and optimise SQL Server and T-SQL solutions.
• Design and enhance semantic, tabular, and dimensional data models.
• Support SSAS cube development and DAX calculations.
• Work closely with data and business analysts to translate requirements into technical solutions.
• Troubleshoot data issues and supporting end users.
• Contribute to testing, quality assurance, and peer review activities.
• Collaborate with senior developers on solution design and technical delivery.
• Work with evolving requirements and diverse client architectures.

Skills

SQL Server

T-SQL

ETL development

Data warehousing

Dimensional modelling

DAX

Python

Data environments

Problem solving

Communication

Consultancy experience

Tools

SQL Server

Job description

BI DEVELOPER (12-18 MONTH FTC)

LONDON/HYBRID

UP TO £60,000

This is an excellent opportunity for a BI Developer to join a growing consultancy that delivers data and analytics solutions to leading investment and financial services organisations. You'll work on a variety of complex data projects, gain exposure to different client environments, and contribute to the development of scalable business intelligence solutions that drive decision-making.

ROLES AND RESPONSIBILITIES

• Build and maintain ETL processes and data pipelines.
• Develop and optimise SQL Server and T-SQL solutions.
• Design and enhance semantic, tabular, and dimensional data models.
• Support SSAS cube development and DAX calculations.
• Work closely with data and business analysts to translate requirements into technical solutions.
• Troubleshoot data issues and supporting end users.
• Contribute to testing, quality assurance, and peer review activities.
• Collaborate with senior developers on solution design and technical delivery.
• Work with evolving requirements and diverse client architectures.

YOUR SKILLS AND EXPERIENCE

• Strong commercial experience with SQL Server and T-SQL development.
• Proven ETL development and data pipeline experience.
• Solid understanding of data warehousing principles and best practices.
• Experience with dimensional modelling, including concepts such as star schema, semantic models, tabular models and Kimball methodologies.
• Exposure to DAX development.
• Experience working across complex data environments and multiple stakeholders.
• Strong problem-solving and communication skills.
• Consultancy experience is highly desirable, although candidates from fast-paced project environments will also be considered.
• Exposure to Python would be advantageous.