CEA

People Analytics Analyst – Mid-level

CEA

full-time

Posted on:

Location Type: Hybrid

Location: Barueri • 🇧🇷 Brazil

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

ETLPandasPythonSQL

About the role

  • Modeling and building dashboards in Power BI (data modeling layers, DAX, visualization UX, performance).
  • Data cleaning and preparation (extraction, cleaning, transformation) from spreadsheets, HR systems and, in the future, from the data lake.
  • Definition and maintenance of HR metrics and KPIs (e.g., headcount, turnover, absenteeism, time-to-hire, diversity, internal mobility, engagement).
  • Automation of routines (report refresh, data pipelines, scheduling/gateway).
  • Data quality & governance: ensure consistency of data sources, data dictionary, lineage and access controls.
  • Exploratory and statistical analyses (trends, correlations, segmentation, cohort analysis, basic tests).
  • Data storytelling: translate insights for executive audiences and HR/Business stakeholder teams.
  • Partnership with IT/Data Engineering to specify and consume data lake layers (datasets, schemas, partitions, security).

Requirements

  • Completed higher education (Bachelor's degree or equivalent).
  • Advanced Excel: PivotTables, Power Query, complex formulas (INDEX/MATCH, SUMIFS, array formulas), handling large datasets.
  • Power BI: Modeling (star schema, relationships, measures and calculated columns); intermediate/advanced DAX (CALCULATE, FILTER, row and filter context, time intelligence); Power Query/M for ETL; parameters and custom functions; performance tuning (cardinality reduction, incremental refresh, measure optimization); publishing, Gateway, row-level security (RLS), and workspace governance.
  • Intermediate SQL: JOINs, CTEs, subqueries, aggregations, window functions (ROW_NUMBER, SUM OVER), and query best practices for consumption in Power BI.
  • Python for data wrangling (pandas) and integration with HR APIs/SaaS.
  • Data fundamentals: dimensional modeling (fact/dimension), data quality, lineage, metadata.
  • Applied statistics: sampling, correlation, simple linear regression, basic A/B tests, measures of dispersion.
  • Data storytelling: visualization best practices (visual readability, appropriate chart selection, labels, colors, accessibility).
  • Good documentation practices: metrics dictionary, glossary, update playbooks, versioning.
  • Analytical and critical thinking, clear communication with non-technical stakeholders, autonomy and organization, ability to work collaboratively with a focus on impact, ethics and confidentiality.
Benefits
  • Medical and Dental insurance (employee and dependents).
  • Dr. C&A – Telemedicine and teletherapy services.
  • Annual bonus.
  • Parking or commuting allowance (Work location: Alphaville – Barueri/SP).
  • Birthday Day Off: one extra day off during your birthday month.
  • Flexible working hours.
  • On-site cafeteria.
  • Flexible Meal Benefit (meal and/or food card).
  • Gympass.
  • Semi-annual vacation scheme.
  • "Programa Amigo" (psychological, legal and social support).
  • Pharmacy partnership with payroll discount.
  • Discounts at C&A stores and online store.

Applicant Tracking System Keywords

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

Hard skills
Power BIDAXdata modelingdata cleaningSQLPythonExceldata governanceapplied statisticsdata storytelling
Soft skills
analytical thinkingcritical thinkingclear communicationautonomyorganizationcollaborationimpact focusethicsconfidentiality
Certifications
Bachelor's degree