OFSAA Developer || Remote || W2

OFSAA Developer

Contract

Onsite Preferred/Remote (OH, TX, PA, IL, MI, NC, MN)

The IT Corporate Finance Reporting team is seeking a highly experienced OFSAA Developer / Subject Matter Expert (SME) to support profitability, scale readiness, and regulatory reporting initiatives. This role will provide technical and consultative leadership on complex financial systems and work closely with Finance stakeholders to enhance and maintain the Oracle Financial Services Analytical Applications (OFSAA) suite.

The OFSAA platform serves as the bank's system of record for financial calculations including profitability, transfer pricing, loan loss reserve, equity, and profit contribution reporting. The data foundation layer feeds enterprise BI and downstream financial and risk applications.

This role requires strong technical expertise in OFSAA 8.x along with deep understanding of banking financial statements and data warehouse architecture.

Technology Environment

• OFSAA 8.1.0 / 8.1.2 Application Suite
  • OFSAAI
  • OFSALM
  • OFSFTP
  • OFSPFT
  • OFSADIH
  • OFSDF
• IBM DB2 Data Warehouse
• DataStage ETL
• Zena Enterprise Job Scheduling
• Unix/Linux
• PL/SQL
• Erwin Data Modeling
• SQL Developer / Toad

Key Responsibilities

• Lead configuration, customization, development, and support of OFSAA modules including OFSAAI, OFSALM, OFSFTP, OFSPFT, OFSADIH, and OFSDF.
• Perform OFSAA patching, upgrades, monitoring, and performance tuning.
• Design and implement data mapping from Enterprise Data Warehouse (EDW) to OFSAA (T2T development).
• Maintain and enhance OFSAA data foundation layer serving as source of truth for financial reporting.
• Collaborate closely with Finance teams to:
  • Evaluate monthly reporting requirements
  • Implement process improvements
  • Deliver enhancements aligned with business needs
• Support profitability calculations at account level and rollups by product, customer, and organizational hierarchy.
• Ensure compliance with IT SDLC processes and documentation standards.
• Troubleshoot and resolve complex technical and data issues.
• Support data warehouse implementation initiatives.
• Provide guidance and mentorship to junior technical staff as needed.

Required Qualifications

• 3 5+ years hands-on experience with OFSAA 8.1.0 and 8.1.2
• Strong experience with:
  • OFSAA configuration and customization
  • Performance tuning and patching
• 5+ years of Data Warehouse experience
• 5+ years of application development and implementation experience
• ETL and PL/SQL programming experience
• Strong SQL skills (SQL Developer / Toad)
• Experience with Erwin Data Modeling
• Basic Unix/Linux scripting knowledge
• Bachelor's degree

Preferred Qualifications

• 5+ years of Financial Services / Banking experience
• Strong understanding of:
  • Bank financial statements
  • Transfer pricing
  • Profitability calculations
  • Risk and regulatory reporting
• Experience merging models across different OFSAA instances
• Knowledge of Zena Enterprise Job Scheduling
• Strong troubleshooting and analytical skills
• Ability to work independently in a collaborative environment
• Strong communication and stakeholder engagement skills
• Continuous improvement mindset and strong team-oriented attitude