Hybrid Mid-Level Planning and Data Analyst

at YDUQS

• Job title: Mid-Level Planning and Data Analyst
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: ERP, Python, SQL
• Location requirements: Hybrid, Rio de Janeiro, Brazil

About the role

• Data Analyst responsible for developing forecast models and insights for educational metrics. Joining YDUQS in transforming education through data-driven decisions.

Responsibilities

• 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.

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.