Data Engineer

Overview

Data Engineer | 6 Month Contract | Outside IR35 | London We’re looking for an experienced Data Engineer to join a leading technology-driven business on an initial 6 month contract. This is a hands-on, onsite position where you’ll be responsible for designing, building, and maintaining scalable data models, pipelines, and cloud infrastructure that power business-critical insights. Location: London (on-site) Contract: 6 Months (very likely extension) Rate: £450-550 p/day Start date: ASAP Required Skills: Strong expertise with MSSQL Server and OLAP/Tabular models (SSAS Tabular, Azure Analysis Services, or Power BI Semantic Models). Advanced SQL and dimensional data modelling skills (fact/dimension design, hierarchies, SCDs). Proven experience building ETL/ELT pipelines using tools such as SSIS, dbt, or Airflow. Solid understanding of database administration, tuning, and performance optimisation across MSSQL and PostgreSQL. Key Responsibilities: Design and maintain data models that meet business requirements, ensuring scalability, consistency, and accuracy. Build and manage ETL/ELT pipelines to integrate data from S3 and various sources into the analytical layer. Administer and optimise MSSQL Server and PostgreSQL databases for performance and reliability. Collaborate with internal teams to improve data availability, reliability, and performance across systems. Design and maintain secure, scalable AWS cloud infrastructure supporting analytical workloads. Create and maintain dimensional and semantic data models for Power BI and Excel integration. Evaluate new data modelling tools and techniques to continuously improve efficiency and scalability. If you're interested, apply now for immediate consideration.

Responsibilities

• Design and maintain data models that meet business requirements.
• Build and manage ETL/ELT pipelines to integrate data from various sources.
• Administer and optimize MSSQL Server and PostgreSQL databases.
• Collaborate with internal teams to enhance data performance across systems.
• Design and maintain AWS cloud infrastructure for analytical workloads.
• Create dimensional and semantic data models for Power BI integration.
• Evaluate new tools and techniques for data modeling to improve efficiency.

Requirements

• Strong expertise with MSSQL Server and OLAP/Tabular models.
• Advanced SQL and dimensional data modelling skills.
• Proven experience building ETL/ELT pipelines with tools such as SSIS or dbt.
• Solid understanding of database administration and performance optimization.
• Experience with cloud infrastructure, especially AWS.
• Familiarity with creating data models for BI tools like Power BI.