-
-
TYPE OF WORK
Any
-
-
SALARY
$2000/mo
-
-
HOURS PER WEEK
40
-
-
DATE UPDATED
Sep 24, 2025
???? Job Description: Analytics Engineer (Ecommerce / Growth Analytics)
Location: Remote (Philippines preferred)
Type: Full-time Contractor / Long-term
???? About Us
We are a rapidly scaling ecommerce brand (600–900 orders/day, rebranding to VOYG, targeting 9-figure scale). We’re building a world-class data platform to power executive decision-making, marketing optimization, and long-term growth.
We want to hire an Analytics Engineer to own the data pipeline from raw sources ? modeled warehouse ? dashboards & insights. Your work will directly empower executives, media buyers, and the CMO with accurate, real-time decision tools.
???? Role Overview
You will design, build, and maintain our analytics stack:
Extract: Connect Shopify, GA4, Meta Ads, Google Ads, and other sources via Fivetran (or similar).
Transform: Use dbt Cloud to model clean, reusable datasets (staging ? marts).
Visualize: Build dashboards in Looker Studio for executives and the marketing team.
Automate: Enable AI-driven marketing briefs and competitor intel pipelines.
Secure: Ensure role-based access and proper governance of all data.
???? Key Responsibilities
Set up & manage Fivetran connectors (Shopify, GA4, Meta Ads, Google Ads, TikTok, Pinterest, etc.).
Develop & maintain dbt models (staging, intermediate, marts) in BigQuery.
Implement robust data tests (not null, unique, referential integrity).
Translate ecommerce KPIs into SQL/dbt models: CVR, AOV, RPS, ROAS, contribution profit, funnel stage conversion.
Create and maintain dashboards in Looker Studio (Exec, CMO, Finance, Ops).
Collaborate with leadership to define new metrics and automate reports.
Manage data from Google Sheets (COGS, shipping, etc.) into BigQuery.
Build basic competitor intelligence pipelines (Meta Ad Library, Google Shopping API).
Ensure data quality, documentation, and security (row-level access, schema versioning).
????? Required Skills & Experience
SQL Expert (complex joins, CTEs, window functions).
Strong experience with Google BigQuery.
dbt Cloud (must have): packages, vars, tests, docs.
Experience with Fivetran (or Airbyte/Supermetrics).
Dashboarding in Looker Studio (or similar BI tools).
Clear understanding of ecommerce metrics (CVR, AOV, ROAS, contribution profit).
Git/GitHub workflows (commits, branches, pull requests).
Strong English communication (async + Zoom).
? Nice-to-Haves
Python (for API integrations + competitor intel pipelines).
Familiarity with ecommerce platforms (Shopify API, Klaviyo, Google Merchant Center).
Experience building AI/LLM-integrated reports.
Data governance/security best practices.
???? What We Offer
Work directly with founder/CMO in a fast-scaling brand aiming for 9-figure growth.
Exposure to cutting-edge data stack (BigQuery, dbt Cloud, Fivetran, AI/LLM).
Long-term role with growth opportunities.
Flexible remote work.
Competitive compensation (based on experience; we expect to pay top-of-market PH rates for A+++ talent).
???? How to Apply
Send:
Resume/CV
Examples of dbt models or Looker Studio dashboards you’ve built (screenshots or repos).
A short note: “Here’s how I’d model CVR, AOV, and contribution profit for an ecommerce brand.”
