Livelo Brasil

Mid-level Analytics Analyst

Livelo Brasil

full-time

Posted on:

Location Type: Hybrid

Location: Barueri • Brazil

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

BigQueryGoogle Cloud PlatformSQL

About the role

  • Serve as the technical reference for BI and Analytics, supporting the Tech Lead, analysts, and product owners (POs);
  • Translate business needs into analytical models, metrics, and dashboards;
  • Develop and maintain analytical pipelines in BigQuery with a focus on performance, scalability, and cost;
  • Design and maintain semantic models and executive and operational dashboards in Looker;
  • Ensure the quality, reliability, and consistency of data used in analyses;
  • Perform exploratory and diagnostic analyses to identify opportunities, risks, and business levers;
  • Work closely with business areas (Product, Marketing, CRM, Finance, Operations) as a strategic partner;
  • Contribute to defining and disseminating BI best practices, metrics, and data governance;
  • Support architectural decisions in collaboration with Data Engineering;
  • Actively participate in agile rituals, planning, and prioritization of analytical work.

Requirements

  • Hard skills (established):
  • Advanced SQL applied to large volumes of data;
  • Proficiency in Google BigQuery;
  • Analytical modeling (star schema, wide tables, incremental loads);
  • Query optimization and cost control;
  • Partitioning, clustering, and best practices;
  • Strong experience with Looker;
  • Business-oriented semantic modeling;
  • Building executive and operational dashboards;
  • Knowledge of the GCP ecosystem;
  • Integration with ingestion and transformation tools;
  • Solid fundamentals in Metrics and KPIs, descriptive and diagnostic analyses, Data Quality and validations, and code versioning (Git) applied to data projects;
  • Experience working in agile environments (Scrum/Kanban);
  • Clear and structured communication, adapting narratives for technical and non-technical audiences.
Benefits
  • Alelo meal and food cards
  • Mobility benefits for hybrid work (commuter allowance, shuttle reimbursement, fuel and toll vouchers)
  • Alelo Cultura (cultural allowance)
  • Private pension (retirement plan)
  • PPR (performance-based bonus / profit sharing)
  • Bradesco Saúde medical and dental insurance
  • Childcare / babysitting assistance
  • Zenklub (mental health platform)
  • Gympass / Wellhub (fitness benefits)
  • Life insurance
  • Rewards with Livelo points and discounts on our products
  • Education incentives (postgraduate programs, MBA, and English courses) after 1 year with the company
  • Day off for the employee during their birthday month and a half-day off on their child's birthday
  • Happy Friday (leave 1 hour early on Fridays) and Summer Dreams (leave 4 hours early on summer Fridays)
  • On-site massage, manicure, and barber services
  • Coffee and fruit available in the office
  • Recognition program
  • Creative, challenging, and relaxed work environment recognized as one of the Best Companies to Work For by Great Place to Work (GPTW) 2025.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLGoogle BigQueryanalytical modelingquery optimizationpartitioningclusteringLookermetricsdata qualityGit
Soft Skills
clear communicationstructured communicationadaptabilitycollaborationstrategic partnership