Design, build, and maintain ETL/ELT pipelines from multiple data sources (Shopify, Meta, Google, CRM, etc.)
Own and manage the data warehouse (e.g. BigQuery, Snowflake, Redshift)
Ensure reliable, scalable, and efficient data flow across systems
Monitor and improve pipeline performance, cost, and reliability
Build and maintain data models (dbt or equivalent)
Structure raw data into clean, business-ready datasets (fact/dimension tables)
Define and standardize core business metrics across teams
Enable a consistent single source of truth
Implement validation checks and monitoring to ensure data accuracy
Identify and resolve discrepancies across platforms
Maintain documentation for data definitions and logic
Improve overall trust in data across the organization
Support dashboarding and reporting (Looker, Power BI, etc.)
Partner with marketing, product, and ops teams to deliver clean datasets
Enable faster and more accurate analysis across the business

Strong SQL (advanced level)
Experience building data pipelines (ETL/ELT) using Python, dbt, Airflow, or similar tools
Hands-on experience with data warehouses (BigQuery, Snowflake, Redshift, etc.)
Experience in data modeling (dbt, star schema, or similar)
Experience working with multiple data sources (APIs, SaaS tools, databases)

Nice to have

Remote flexibility – Work remotely while collaborating with a globally distributed team.
Earn between $48,000 to $84,000 per year, depending on experience and expertise.
Strategic leadership role – Direct exposure to executive leadership and key decision-making processes.
Opportunity to build and scale the company’s data strategy and infrastructure from the ground up.

Analytics Engineer, DTC E-commerce

Key skills