OFSAA Developer :: Onsite Multiple location

HYR Global Source Inc; Columbus (OH); On-site; USD 80,000 - 110,000; Full time

Job summary

A financial technology solutions provider is seeking an OFSAA Developer to lead configuration and support of OFSAA modules. The role involves collaborating with finance teams to ensure data integrity and compliance, while performing upgrades and performance tuning. The ideal candidate should have 3-5 years of experience with OFSAA and strong SQL skills, along with a bachelor's degree. This position is full-time and located on-site in multiple locations in Ohio.

Qualifications

• 3–5+ years of hands-on experience with OFSAA 8.1.0 and 8.1.2.
• 5+ years of Data Warehouse experience.
• 5+ years of application development and implementation experience.

Responsibilities

• Lead configuration, customization, development, and support of OFSAA modules.
• Perform OFSAA patching, upgrades, and performance tuning.
• Collaborate with Finance teams to deliver enhancements aligned with business needs.

Skills

OFSAA configuration and customization

Performance tuning and patching

ETL and PL/SQL programming

Strong SQL skills

Basic Unix/Linux scripting knowledge

Education

Bachelor’s degree

Tools

OFSAA 8.1.0 / 8.1.2

IBM DB2 Data Warehouse

DataStage ETL

SQL Developer

Toad

Erwin Data Modeling

Zena Enterprise Job Scheduling

Job description

Position

Position Name: OFSAA Developer

Location: Onsite, Multiple locations

Position Type: Fulltime

Overview

Lead configuration, customization, development, and support of OFSAA modules and related data and reporting initiatives. Work with Finance teams to align IT deliverables with business needs, ensure data integrity, and support profitability calculations and regulatory reporting.

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.

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

Note: This description summarizes typical duties and qualifications and is not intended to be an exhaustive list of responsibilities. Apply as directed by the posting.