Senior Analytics Engineer – DBT

Rox Partner

. Develop, maintain, and optimize data transformation pipelines using DBT .

Posted 10/3/2026full-timeRemote • BrazilSenior💰 R$300 per monthWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates advanced proficiency in SQL and DBT for data transformation and analytics, alongside expertise in building and managing data workflows using Apache Airflow and Google Cloud Platform. Capable of developing dashboards and ensuring data quality through best practices in documentation and governance.

Highest-signal resume keywords

Advanced SQL ProficiencyDBT Data TransformationApache Airflow Workflow ManagementGoogle Cloud Platform (GCP) ExpertiseLooker Dashboard Development

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

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

Hard Skills

SQL Query OptimizationDimensional ModelingRelational ModelingData Pipeline AutomationData Quality PracticesData DocumentationData GovernanceAnalytical Solution DevelopmentPerformance TuningCost Optimization

Tools & Technologies

DBTApache AirflowGoogle Cloud Platform (GCP)BigQueryLookerPython

Industry Keywords

Analytics EngineeringBusiness Intelligence EngineeringData EngineeringModern Data StackData Pipeline Observability

Tech Stack

Tools & technologies

AirflowApacheBigQueryCloudGoogle Cloud PlatformPythonSQL

About the role

Key responsibilities & impact

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 strategic analytics and 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 across large volumes of data
Work with BigQuery to drive operational efficiency, cost optimization, and performance
Develop and maintain dashboards and semantic layers using the Looker platform
Promote best practices in data documentation, governance, and cataloging
Support business teams in defining metrics, KPIs, and analytical requirements
Participate in architecture discussions and contribute to the evolution of the organization’s data platform
Automate processes and routines using Python whenever necessary
Serve as a technical reference for the team, sharing knowledge and best practices

Requirements

What you’ll need

Strong experience as an Analytics Engineer, BI Engineer, Data Engineer, or in a related role
Advanced SQL proficiency, including dimensional and relational modeling, query optimization, and development of 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 management of analytical environments
Experience with data services in the GCP ecosystem, 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
Experience with data documentation, governance, cataloging, and quality practices
Plus: knowledge of business, product, or marketing metrics such as AARRR, CAC, LTV, retention, and engagement
Plus: experience in Modern Data Stack environments
Plus: experience with large-scale Analytics Engineering projects
Plus: knowledge of best practices for data pipeline observability and monitoring

Benefits

Comp & perks

Remote work – Monday through Friday, 9:00 a.m. to 6:00 p.m.
Home office allowance – R$300.00 per month loaded onto an iFood card for meals and food expenses
Birthday benefit – On your special day, Rox provides a gift card and a day off so you can enjoy it
Courses – Full access to RoxSchool, Alura, Pluralsight, and O’Reilly books and talks
Certifications – Reimbursement of up to R$300.00 for technology certifications, plus a R$300.00 bonus for each certification earned from these brands
Psychological support – Two therapy sessions per month with partner psychologists, funded by ROX
Wellhub (Gympass) – Partnerships with gyms and health and wellness apps
Work equipment provided