Related skills
bigquery redshift snowflake sql dbtπ Description
- Design and maintain production data models (dbt) for incentives and lifecycle analytics.
- Model data from multiple systems and implement ELT in a cloud warehouse.
- Define KPIs for marketing; enable self-serve analytics with LookML.
- Set data quality standards with automated testing, lineage, and monitoring.
- Collaborate with Product, Marketing, and Engineering to deliver datasets for experimentation.
- Improve pipeline performance, reliability, and cost; drive CI/CD for analytics.
π― Requirements
- 4+ years in analytics or data engineering building production data models in the cloud.
- Advanced SQL proficiency with tuning in Snowflake, BigQuery, or Redshift.
- 2+ years implementing and maintaining dbt projects in production with Git workflows.
- ELT/ETL pipelines with Airflow or Dagster.
- Experience building semantic layers and BI models for self-serve analytics (Looker/LookML).
- Automated data quality testing and data observability; ownership of docs and lineage.
- Bachelor's degree in CS/Engineering/Math/Stats or equivalent.
- Cross-functional collaboration translating ambiguous requirements into scalable datasets.
π Benefits
- Remote-first culture with Flex First policy.
- Equity grant and annual refresh grants.
- Competitive compensation and benefits.
- Canadians: eligible to work from Ontario, Alberta, BC, or Nova Scotia.
Meet JobCopilot: Your Personal AI Job Hunter
Automatically Apply to Data Jobs. Just set your
preferences and Job Copilot will do the rest β finding, filtering, and applying while you focus on what matters.
Help us maintain the quality of jobs posted on Empllo!
Is this position not a remote job?
Let us know!