Data Engineer
Posted Today by Oscar
£550 Per day
Outside
Onsite
London Area, United Kingdom
Summary: The Data Engineer role is a hands-on, on-site position within a leading technology-driven business, focused on designing, building, and maintaining scalable data models, pipelines, and cloud infrastructure. This initial 6-month contract is likely to be extended and requires strong expertise in various data technologies. The position is based in London and emphasizes collaboration with internal teams to enhance data performance and availability. Immediate start is preferred.
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.
Key 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.
- Ability to dynamically load data from databases into Excel using OLAP Cubes.
Salary (Rate): £550 daily
City: London
Country: United Kingdom
Working Arrangements: on-site
IR35 Status: outside IR35
Seniority Level: Mid-Level
Industry: IT
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 .
- Ability to dynamically load data from databases into Excel using OLAP Cubes. (MUST HAVE)
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.