Data Warehouse Developer

Data Warehouse Developer 12-Month Contract Outside IR35 Remote (Based in Leatherhead but able to work from home and travel to client sites where necessary)
September/October Start

We're working with a leading technology and engineering consultancy that has secured a major long-term public sector programme and is looking for an experienced Data Warehouse Developer to join a high-profile data transformation project.

This is a long-term contract with an initial 12-month term, strong extension potential, and work expected to continue for up to 2 years.

The role is primarily remote, with occasional travel to project offices when required.

The Role You'll play a key role in designing, developing and supporting a critical enterprise data warehouse that forms part of a wider integrated data platform. Working across multiple data sources, you'll build robust ETL processes, develop scalable data models and enable high-quality reporting through Microsoft technologies including Power BI and Azure.

You'll work closely with technical teams, business stakeholders and product leadership to deliver reliable, scalable reporting solutions while helping shape the future direction of the platform, including its migration towards modern cloud-based architecture.

Key Responsibilities

• Design, build and support enterprise SQL data warehouse solutions.
• Develop and maintain ETL processes across multiple source systems.
• Create and optimise data models to support reporting and analytics.
• Develop paginated reports and Power BI reporting solutions.
• Support Azure-based reporting through secure gateway connections.
• Produce clear technical documentation and maintain development standards.
• Investigate and resolve production issues, performing root cause analysis.
• Work alongside Product Owners, BI teams and project managers to deliver technical solutions.
• Contribute to future cloud migration and platform modernisation initiatives.

Essential Skills & Experience

• Strong commercial experience developing SQL Server data warehouses.
• Expertise across the Microsoft BI stack, including:
  • SQL Server
  • SSIS
  • SSRS
  • SSAS
• Experience designing data models and building ETL solutions.
• Experience developing Microsoft Fabric Data Lakehouse solutions.
• Strong understanding of Power BI, including Paginated Reports.
• Experience integrating on-premise data platforms with Microsoft Azure.
• Strong troubleshooting and second-line support experience.
• Ability to produce high-quality technical documentation.
• Excellent stakeholder communication and collaboration skills.
• Experience working within project delivery environments.

Desirable Experience

• Microsoft Fabric and modern data platform architecture.
• CI/CD and Agile delivery practices.
• Data governance and technical leadership.
• Facilities Management or asset management systems.
• Public sector project delivery.
• VBA or batch scripting.
• Experience working with data quality challenges across multiple source systems.

Contract Details

• Contract: Initial 12 months (expected programme duration of up to 2 years)
• Start: September/October
• Location: Remote with occasional office visits
• IR35: Outside IR35 (subject to assessment)
• Security Clearance: BPSS/CTC required (or eligibility to obtain clearance)

If you're an experienced Data Warehouse Developer looking to work on a large-scale, business-critical data platform within a secure public sector programme, we'd like to hear from you.