Data Engineer (DBT) PL

Description

Job Summary: We are seeking a talented and passionate Data Engineer to design, develop, and maintain efficient and scalable data pipelines. Key Highlights: 1. Design and develop efficient and scalable data pipelines. 2. Work with relational and non-relational databases. 3. Collaborate with Analytics, Data Science, and Software Engineering teams. ***Keyrus believes in diversity and inclusion. We encourage everyone to participate in our hiring process, regardless of gender, age, race, or religion. We do not tolerate any form of discrimination. This principle is reinforced throughout our hiring process and lived daily within the company.*** We know that outstanding results are achieved only with an outstanding team; therefore, we seek talented and passionate individuals who desire professional growth and wish to build a career path with us. **Roles and Responsibilities:** * Design, develop, and maintain efficient and scalable data pipelines. * Implement and optimize ETL/ELT processes. * Create and manage data models to ensure data reliability and integrity. * Work with relational and non-relational databases, ensuring query performance and efficiency. * Automate data ingestion, transformation, and storage processes. * Monitor data quality and governance, ensuring compliance with internal and regulatory policies. * Collaborate with Analytics, Data Science, and Software Engineering teams to deliver structured, high-performance data. **Essential Qualifications:** * Practical experience with DBT (Data Build Tool): Layered data modeling (staging, intermediate, mart). * Writing modular SQL and version control via Git. * Using Jinja for parameterization and code reuse. * Knowledge of deployment via DBT Cloud or DBT CLI. * Knowledge of Informatica PowerCenter: Creating and maintaining mappings, workflows, and sessions. * Integration with relational databases and files. * Monitoring and troubleshooting jobs. * Knowledge of component parameterization and reuse. * Experience with relational databases: * Advanced SQL for transformation and analysis. * Familiarity with tools such as Snowflake, Redshift, PostgreSQL, SQL Server, or Oracle. * Experience with data pipelines and tool integration: * Development of ETL/ELT pipelines. * Knowledge of best practices for data performance and governance. **Preferred Qualifications:** English proficiency. Our mission is to help companies unlock the full potential of Data and Digital to enhance performance, drive transformation, and generate new levers for growth and competitiveness. Join the Keyrus Team! If you'd like to learn more about us, we invite you to visit our website: http://www.keyrus.com/br/ ***Good luck!***