We are looking for a Data Engineer Master to join our team in Brazil, working with a major US client in a fast-paced, high-impact environment. In this role, you will define, architect, and implement scalable data platforms and end-to-end ELT pipelines aligned with modern Lakehouse principles.
Requirements
- Expert level SQL with demonstrated ability to optimize, refactor, and validate large-scale transformations.
- Advanced Python (or similar) for automation, orchestration, and pipeline development.
- Hands-on architecture and engineering experience with Snowflake, including performance tuning, security, data governance, dynamic tables, and workload management.
- Advanced dbt expertise, including transformation logic, testing, documentation, deployment patterns, and CI/CD integration.
- Proven production experience with Data Vault 2.0, including Hubs, Links, Satellites, PIT tables, multi-active satellites, and Business Vault patterns.
- Experience with AutomateDV or equivalent frameworks is a strong asset.
- Deep understanding of Data Lakehouse architectures, including medallion zone structures, incremental ingestion, and open table formats (Iceberg, Delta, Hudi is a plus).
- Solid foundation in data modeling best practices, including normalized models, dimensional modeling, historization, and scalable enterprise patterns.
- Ability to translate complex business requirements into robust, extensible architectural designs.
- Experience orchestrating ELT/ETL workflows using Airflow, including DAG design, dependency strategies, and dynamic task generation.
- Familiarity with modern orchestration frameworks such as Prefect, Dagster, or AWS Glue.
- Comfort with CI/CD pipelines using GitHub Actions or similar tools, integrating dbt testing and Snowflake deployments.
- Understanding of infrastructure automation, configuration-as-code, and environment management.
Benefits
- Health and dental insurance
- Meal and food allowance
- Childcare assistance
- Extended paternity leave
- Partnership with gyms and health and wellness professionals via Wellhub (Gympass) TotalPass
- Profit Sharing and Results Participation (PLR)
- Life insurance
- Continuous learning platform (CI&T University)
- Discount club
- Free online platform dedicated to physical, mental, and overall well-being
- Pregnancy and responsible parenting course
- Partnerships with online learning platforms
- Language learning platform