Data Engineer

Description

Job Summary: We are seeking a Senior Data Engineer to design, develop, and maintain robust and scalable data pipelines, integrating multiple sources to generate strategic insights. Key Highlights: 1. Work with analytics, reporting, and system integration 2. Development of robust and scalable data pipelines 3. Multidisciplinary collaboration for innovative solutions Description: * Experience as a Data Engineer, with focus on analytics, reporting, and system integration. * SAP: Hands-on experience with data extraction and integration (ECC, S/4HANA, BW/BPC). * Oracle: Proficiency in Oracle Database, including PL/SQL and query optimization. * Google BigQuery: Experience in table design, partitioning, clustering, and query optimization. * Programming Languages: Proficiency in SQL and Python for automation and pipeline development. * ETL/ELT Tools: Familiarity with tools such as Apache Airflow, Dataflow, Matillion, DataFactory, Talend, Informatica, among others. * Cloud Platforms: Solid experience with Google Cloud Platform (GCP) Composer, Dataflow, Cloud Storage, Pub/Sub. Knowledge of AWS or Azure is considered a plus. * Data Modeling: Strong expertise in dimensional modeling (Star Schema, Snowflake) and experience with lakehouse architectures. * Must have easy access to the Mogi das Cruzes region. * Employment model: Hybrid * Job Mission: * We are looking for a Senior Data Engineer to join our technology and analytics team. * This professional will be responsible for designing, developing, and maintaining robust and scalable data pipelines, with a focus on generating strategic reports and dashboards. * The role involves integrating multiple data sources such as Excel, SAP, Oracle, and Google BigQuery, and collaborating directly with business areas to transform data into valuable insights. * Responsibilities and Duties * Data Pipeline Development: Build and optimize pipelines for data ingestion, transformation, and loading, leveraging cloud computing, big data, machine learning, and generative AI technologies. * Integration of Diverse Sources: Lead integration of data from transactional systems (SAP ECC/S/4HANA, Oracle EBS/Database) and data warehouses into analytical platforms such as Google BigQuery and Fabric OneLake. * Data Modeling: Develop efficient and scalable data models aligned with reporting, dashboarding, and advanced analytics requirements. * Analytics and Visualization: Translate business requirements into technical solutions, ensuring accurate and up-to-date data for Power BI reports and dashboards. * Data Quality and Governance: Implement data validation and governance processes, ensuring consistency, compliance, and detailed technical documentation. * Performance Optimization: Identify and implement technical and operational improvements, focusing on accounting and financial modeling, as well as driving analytics initiatives. * Multidisciplinary Collaboration: Partner with various company departments to gather requirements and propose innovative solutions. 2511130202461741689