Senior OFSAA / Regulatory Data Engineer

Role Summary

We are seeking a highly skilled Senior OFSAA / Regulatory Data Engineer to support a major enterprise regulatory transformation initiative within the financial services industry. This role is part of a large-scale program focused on regulatory reporting modernization associated with the bank’s “Large Financial Institution (LFI)” regulatory requirements and enterprise reporting capabilities.

The ideal candidate will play a critical role in designing, developing, and supporting data ingestion, transformation, and processing pipelines that feed enterprise regulatory reporting platforms. This is a highly technical, hands-on role focused primarily on data engineering, ETL development, database processing, and integration activities rather than front-end reporting development.

The successful candidate will bring strong expertise in Oracle technologies, ETL frameworks, financial regulatory data processing, and enterprise BI/data warehousing environments, along with a solid understanding of how financial data is sourced, transformed, and consumed for regulatory reporting purposes.

Key Responsibilities

Data Engineering & ETL Development

• Design, develop, and maintain enterprise-scale data ingestion and transformation pipelines.
• Build and support ETL/data integration processes sourcing data from multiple banking and non-banking systems.
• Develop complex SQL and PL/SQL logic including procedures, packages, functions, and database objects.
• Support data processing workflows from source ingestion through final regulatory reporting layers.
• Work closely with source system teams to analyze and onboard new regulatory datasets.
• Perform data transformation, reconciliation, validation, and optimization activities.

Regulatory Reporting & Financial Data Processing

• Support regulatory reporting initiatives related to: LFI (Large Financial Institution) requirementsCCAR (Comprehensive Capital Analysis and Review)CECL (Current Expected Credit Loss)
• LFI (Large Financial Institution) requirements
• CCAR (Comprehensive Capital Analysis and Review)
• CECL (Current Expected Credit Loss)
• Develop a deep understanding of financial regulatory data and reporting requirements.
• Ensure regulatory data pipelines support enterprise auditability, traceability, and reporting accuracy.
• Collaborate with reporting and BI teams to understand downstream reporting and analytical consumption requirements.

OFSAA & Financial Applications

• Support and enhance enterprise applications built on: Oracle Financial Services Analytical Applications (OFSAA)
• Oracle Financial Services Analytical Applications (OFSAA)
• Participate in data sourcing, mapping, and integration efforts within OFSAA environments.
• Contribute to data governance, reconciliation, and regulatory compliance initiatives.

Data Warehousing & BI

• Support enterprise data warehouse environments and dimensional data models.
• Work with BI and reporting ecosystems including: ThoughtSpotTableauOAS / OBIEEOther enterprise reporting platforms
• ThoughtSpot
• Tableau
• OAS / OBIEE
• Other enterprise reporting platforms
• Understand how regulatory and financial data is consumed within BI and analytics environments.
• Collaborate with reporting teams to ensure accurate and efficient data delivery.

API & Technical Integration

• Develop and support integrations using: PythonREST APIsShell scripting
• Python
• REST APIs
• Shell scripting
• Support data exchange between enterprise applications and regulatory platforms.
• Work within Unix/Linux environments supporting automation and operational tasks.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or related field (or equivalent practical experience).
• 5+ years of hands-on experience in: Data EngineeringETL DevelopmentRegulatory Data ProcessingEnterprise Data Warehousing
• Data Engineering
• ETL Development
• Regulatory Data Processing
• Enterprise Data Warehousing
• Strong experience with: Oracle DatabaseSQL / PL-SQLETL and data integration frameworksPython scripting and API integrations
• Oracle Database
• SQL / PL-SQL
• ETL and data integration frameworks
• Python scripting and API integrations
• Strong understanding of: Data Warehousing conceptsData modelingBI/reporting ecosystemsEnterprise data processing architectures
• Data Warehousing concepts
• Data modeling
• BI/reporting ecosystems
• Enterprise data processing architectures
• Experience working in financial services or enterprise banking environments.
• Experience working across highly scalable enterprise systems and distributed environments.
• Strong analytical, troubleshooting, and communication skills.

Preferred Qualifications

• Experience with: Oracle Financial Services Analytical Applications (OFSAA)CECLCCARRegulatory risk reporting platforms
• Oracle Financial Services Analytical Applications (OFSAA)
• CECL
• CCAR
• Regulatory risk reporting platforms
• Exposure to: Data GovernanceData Quality (DQ)Metadata managementData lineage and reconciliation
• Data Governance
• Data Quality (DQ)
• Metadata management
• Data lineage and reconciliation
• Experience with BI/reporting tools such as: ThoughtSpotTableauOBIEE / OAS
• ThoughtSpot
• Tableau
• OBIEE / OAS
• Experience with: JavaREST APIsUnix/Linux shell scriptingEnterprise scheduling tools (Control-M, AutoSys)
• Java
• REST APIs
• Unix/Linux shell scripting
• Enterprise scheduling tools (Control-M, AutoSys)

What the Team is Looking For

The ideal candidate is someone who:

• Has strong hands-on technical capabilities in data engineering and ETL development.
• Understands financial and regulatory data flows end-to-end.
• Can work across ingestion, transformation, and reporting data layers.
• Brings experience within enterprise banking or regulatory reporting ecosystems.
• Understands how data is ultimately consumed within regulatory reporting and BI environments.
• Has the ability to work in highly complex enterprise financial environments with multiple source systems and regulatory requirements.

Important Notes

• This role is primarily focused on: Data ingestionData engineeringETL processingBackend regulatory data development
• Data ingestion
• Data engineering
• ETL processing
• Backend regulatory data development
• The reporting/BI exposure is important mainly to help the professional understand downstream reporting usage and regulatory consumption requirements.
• There is no regular on-call rotation requirement for this position.