Marketing Data Analyst
Gympass
PythonSQLTableau
Senior Data Analyst, Business Intelligence
Insight Value
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇧🇷 Brazil
Visit company websiteSalary
💰 R$12,000 - R$15,000 per month
Job Level
Senior
Tech Stack
BigQuerySQL
About the role
- Product measurement: define and maintain metrics such as conversion rate, GMV, average order value, drop-off by checkout step, time per step, and return by channel.
- Funnels and behavior: build and evolve funnels (e.g., checkout) and behavioral analyses (cohorts, retention, paths) to identify bottlenecks and opportunities.
- Dashboards (Metabase): create self-service dashboards with filters, drill-downs, and subscriptions; standardize collections and models (Saved Questions) for reuse.
- Experimentation (A/B): assist in hypothesis design, define success metrics, calculate sample sizes, and analyze results.
- Data pipelines: operate the Hevo → BigQuery → (dbt) → Metabase flow, ensuring data quality, timeliness, and cost efficiency.
- Modeling and SQL: write performant SQL in BigQuery; where applicable, model layers in dbt (staging/intermediate/marts) with tests and documentation.
- Quality and governance: maintain a metrics/events dictionary, data tests, integrity checks, and simple alerts (e.g., Metabase subscriptions).
- Ad-hoc analyses: answer Product/Growth questions with quick, clear investigations, delivering actionable recommendations.
- Collaboration: work with Product and Engineering to prioritize requests and turn findings into roadmap decisions.
Requirements
- Advanced SQL (CTEs, window functions, aggregations) and BigQuery performance best practices.
- Dashboard creation (ideally Metabase) focused on clarity and decision-making.
- Understanding of product metrics: funnels, conversion, GMV, average order value, cohorts/retention, basic LTV.
- Familiarity with A/B testing (hypotheses, success metrics, interpreting significance).
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLBigQueryA/B testingdata modelingdata qualitydata governancedata pipelinesmetrics definitionbehavioral analysisad-hoc analysis
Soft skills
collaborationcommunicationanalytical thinkingproblem-solvingdecision-making
