Engenheiro de Dados Pleno GCP/DBT

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for an Engenheiro de Dados Pleno GCP/DBT based in Brazil.

Join a dynamic data-driven environment where you'll play a key role in designing, building, and optimizing modern cloud-based data platforms. In this position, you will work on large-scale data initiatives, helping transform complex business requirements into reliable and scalable data solutions. You'll collaborate with multidisciplinary teams to develop robust ELT/ETL pipelines, improve data quality, and support strategic decision-making through efficient data architecture. This role offers the opportunity to work with cutting-edge cloud technologies, contribute to high-impact projects, and continuously expand your technical expertise in a collaborative and innovation-focused setting. If you're passionate about data engineering, cloud ecosystems, and solving complex challenges, this is an excellent opportunity to grow your career.

• Analyze existing data warehouse architectures, data sources, and business requirements to define scalable cloud data solutions.
• Design and implement data architectures using Google Cloud Platform services, including data storage, processing, orchestration, and analytics components.
• Develop, maintain, and optimize ELT/ETL pipelines using DBT, BigQuery, Dataproc, Dataflow, and related technologies.
• Create efficient and scalable data models, including staging, transformation, and data mart layers aligned with modern data warehouse best practices.
• Define and execute data migration strategies, including full loads, incremental loads, and change data capture approaches.
• Implement data validation, monitoring, and quality controls to ensure reliability and consistency across data pipelines.
• Optimize query performance, resource utilization, and cloud infrastructure costs while maintaining scalability and operational efficiency.
• Apply data governance, security, and access control policies to ensure compliance and protect sensitive information.
• Troubleshoot and resolve performance, operational, and data-related issues across cloud environments and pipelines.
• Produce and maintain comprehensive technical documentation covering architecture, processes, pipelines, and operational procedures.
• Collaborate effectively with stakeholders, technical teams, and business areas while supporting Agile methodologies and project management practices.

Requirements

• Minimum of 3 years of hands-on experience working with DBT in production environments.
• Strong expertise in DBT concepts, including models (staging, intermediate, marts), ref(), source(), macros (Jinja), seeds, snapshots, and testing frameworks.
• Solid understanding of layered data architecture approaches such as Staging, Transformation, and Data Mart/Data Warehouse models.
• Advanced experience with Google Cloud Platform services, especially BigQuery, Cloud Storage, Dataproc, Dataflow, Composer, and IAM.
• Strong knowledge of data modeling, query optimization, partitioning, clustering, data ingestion, governance, and security best practices within BigQuery.
• Experience managing cloud storage environments, access controls, lifecycle policies, and secure data operations.
• Proficiency in Python, PySpark, and advanced SQL for data engineering, transformation, automation, and integration tasks.
• Familiarity with Shell Scripting and automation processes.
• Experience with Git-based version control systems, including GitHub and Bitbucket.
• Understanding of networking, cloud security, VPCs, firewall configurations, and access management principles.
• Strong analytical thinking, problem-solving capabilities, communication skills, and ability to collaborate in distributed teams.
• Experience working within Agile environments and using Jira for project tracking and team collaboration.

Benefits

• 100% remote work model.
• Competitive profit-sharing program (PLR).
• Comprehensive medical insurance, with dependent coverage options.
• Dental insurance for employees and eligible dependents.
• Childcare assistance.
• Meal and food allowance.
• Home office allowance.
• Educational partnerships with discounts on courses and degree programs.
• Financial support for professional certifications, including cloud certifications such as GCP, AWS, and Azure.
• Livelo rewards points program.
• TotalPass wellness and fitness program with discounted gym memberships.
• Mindfulness and mental well-being support through dedicated wellness programs.
• Collaborative, people-focused culture that encourages continuous learning and professional growth.