Key skills
ERPPythonSQLData LakeBIPower BI
About this role
Role Overview
- Develop and maintain forecast models for key metrics (e.g., renewals, delinquency, and churn);
- Structure data pipelines, ensuring cleaning and consistency across different sources such as data lake, ERP, and spreadsheets;
- Create data visualizations that translate complex numbers into actionable insights for different areas of the company;
- Monitor actuals vs. plan, identify root causes of variances, and propose action plans;
- Automate manual routines for extracting and cross-referencing information.
Requirements
- Bachelor's degree completed;
- Advanced knowledge of SQL, with expertise in handling large databases (joins, aggregations, filters, subqueries, and CTEs);
- Advanced knowledge of Power BI, including building dynamic dashboards and creating measures in DAX;
- Advanced knowledge of Excel, applied to exploratory analyses, scenario simulations, and development of complex pivot tables;
- Experience in data analysis, with the ability to turn information into strategic insights to support decision-making.
- Differentials:
- Knowledge or experience in the education or retail sectors, especially in contexts with seasonality and demand forecasting;
- Knowledge of Python applied to data analysis and basic statistics;
- Understanding of programming logic, focusing on automation of routines and process efficiency.
Tech Stack
- ERP
- Python
- SQL
Benefits
- Tuition scholarships of up to 100% for employees, legal dependents, and household members (father, mother, and siblings), allowing up to three simultaneous scholarships;
- Health insurance fully subsidized for the employee and partially subsidized for their family, with the employee responsible for co-payments;
- Optional dental coverage to take care of your oral health;
- Meal allowance or food voucher with an option to choose according to your needs;
- Wellhub or Totalpass for flexible gym options;
- Wellz — a platform focused on employees' mental and emotional health that offers various types of support, including access to individual online therapy;
- Wellness and perks club with a dedicated program and exclusive benefits;
- Flexible dress code to promote our diversity;
- Life insurance;
- Partnership with SESC;
- Corporate University on our exclusive portal, Educare;
- Growth opportunities — today more than 60% of positions are filled through internal selection processes.