Job Title : Data Warehouse Engineer
Company : T op-performing Customer Acquisition and Direct Response Media Agency (UK Headquartered)
Job Location : Hyderabad (on-site)
Approx CTC Band : Rs 30 LPA
Experience Required : 2-4 Years
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.