Why we’re hiring
We have data everywhere — backend events, mobile app usage (iOS + Android + web), payments from Stripe and RevenueCat, ad spend from Meta, TikTok, and Google Ads. We started setting up Snowflake as our DWH but ran out of time and bandwidth to do it right. So we’re looking for someone who’s done this before — someone who can come in, take the wheel, and get it all connected and working. Fast.
This is a greenfield ownership role. You’ll set up the warehouse, wire up all data sources, build the reports our team actually uses, and become the go-to person for anything data at TheTop.
What you’ll do
Pick up our Snowflake setup where we left off (or restart clean if needed) and get the DWH properly running
Build ETL/ELT pipelines from all our sources: backend DB, iOS/Android/web app events, Stripe, RevenueCat, Meta Ads, TikTok Ads, Google Ads
Design a clean data model that makes business metrics easy to query and trust
Build and maintain dashboards and reports in Metabase (or suggest and migrate to something better)
Own ad-hoc analysis — when the team has a question, you’re the person who finds the answer
Lead pattern investigations: retention drops, conversion funnel issues, campaign performance anomalies — dig in, figure out what’s happening, explain it clearly
Set up data quality monitoring so broken pipelines don’t go unnoticed
Collaborate directly with our US business team — explain findings in plain language, not data jargon
What we’re looking for
Solid hands-on experience setting up and running a DWH from scratch (Snowflake, BigQuery, or Redshift — ideally Snowflake)
Strong SQL — you write complex queries without blinking
Experience building ETL/ELT pipelines with Python or tools like dbt, Fivetran, Airbyte, Airflow, or similar
Worked with mobile app analytics data — event tracking, funnels, retention, cohorts
Connected marketing ad APIs before (Meta, Google Ads, TikTok) — or at least knows the drill
Experience with subscription/payment data (Stripe, RevenueCat, or similar)
Intermediate English — comfortable chatting with our US team via Slack and occasional calls
Startup mindset — you move fast, figure things out, and don’t wait for perfect conditions
You understand business context, not just tables and pipelines — you know why a metric matters
