Role and Responsibilities:
- Build the data platform by designing and maintaining scalable ELT/ETL pipelines integrating product data, payment providers, and third-party APIs.
- Own and optimize the cloud data warehouse (Snowflake, BigQuery, or Redshift) with efficient data modeling and cost management.
- Implement reliable orchestration workflows using Airflow, Prefect, or similar tools.
Data Quality and Governance:
- Develop clean, testable transformation layers with dbt or equivalent frameworks and design a semantic layer for consistent business metrics.
- Implement data quality testing, monitoring, lineage, and documentation practices.
- Build security and governance including access controls, PII handling, and privacy-aware data practices.
Collaboration and Tech Stack:
- Work closely with Product and Growth teams to support product analytics, experimentation, subscription metrics, and business reporting.
- Collaborate with software engineers on event tracking, data contracts, and API integrations while promoting DataOps best practices.
- Utilize the tech stack including Python, SQL, dbt, Airflow, Snowflake, and AWS/GCP among others.