Rueda & Rueda Advogados

Senior Data Analyst

Rueda & Rueda Advogados

full-time

Posted on:

Location Type: Hybrid

Location: Recife • Brazil

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AzureETLMySQLPandasPostgresPythonSQLSSIS

About the role

  • Gather and understand requirements with business areas, translating requests into indicators, metrics and success criteria.
  • Define and maintain KPIs aligned with the company's strategic objectives.
  • Model analytical data (dimensional modeling, star schema, semantic layer, SCD and granularity).
  • Build, maintain and optimize ETL/ELT pipelines, ensuring data quality, reliability and traceability.
  • Develop executive and operational dashboards and reports, ensuring clarity, performance and governance.
  • Perform diagnostic and predictive analyses (trends, seasonality, cohort, churn, pricing and productivity).
  • Integrate data from multiple sources (ERPs, CRMs, spreadsheets and APIs).
  • Ensure data governance best practices, including documentation, data dictionary, versioning and access controls.
  • Monitor data update and quality SLAs, proposing continuous improvements.
  • Act in a consultative manner with business areas, prioritizing requests according to business impact and technical effort.
  • Promote a data-driven culture and self-service BI, supporting users with guidance and ad-hoc training.

Requirements

  • Advanced SQL proficiency (T-SQL, PostgreSQL or MySQL), including complex queries, CTEs, views and performance optimization.
  • Experience with Business Intelligence tools, preferably Power BI (DAX, Power Query and tabular modeling) or equivalents.
  • Experience with ETL/ELT processes (Power Query, SSIS, Azure Data Factory or similar).
  • Solid knowledge of data modeling for analytical environments.
  • Application of data governance best practices, version control (Git) and documentation.
  • Advanced Excel for analysis, validations and business support.
  • Knowledge of Python (pandas) for automation and analysis.
  • Experience integrating with ERPs and consuming APIs.
  • Knowledge of Data Warehousing and information security applied to analytical data (LGPD).
  • Experience in OKR-driven environments and management by metrics.
Benefits
  • Wellhub: a benefit that provides discounts at gyms and partner networks for physical activities, mindfulness, therapy, nutrition and sleep quality, with plans starting at R$35.90/month.
  • TotalPass: a benefit that provides discounts at gyms (including SmartFit). Over 250 modalities, such as weight training, massage, CrossFit, martial arts, Pilates, swimming and dance. Plans starting at R$39.90 and may include dependents.
  • Massage therapy: a program designed to relieve stress and tension so you can perform your activities with ease and motivation.
  • Active Listening: a program with exclusive plans for psychotherapy (in-person or online), so you have support whenever you need it.
  • Day Off: we acknowledge your birthday — you receive a Day Off to enjoy your day as you prefer.
  • Education Support: we believe professional growth begins with encouraging learning. We offer educational support for employees—courses, specializations or training to boost your career.
Applicant Tracking System Keywords

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

Hard Skills & Tools
SQLT-SQLPostgreSQLMySQLETLELTPower BIDAXPower QueryPython
Soft Skills
consultativedata-driven cultureguidancead-hoc trainingcommunicationprioritizationanalytical thinkingproblem-solvingcollaborationadaptability