Senior Analytics Engineer – DBT
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior Analytics Engineer building DBT, Airflow, BigQuery, and Looker solutions. Supporting Rox Partner’s growing data consultancy through analytics engineering and governance.
Responsibilities:
- 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:
- 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:
- 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
Similar Jobs
Analytics Engineer
Analytics Engineer building dbt and BigQuery data infrastructure for LangChain’s AI agent platform. Enabling self-serve analytics, KPI dashboards, and insights into customer health, adoption, and revenue.
Senior Data Analytics Specialist
Data Developer building Azure Data Factory and OneLake pipelines for CI&T’s enterprise AI transformation solutions. Integrating ERP and CRM systems while ensuring reliable Bronze-layer ingestion.
Freelance Mid/Senior Analytics Engineer
Freelance Analytics Engineer modernizing manufacturing ERP analytics through Dynamics 365 migration. Building Microsoft Fabric, Power BI, Lakehouse, and S&OP solutions for planning insights.
Manager II, Analytics Engineering
Analytics Engineering Manager leading dbt, SQL, Airflow, and Snowflake data pipelines. Supporting Inroads’ government healthcare.gov outreach and analytics programs.
Manager, Analytics Engineering
Analytics Engineering Manager leading the Snowflake and dbt platform behind Extend’s AI-driven retail post-purchase solutions. Managing data engineers and delivering reliable analytics, risk, fraud, and financial data.
Senior Data Analytics Engineer
Senior Data Analytics Engineer building BigQuery and MariaDB pipelines, APIs, and internal tools. Turning enterprise database data into actionable business insights at MariaDB.
Data & Analytics Developer
Data & Analytics Developer building Power BI insights, Power Apps, and automated workflows for NEC Software Solutions. Supporting governments, hospitals, police forces, and other public services.
Analytics Developer
Oracle Analytics developer designing Fusion Cloud reporting and FDI components for Accenture Federal Services. Supporting compliant financial, operational, and analytics solutions for US federal agencies.
Senior Business Systems Analyst – Data Engineer
Senior Business Systems Analyst modernizing Boeing Canada’s defence sustainment systems and cloud data solutions. Translating mission needs into analytics, integrations, reporting, and operational improvements.
Senior Data Engineer, Analytics Pipeline
Senior Data Engineer building event-driven AWS and Snowflake pipelines for GDIT’s healthcare claims fraud analytics. Operationalizing signals into alerts and partner dashboards.
Senior Data Engineer – Analytics
Senior Data Engineer modeling healthcare data and governed metrics for Machinify’s AI-powered payment intelligence platform. Building dbt, Power BI, and observability systems for health plan operations.
Senior Product Analytics Engineer
Senior Product Analytics Engineer turning product data into decisions at SoSafe, a cybersecurity awareness platform. Building analytics, self-service data products, and GTM insights.
Analytics Engineer
Analytics Engineer building scalable data pipelines and governed financial data systems. Supporting Lime’s global shared micromobility business, Finance, Accounting, and external audit.
Analytics Engineer, Unity
Analytics Engineer building dbt-powered data products for Rightway’s healthcare navigation and PBM platform. Transforming healthcare data into reliable models for reporting, insights, and AI-enabled analytics.
Senior AI Analytics Engineer
Senior AI Analytics Engineer owning analytics domains, dashboards, and commercial insights. Reap’s stablecoin-powered finance platform enables global payments, cards, and expense management.
Analytics Engineer
Analytics Engineer building reliable, governed data models for Quartile’s AI-powered retail media optimization platform. Supporting e-commerce analytics, data quality, governance, and business decisions.
Analytics Engineer
Analytics Engineer building dbt models, semantic layers, and BI datasets for Niche’s school-search platform. Improving data quality and analytics capabilities for schools and families.
Analytics Engineer
Analytics Engineer building reusable SQL Server data warehouse models for ParentPay Group’s education technology platform. Supporting BI, Power BI reporting, and trusted business decision-making.
Senior Analytics Engineer
Senior Analytics Engineer building trusted analytical models for Jellyfish’s AI-integrated engineering intelligence platform. Improving data quality, metric consistency, and developer access to engineering insights.
Analytics Engineer – Supply Data Solutions
Analytics Engineer building reliable, governed supply datasets for ABOUT YOU’s fashion e-commerce platform. Developing Python/GCP pipelines and reusable analytics marts for pricing, planning, and inventory.