Data Warehouse Engineer

Job Title:

Company:

Job Location:

Approx CTC Band:

Experience Required:

About Us:

Client of QuiqHire, a top-performing Customer Acquisition and Direct Response Media Agency. Our data and technology division is building a cutting-edge, Snowflake-based analytics platform to drive data-informed decisions across the business.

Role Purpose:

We are seeking a technically strong, hands-on Data Warehouse Engineer to design, build, and maintain our Snowflake data warehouse. Your core mission is to transform raw data into clean, reliable, and well-modeled datasets that power our DOMO dashboards and business intelligence, ensuring data is always accurate and timely for downstream analytics.

Key Responsibilities:

• Design, develop, and optimize robust ELT pipelines in Snowflake to prepare data for reporting and BI.
• Build and maintain structured, analysis-ready data marts and views in Snowflake for consumption by DOMO and other tools.
• Transform raw digital marketing data (e.g., Meta, Google Ads, GA4) and business data into efficient, governed data models.
• Implement and maintain data quality checks, validation rules, and monitoring processes to ensure data reliability.
• Utilise advanced Snowflake features like Snowpipes, Streams, Tasks, Stored Procedures (JavaScript), and Dynamic Tables.
• Collaborate daily with BI Developers and the UK-based data team to ensure data structures meet dashboard needs and optimize platform costs.
• Maintain comprehensive documentation for all datasets, pipelines, and transformations.

Must-Have Skills:

• Strong, hands-on experience with 

  Snowflake

   (schema design, performance tuning, warehouse scaling).

• Advanced SQL

   for complex data transformation, modeling, and aggregation.
• Proficiency in 

  JavaScript

   for creating Snowflake Stored Procedures and User-Defined Functions (UDFs).
• Solid understanding of 

  ELT/ETL principles

   and pipeline construction.
• Experience designing data models for BI tools like 

  DOMO

  .
• Meticulous attention to detail, strong problem-solving skills, and excellent communication skills in English.

Good-to-Have Skills:

• Python for scripting and automation.
• Familiarity with digital marketing data sources (Meta, Google Ads, GA4, TikTok, etc.).

What Success Looks Like (First 6 Months):

• Delivery of stable, well-documented Snowflake data marts that reliably power DOMO dashboards.
• Implementation of monitored ELT pipelines with robust data quality checks.
• Successful integration of new data sources with minimal manual intervention.
• Positive stakeholder feedback on data reliability, performance, and accessibility.