Data Engineer Lead

Job Summary

We are seeking a highly skilled Senior Data Engineer with extensive experience in enterprise data platforms, ETL development, data warehousing, regulatory reporting, and risk data management. The ideal candidate will have strong expertise End to End Pipeline building, ETL/ELT, Python, SQL/PLSQL, Business Object, ODI, TWS, Oracle, and financial reporting frameworks, with hands-on experience supporting Risk and Regulatory Reporting solutions within Banking and Financial Services environments.

Responsibilities

Data Engineering & Data Integration

• Design, develop, and support scalable data engineering solutions for enterprise data platforms.
• Build and maintain ETL/ELT processes, Data IKU, and Oracle Data Integrator (ODI).
• Develop robust data pipelines for ingestion, transformation, validation, and reporting.
• Ensure data quality, reconciliation, lineage, and governance across data ecosystems.
• Optimize data processing jobs for performance, scalability, and reliability.

Oracle & SQL Development

• Design and develop complex Oracle database solutions.
• Create and optimize SQL/PLSQL queries, stored procedures, functions, packages, and performance tuning solutions.
• Analyze and resolve database performance bottlenecks.
• Support data extraction, transformation, and reporting initiatives.

Data Warehouse & RFO Framework

• Work with RFO Master and Satellite data models.
• Design and enhance Master Data and Satellite layer integrations.
• Ensure consistency, quality, and governance of risk and finance data.
• Support enterprise data warehouse modernization and optimization initiatives.

Production Support & Operations

• Provide L2/L3 production support for critical data platforms.
• Investigate batch failures, data issues, and reporting discrepancies.
• Perform Root Cause Analysis (RCA) and implement preventive actions.
• Ensure adherence to SLAs and operational KPIs.
• Participate in incident, problem, and change management processes.

Automation & Scheduling

• Develop automation solutions using Python and Shell Scripting.
• Support workload automation and batch scheduling tools.
• Automate data validation, reconciliation, monitoring, and operational reporting processes.

Stakeholder Management

• Partner with Business, Risk, Finance, Regulatory, and Technology teams.
• Translate business requirements into technical data solutions.
• Participate in architecture discussions and solution design workshops.
• Provide technical leadership and mentoring to junior team members.
• Support enterprise Risk and Regulatory Reporting platforms.
• Develop and maintain reporting solutions aligned with regulatory requirements.
• Collaborate with Risk, Finance, Compliance, and Business stakeholders.
• Ensure regulatory reporting data accuracy, completeness, and audit readiness.
• Support data validation, reconciliation, and regulatory submissions.

Qualifications

• 8+ years of experience in Data Engineering and Data Warehouse environments.
• Strong hands-on expertise in Oracle, SQL, ODI, and SAP BODS.
• Experience supporting Risk & Regulatory Reporting platforms in Banking and Financial Services.
• Good understanding of RFO Master and Satellite data models.
• Proven experience in production support, incident management, and data operations.
• Ability to work with global stakeholders across Business, Risk, Finance, and Technology teams.
• Strong analytical, troubleshooting, and communication skills.
• Experience leading offshore/onshore delivery teams is highly desirable.

Mandatory Skills

Data Engineering

• Data Warehousing
• ETL / ELT Development
• Data Integration
• Data Modelling
• Data Quality & Reconciliation

Technical Skills

• DataIKU
• Advanced SQL/PLSQL
• Oracle Data Integrator (ODI)
• TWS
• Python
• Shell Scripting
• Unix/Linux
• Oracle Database

Banking & Regulatory Domain

• Risk Data Management
• Regulatory Reporting
• Financial Reporting
• Data Reconciliation
• Data Governance

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.