Data Analyst, Mid-level
Brivia
AzureCloudSQL
Senior Business Intelligence Analyst, Data
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 measurements: define and maintain metrics such as conversion rate, GMV, average order value (ticket médio), drop-off by checkout step, step time, and revenue/return per 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 designing hypotheses, defining success metrics, calculating sample sizes, and analyzing 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; when 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: respond to Product/Growth questions with fast, 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 performance best practices in BigQuery.
- Dashboard creation (ideally Metabase) with a focus on clarity and decision-making.
- Understanding of product metrics: funnels, conversion, GMV, average order value, cohorts/retention, basic LTV.
- Knowledge of A/B testing (hypotheses, success metrics, interpretation of 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 pipelinesmetrics definitiondata qualitydata governancebehavioral analysisconversion rate analysis
Soft skills
collaborationanalytical thinkingproblem-solvingcommunicationdecision-makingprioritizationadaptabilityattention to detailactionable recommendationsfast investigation
