Role Overview
- Conduct assessments of BI developments on AWS to prepare for migration to GCP.
- Work directly on migrating, building, and evolving data pipelines using dbt (ELT).
- Develop and maintain DAGs in Airflow for process orchestration.
- Work with BigQuery to create, optimize, and maintain analytical tables.
- Actively participate in migrating ETL processes from AWS to GCP.
- Apply versioning best practices with GitLab, including merge flows and production deployments.
- Ensure data quality, traceability, and reliability.
- Work in a consultative manner, proposing improvements to data architecture and processes.
- Interact with cross-functional teams (Data Engineering, Analytics, Business, and IT).
Requirements
- Solid experience in BI / Data Analytics projects.
- Hands-on experience with GCP, especially BigQuery.
- Experience with ELT in Google BigQuery using dbt (incremental models, macros, tests, documentation, and best practices).
- Experience with data orchestration using Airflow.
- Familiarity with GitLab (version control, merge requests, deployments).
- Experience in analytical/dimensional data modeling.
- Previous involvement in cloud migration projects (AWS → GCP).
- Hands-on profile with the autonomy to operate in complex environments.
Preferred qualifications:
- Experience with ELT on AWS Redshift using dbt (incremental models, macros, tests, documentation, and best practices).
- Experience in data transformation and modernization projects.
- Knowledge of visualization tools (Power BI, Looker, Metabase, etc.).
- Experience with Data Governance (e.g., DataPlex).
Tech Stack
- Airflow
- Amazon Redshift
- AWS
- BigQuery
- Cloud
- ETL
- Google Cloud Platform
Benefits
- 🏥 Porto Seguro Health Insurance
- 🦷 Porto Seguro Dental Insurance
- 💰 Profit-sharing (PLR)
- 👶 Childcare Assistance
- 🍽️ Alelo Meal and Food Vouchers
- 💻 Home Office Allowance
- 📚 Partnerships with Educational Institutions
- 🚀 Support for Certifications, including Cloud certifications
- 🎁 Livelo Points
- 🏋️♂️ TotalPass
- 🧘♂️ Mindself