Overview
We are seeking a Senior Data Engineer for a hands-on, on-site role within a technology-driven environment on a 6-month contract. The contractor will be tasked with designing, building, and maintaining scalable data models and cloud infrastructure, collaborating with internal teams to enhance data processes and support business-critical insights.
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.
Requirements
- 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.
- Background in financial services or trading environments, with exposure to complex, high-volume datasets.