Rox Partner

Senior Data Analyst – Power BI

Rox Partner

full-time

Posted on:

Location Type: Remote

Location: Brazil

Visit company website

Explore more

AI Apply
Apply

Job Level

About the role

  • Create complex, intuitive visualizations to monitor metrics such as attrition (academic churn), student acquisition, profitability by course, and LMS engagement.
  • Develop efficient data models in Power BI, ensuring the integrity of relationships between tables (Facts and Dimensions) in a star schema.
  • Master DAX functions for comparative time analyses and advanced business metrics.
  • Implement and manage RLS (Row-Level Security) to ensure coordinators and directors only see data for their respective units/courses.
  • Connect Power BI to Google BigQuery with high performance, optimizing queries to avoid excessive processing costs.
  • Empower business users to consume data independently, ensuring a single "version of the truth".

Requirements

  • Proven experience in data analysis.
  • Experience with Power BI Desktop, Power BI Service, Gateways and Dataflows.
  • Proficiency in DAX and Power Query (M), with strong skill in creating complex measures and handling data during extraction.
  • Experience connecting and optimizing Power BI with BigQuery in the Google Cloud environment.
  • Strong SQL skills, able to extract and validate data directly from the database to ensure dashboard data fidelity.
  • Data storytelling ability—translating numbers into visual narratives that support executive decision-making.
  • Knowledge of the education sector is a plus, with familiarity with KPIs such as average ticket (average revenue per student), re-enrollment rate, and academic delinquency.
Benefits
  • Remote work – Monday to Friday (09:00–18:00);
  • Meal benefit (VR/VA) – R$300.00 per month (cumulative) to spend as you wish (the amount is credited to your iFood account monthly and we issue an ELO card).
  • Birthday – Rox gives you a gift voucher and a day off to celebrate your special day;
  • Blog – We encourage knowledge sharing; if you publish articles on our blog (for every two approved posts) you receive a bonus;
  • Courses – Full access to RoxSchool, Alura, Pluralsight, and O'Reilly (books and talks);
  • Certifications – Reimbursement of up to R$300.00 for technology certifications + a R$300.00 bonus for each certification obtained from these providers;
  • Psychological support – Two psychotherapy sessions per month covered by ROX with partner psychologists;
  • WellHub (Gympass);
  • We provide work equipment.

Applicant Tracking System Keywords

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

Hard skills
data analysisPower BIDAXPower QuerySQLdata modelingRow-Level Securitydata extractiondata validationdata storytelling
Soft skills
communicationanalytical thinkingproblem-solvingindependent workcollaboration