Design and implement robust dimensional and relational data models that support analytical use cases across Product, Marketing, Operations, and Finance.
Build and maintain scalable dbt transformation pipelines, ensuring high data quality, performance, and cost-efficiency from raw ingestion to business-ready outputs.
Own the transformation and modeling of curated (Silver/Gold) datasets, ensuring clear contracts and traceability from raw to business-ready data.
Collaborate with data analysts, product analytics, data scientists, and business stakeholders to translate requirements into durable data products that support experimentation, A/B testing, and advanced analytics.
Implement data quality tests, monitoring, SLAs, and alerting to ensure reliability of critical analytical datasets.
Partner with Data Engineers to define and enforce data contracts, ensuring schema stability and minimizing downstream breakage.
Establish and evangelize analytics engineering best practices, including version control, code review, testing standards, and documentation.
Empower self-service analytics by building intuitive, well-documented data marts and semantic layers.
Requirements
Minimum 5+ years of experience in analytics engineering, data modeling, or similar roles working with enterprise-scale data, and demonstrated ownership of data products and cross-functional collaboration.
Expert-level SQL skills with deep understanding of query optimization and performance tuning.
Extensive experience with dbt (data build tool) including testing, documentation, and package management.
Strong programming skills in Python for data manipulation, automation, and custom analytics workflows.
Strong understanding of dimensional modeling, star schemas, one big table, and other data modeling methodologies.
Experience with modern cloud data warehouses (Snowflake, BigQuery, Redshift, or Databricks SQL Warehouse).
Familiarity with orchestration frameworks and how analytics transformations are scheduled within broader data workflows.
Experience working with version control systems (Git) and implementing CI/CD for analytics code.
Strong business acumen and ability to translate business requirements into well-designed data models.
Understanding of data governance, privacy, and compliance requirements (GDPR, CCPA, and SOX).
Familiarity with BI tools (Tableau, Looker, Mode, or similar) and how analysts consume data.
Strong ownership mindset with a passion for deeply understanding ambiguous business problems and translating them into clean, maintainable, and well-tested data models.
Excellent communication skills with ability to explain technical concepts to both technical and non-technical audiences.
Dedication to data quality, documentation, and empowering others through self-service analytics.
Bachelor’s Degree in a technical field, or equivalent experience.
Tech Stack
Amazon Redshift
BigQuery
Cloud
Python
SQL
Tableau
Benefits
Competitive pay and benefits.
Medical, dental, vision, life and disability insurance plans (100% paid for US employees). We offer supplemental plans for medical and dental for Canadian employees.
401(k) plan with company matching program in the US and RRSP with DPSP plan for Canadian employees.
Employee Assistance Program (EAP) for mental wellness.
Flexible PTO and 12 company wide days off throughout the year.
Learning & Development programs.
Equipment, tools, and reimbursement support for a productive remote environment.
Free Life360 Platinum Membership for your preferred circle.