**About the area:** If you enjoy working with Data and Artificial Intelligence and want to be involved in decisions that truly move the market, this opportunity may be for you. We are looking for a Data Engineer to join BTG Pactual’s Data Analytics team, with a focus on Artificial Intelligence. Our team is multidisciplinary—comprising data scientists, analysts, and developers—and works end-to-end on building data products, in partnership with various operational areas of the bank. Our main challenge is ensuring data is structured and available to support strategic and operational decisions, with direct impact on the business. **Your day-to-day responsibilities:** * Collaborate with business-area teams to design, implement, and manage Big Data pipelines; * Build analytical tables using normalized data for consumption and use by business areas; * Use technologies such as: AWS cloud (S3, EMR, EC2, Athena, Lambda, Kinesis, Redshift, SNS, SQS, etc.) and other Big Data tools (NiFi, Sqoop, Airflow, Kafka, Spark, Hive, Presto, etc.), Python, and SQL; * Automate data workflows and pipelines to feed the data lake. **What we expect from you:** * Bachelor’s degree in Computer Science, Engineering, Mathematics, or related fields; * Experience building data pipelines on AWS—from ingesting data from multiple sources to creating analytical tables for use in AI models, analyses, and reports; * Proficiency in Spark/PySpark (must have); * Knowledge of Python and ETL-specific libraries (a plus); * Familiarity with tools such as Airflow, NiFi, Kafka, Hive, Presto, Athena, Redshift, S3, Lambda, Kinesis, etc.; * Knowledge of SQL and data modeling; * Experience with cloud-based data lakes/data warehouses; * Ability to design batch and near real-time data flows for generating metrics and actionable insights. **Differentiators:** * Experience with Infrastructure as Code (IaC), e.g., Terraform; * Experience with Lakehouse architectures; * Integrations with visualization tools such as Grafana; * AWS and/or GCP certifications; * Knowledge of enterprise-level data governance solutions. **Benefits:** * Profit and Results Sharing (PLR); * Meal and Food Allowance; * Health Insurance; * Dental Insurance; * Childcare/Babysitter Allowance; * Transportation Voucher; * WellHub; * TotalPass; * Personal Support Program (EAP); * Optional plans such as Private Pension and Life Insurance; * Pharmacy Discount; * Nutrition Program; * Pregnancy Program; * Extended Maternity and Paternity Leave – Citizen Company.