Data Warehouse Modeler

TESTQ Technologies Limited; Basildon; On-site; GBP 60,000 - 80,000; Full time

Job summary

TESTQ Technologies Limited is looking for a Data Warehouse Modeler and Engineer to join their Data Solutions domain in Basildon, England. The ideal candidate will have over 7 years of experience in data modeling and engineering, with strong expertise in SQL and dbt. Responsibilities include designing ETL/ELT pipelines, ensuring data quality, and collaborating with various teams. This role offers a chance to work with cutting-edge data technologies in a fast-paced environment.

Qualifications

• 7 or more years of experience in a similar role within a fast-paced, enterprise-scale environment.
• Strong proficiency in SQL and hands-on experience with DBT Core or Cloud.
• Knowledge of data quality governance and performance optimization.

Responsibilities

• Design and implement ETL/ELT pipelines for data ingestion, transformation, and consolidation.
• Perform data mapping from source systems to target Snowflake structures.
• Develop and maintain dbt models following best practices.

Skills

SQL

data modeling

dbt

ETL

data transformation

Education

Bachelor's or Master’s degree in Computer Science, Data Engineering

Tools

DBT Core or Cloud

SQL data modeling

AWS data stack (S3, Glue, EMR, PySpark)

Job description

• We are seeking a talented and experienced Data Warehouse Modeler and Engineer DBT Snowflake to join the Data Solutions domain in EMEA
• As a key contributor you will be responsible for designing and implementing end‑to‑end data integration and transformation solutions on Snowflake
• This role combines ETL/ELT design, data mapping, data modeling, and hands‑on data engineering using dbt

Key Responsibilities

• Design and implement ETL/ELT pipelines for data ingestion, transformation, and consolidation
• Perform data mapping from source systems to target Snowflake structures
• Design and maintain conceptual, logical, and physical data models, staging, integration, and marts
• Develop and maintain dbt models following best practices
• Ensure data quality, consistency, lineage, and documentation
• Collaborate with engineering, analytics, and platform teams to align on data patterns and standards

Technical Qualifications

• Bachelor's or Master’s degree in Computer Science, Data Engineering, or a related technical field
• 7 or more years of experience in a similar role within a fast‑paced, enterprise‑scale environment
• Strong proficiency in SQL and hands‑on experience with DBT Core or Cloud, or other traditional ETL tools (ODI, Informatica, Talend, SSIS, etc.)
• Experience with SQL data modeling, Kimball, Inmon, Data Vault concepts, ETL/ELT design, and data mapping
• Knowledge of data quality governance and performance optimization
• A solid understanding of end‑to‑end data ingestion and transformation processes
• Nice to have: AWS data stack experience (S3, Glue, EMR, PySpark, Iceberg)

Non‑Technical Skills

• Demonstrated commitment, ownership, and accountability
• Strong attention to detail with a proactive approach to identifying and resolving problems
• A genuine interest in emerging data technologies and a curiosity about continuous improvements
• Excellent verbal and written communication skills