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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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)
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.
-
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.
