BI Developer (12-18 month FTC)

Harnham; Greater London; Hybrid; GBP 50,000 - 60,000; Full time

Benefits offered by this job

Private healthcare

Enhanced pension

Learning and development

Job summary

Harnham is seeking a BI Developer for a hybrid London role with 3 days in the office. The contract role offers £50,000–£60,000 and exposure to complex data integration and BI projects for high-profile clients.

You will design, develop, and maintain BI solutions, build ETL pipelines, and optimise T-SQL while collaborating with analysts to translate requirements into technical solutions. Sponsorship not available.

Qualifications

• Strong commercial experience with SQL Server and T-SQL development.
• Experience building and maintaining ETL processes and data pipelines.
• Solid understanding of data warehousing concepts and dimensional modelling.
• Experience working with semantic models, tabular models, star schemas, Kimball methodologies.
• Exposure to SSAS, DAX, and BI solution development.
• Experience working across different data architectures and technology environments.
• Strong problem-solving and stakeholder communication skills.
• Ability to work independently and adapt to changing priorities.
• Python development or scripting experience.

Responsibilities

• Designing, developing, and maintaining BI solutions across client projects.
• Developing and maintaining ETL pipelines and data integration processes.
• Writing, optimising, and troubleshooting complex T-SQL queries and stored procedures.
• Building and enhancing semantic and tabular data models.
• Supporting SSAS cube development and DAX calculations.
• Collaborating with business and data analysts to translate requirements into technical solutions.
• Investigating data issues and supporting users with technical queries.
• Contributing to testing, quality assurance, and solution design activities.
• Working within a consultancy environment where priorities and requirements can evolve.

Skills

SQL Server

T-SQL

ETL pipelines

Data warehousing

Dimensional modelling

Semantic models

SSAS/DAX

Python scripting

Consultancy

Stakeholder comms

Job description

London (Hybrid - 3 days in office) | £50,000 - £60,000

An exciting opportunity has arisen for a BI Developer to join a growing data consultancy on a fixed-term contract. This role offers the chance to work on complex data integration and business intelligence projects for high-profile clients, helping organisations unlock greater value from their data. With exposure to a variety of technology environments and the opportunity to take ownership of delivery, this is an excellent role for someone who enjoys solving data challenges in a fast-paced, client-focused environment.

The Company

Our client is a specialist data and technology consultancy that helps organisations improve reporting, analytics, and decision-making through modern data solutions. They work with complex data environments, supporting clients with data integration, business intelligence, and data platform development.

The Role

• As a BI Developer, you will play a key role in designing, developing, and maintaining business intelligence solutions across a range of client projects.


• Responsibilities include:


• Developing and maintaining ETL pipelines and data integration processes


• Writing, optimising, and troubleshooting complex T-SQL queries and stored procedures


• Building and enhancing semantic and tabular data models


• Supporting SSAS cube development and DAX calculations


• Collaborating with business and data analysts to translate requirements into technical solutions


• Investigating data issues and supporting users with technical queries


• Contributing to testing, quality assurance, and solution design activities


• Working within a consultancy environment where priorities and requirements can evolve

Your Skills & Experience

• Strong commercial experience with SQL Server and T-SQL development


• Experience building and maintaining ETL processes and data pipelines


• Solid understanding of data warehousing concepts and dimensional modelling


• Experience working with semantic models, tabular models, star schemas, Kimball methodologies, or similar data modelling approaches


• Exposure to SSAS, DAX, and BI solution development


• Experience working across different data architectures and technology environments


• Strong problem-solving and stakeholder communication skills


• Ability to work independently and adapt to changing priorities


• Python development or scripting experience


• Consultancy or client-facing project delivery experience

What They Offer

• Salary of £50,000 - £60,000


• Hybrid working model with 3 days in the London office


• Exposure to a wide range of client projects and data environments


• Ongoing learning and development opportunities, including certifications and training


• Private healthcare and enhanced pension contributions


• Clear opportunities to develop technical and consulting expertise


• Collaborative, high-performance culture with strong ownership and autonomy

Please note that sponsorship is not available for this position. Applicants must have the right to work in the UK without requiring current or future visa sponsorship.