Overview
We are seeking an experienced Data Engineer for a hands-on, onsite role supporting a technology-driven business. This 6-month contract position will focus on designing, building, and maintaining scalable data models, pipelines, and cloud infrastructure to deliver critical business insights. The contractor will work closely with internal teams to enhance data availability and optimize performance.
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 optimize 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 optimization across MSSQL and PostgreSQL.