Data Warehouse Modeler

TESTQ Technologies
Basildon, UK
7 days ago
Apply on www.collegerecruiter.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours

Tech stack

Amazon S3 Cloud Computing Information Engineering Data Governance Data Integration Extract Transform Load (ETL) Data Mapping Data Systems Data Vault Modeling Data Warehousing Performance Tuning SQL Databases
+9 more
SQL Server Integration Services Talend Data Ingestion Informatica Powercenter Snowflake Pyspark Information Technology AWS Data Analytics Physical Data Models

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, * 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

Requirements

  • 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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.collegerecruiter.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

4:32 min

Harnessing Spark with Python using PySpark and Py4J

Ayon Roy · LIVE

3:43 min

The enduring legacy of the amazon S3 storage API

Chris Heilmann +3 · LIVE

2:57 min

Core technical practices for robust data engineering

Sandhya Menon Sandhya Menon · World Congress 2026 Europe

3:37 min

Scaling machine learning pipelines from prototypes to petabytes

Julian Joseph · LIVE

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

3:44 min

Automating storage savings with S3 intelligent tiering

Sébastien Stormacq · World Congress 2021

Videos

See all

Related articles

See all