**Job Summary** Professional responsible for designing, developing, optimizing, and maintaining ETL/ELT pipelines in corporate data environments, ensuring data quality, integrity, performance, and governance throughout the entire cycle of data ingestion, transformation, and delivery for analytical and strategic consumption. **Key Responsibilities** * Design, implement, and maintain robust, scalable, and efficient ETL/ELT pipelines. * Integrate data from multiple structured and unstructured sources. * Model and transform data to support analytics, dashboards, reporting, and data products. * Monitor, optimize, and tune jobs, workflows, queries, and data loads. * Ensure data quality and reliability through validations, business rules, and automation. * Document processes, workflows, and data models clearly, consistently, and up to date. * Troubleshoot and resolve incidents and issues related to data pipelines, performing root cause analysis. * Collaborate with Analytics, Engineering, and Business squads to meet technical and functional requirements. * Ensure compliance with data security and governance practices, including versioning, access control, and corporate standards. **Essential Technical Skills** **Languages and Transformations** * Advanced SQL (CTEs, window functions, tuning, and modeling). * Python for automation, data transformations, and orchestration. * Shell Script knowledge for Linux environments. **ETL/ELT Tools** * Traditional market tools: Informatica PowerCenter, Talend, SSIS, DataStage, Pentaho. * Modern frameworks and solutions: dbt, Apache Airflow, AWS Glue, Azure Data Factory, GCP Dataflow. **Storage and Databases** * Data Warehouses: Snowflake, Amazon Redshift, BigQuery, Azure Synapse. * Relational databases: Oracle, SQL Server, PostgreSQL, MySQL. * Data Lakes: Amazon S3, Azure Data Lake Storage (ADLS), Google Cloud Storage (GCS). **Architecture and Modeling** * Dimensional modeling (Kimball). * Relational modeling and normalization. * DataOps and observability best practices (logs, metrics, alerts). **Orchestration and DevOps** * Orchestration tools: Airflow, Prefect, Dagster, or similar. * Version control with Git and CI/CD pipelines. * Use of containers (Docker) and distributed environments. **MJV Benefits:** TotalPass\\Wellhub; ‍‍‍‍ Group life insurance; Meal and food allowance; Health and dental plan \- Bradesco; Training initiatives: lectures, forums, knowledge exchanges, and discussions related to our business. We are constantly connected to learn more — together; \+MJVer Program: internal referral program where you refer a colleague to join us, and if the match is successful, you receive a reward. Partnerships: want discounts? We have a Workplace group where we share partnerships with educational institutions, language schools, gyms, restaurants, products, and other services;