DWH Architect
Summary
Own end-to-end data warehouse architecture for a performance-marketing analytics platform, designing data models, pipelines, and governance frameworks using dbt, Snowflake/BigQuery/Redshift, and orchestration tools. Mentor the data engineering team and collaborate with product and analytics stakeholders.
Own end-to-end data warehouse architecture for a performance-marketing analytics platform.
Responsibilities:
- Own end-to-end DWH architecture: data models, layering strategy, schema evolution
- Strategic decisions on warehouse expansion, new source integration, performance tuning
- Design/maintain the transformation layer (code quality + documentation)
- Architect ingestion pipelines into the Campaignswell UI
- Manage/optimize MPP database environments for cost and query performance
- Establish data governance (naming, quality checks, lineage, access control)
- Collaborate with CSM, product, marketing analytics; mentor the Data Engineering team
Requirements:
- 5+ years data engineering/warehousing; 2+ years as architect
- Strong Data Vault expertise (raw/business vault, information marts)
- Production dbt (advanced macros, incremental models, tests, packages)
- Deep Redshift, BigQuery, or Snowflake architecture/optimization
- S3-based data-lake patterns; Airflow or similar orchestration
- Mobile/web performance marketing, subscription/ad-revenue domain
- Attribution data, SKAN, MMP integrations, campaign-level analytics
- Strong SQL; CI/CD version-controlled workflows; English B1