Data Specialist - Acquisition and Integration

NOV SPS Brazil is looking for a Data Specialist - Acquisition and Integration to join our Data and Business Intelligence Team!
Reporting to the Data and Business Intelligence Manager, you will be responsible for developing and maintaining data acquisition pipelines, ensuring efficient extraction, transformation, and loading (ETL) from various sources, including legacy systems, CSV/XLS exports, relational and non-relational databases, as well as APIs from cloud-based systems. The role involves ensuring data quality, integrity, and availability while optimizing ingestion processes to support advanced analytics and strategic decision-making.

Main Activities:

1. Manage and maintain the Oracle Data Integrator (ODI) database, ensuring the efficiency and stability of ETL processes.
2. Review and document existing Data Warehouse tables, ensuring they are well-defined and aligned with business needs.
3. Act as a liaison between system developers (internal and external) and database administrators to develop and optimize ETL pipelines, including API integrations with cloud solutions.
4. Support and plan future migrations of the Data Warehouse, ensuring operational continuity and efficiency in data transitions.
5. Monitor the availability of NOV on-premise and cloud applications, reporting downtimes to the server administration team and tracking issue resolution.
6. Manage data access permissions in accordance with compliance policies, ensuring security and regulatory adherence.
7. Identify potential vulnerabilities in implemented solutions, leading corrective actions to mitigate security risks.
8. Monitor application and server performance, reporting downtimes and tracking issue resolution to ensure high availability and efficiency.

Requirements:

• B.Sc. in Computer Engineering or Computer Science;
• Advanced English;
• Knowledge of ETL and Data Integration;
• On-premise and cloud databases;
• Advanced SQL;
• Cloud APIs and Integrations: Experience in consuming REST/SOAP APIs, integration with cloud services.
• Automation and Scripting: Knowledge of tools for automating data acquisition processes.
• Data Orchestration: Expertise in Data Warehouse (DWH) and data modeling/normalization techniques.

Desirable Requirements:

• Education in Information Systems, Systems Analysis or related areas;
• Certification on DB Administration;
• Certification on LGPD or GDPR;
• Knowledge of Oracle Data Integrator;
• Matillion;
• Data Governance and Security: Knowledge of best practices/compliance (LGPD, GDPR, ISO 27001);
• Access and Permission Management: RBAC and privilege management;
• Monitoring and Performance: Experience with Snowflake Query Profiling, Resource Monitors, and observability tools;
• Agile Methodologies.

* This position is eligible for hybrid work.