
Senior Data Analyst – Power BI
Rox Partner
full-time
Posted on:
Location Type: Remote
Location: Brazil
Visit company websiteExplore more
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