Develop, maintain, and optimize data transformation pipelines using DBT.
Build and manage complex data workflows using Apache Airflow.
Design and implement dimensional and relational models to support analyses and strategic KPIs.
Ensure data quality, reliability, and traceability through testing, monitoring, and engineering best practices.
Model, organize, and make datasets available for analytical consumption.
Develop and optimize high-performance SQL queries over large datasets.
Work with BigQuery to improve operational efficiency, cost optimization, and performance.
Develop and maintain dashboards and semantic layers using the Looker platform.
Promote documentation, governance, and data cataloging best practices.
Support business teams in defining metrics, KPIs, and analytical requirements.
Participate in architectural discussions and contribute to the evolution of the organization’s data platform.
Automate processes and routines using Python when necessary.
Serve as a technical reference for the team, sharing knowledge and best practices.

Proven experience as an Analytics Engineer, BI Engineer, Data Engineer, or similar role.
Advanced SQL skills, including dimensional and relational modeling, query optimization, and building analytical solutions.
Advanced experience with DBT for building, testing, documenting, and maintaining data transformation pipelines.
Experience building, maintaining, and orchestrating pipelines using Apache Airflow.
Advanced knowledge of Google Cloud Platform (GCP), with strong experience in BigQuery, including performance tuning, cost optimization, and managing analytical environments.
Experience with GCP data services such as Google Cloud Storage.
Experience developing dashboards, semantic models, and analytical solutions using the Looker platform.
Knowledge of Python for process automation, building custom pipelines, and exploratory analysis.
Familiarity with documentation, governance, data cataloging, and data quality practices.
Pluses: Knowledge of business, product, or marketing metrics such as AARRR, CAC, LTV, retention, and engagement.
Experience with Modern Data Stack environments.
Experience in large-scale Analytics Engineering projects.
Knowledge of observability and monitoring best practices for data pipelines.

Remote work – Monday to Friday (09:00–18:00).
Home-office allowance – Meal/food credit on Ifood card of R$ 300.00 per month.
Birthday – Rox gifts you a voucher and a day off to enjoy your special day.
Courses – Full access to RoxSchool, Alura platform, Pluralsight, and O'Reilly for books and talks.
Certifications – Certification reimbursement up to R$ 300.00 (TECHNOLOGY) + a R$ 300.00 bonus per qualifying certification from these brands.
Mental health support – Two psychotherapy sessions covered monthly by ROX with partner psychologists.
WellHub (Gympass) – Partnerships with gyms and health & wellness apps.
We provide work equipment.

Senior Analytics Engineer – DBT

Key skills