OFSAA Data Modeling Consultant

TL;DR

OFSAA Data Modeling Consultant: Support design, development, implementation, and support of Oracle Financial Services Analytical Applications solutions with an accent on data modeling, ETL/ELT development, metadata management, and application support. Focus on customizing data models, troubleshooting production issues, and delivering scalable solutions aligned to business and regulatory needs.

Location: Remote role with first week onsite required in Charlotte, NC, Hoboken, NJ, or Tampa, FL. Candidates must reside in FL, NJ, NY, or NC; must be authorized to work for any employer in the U.S. - no visa sponsorship. Candidates outside these states not eligible.

Salary: $55,000 - $66,000 USD

Company

hirify.global operates in the middle layer of business technology, specializing in cloud architecture, system integration, AI, and data strategy to unify fragmented systems for middle market companies.

What you will do

• Partner with business analysts, users, and technical teams to analyze requirements, identify gaps, and design OFSAA-based solutions
• Design, develop, and maintain ETL/ELT processes for data loading, transformation, and validation across OFSAA and source systems
• Customize, merge, and deploy OFSAA data models to meet client business and regulatory requirements
• Support staging and reporting data models, including data lineage, metadata, and data mapping
• Troubleshoot complex production issues, act as escalation point, and drive root-cause resolutions
• Handle end-to-end implementation: UAT, deployments, defect fixes, enhancements, and post-production support
• Collaborate with client stakeholders across OFSAA implementation lifecycle phases

Requirements

• Reside in FL, NJ, NY, or NC; authorized to work in U.S. without sponsorship
• Strong expertise in OFSAA staging and reporting data models, data lineage, and modeling concepts
• Hands-on with OFSAA ELT utilities: Excel File Upload, F2T, T2T, Unified Metadata Manager, SCD, AMHM
• In-depth knowledge of OFSAAI products, frameworks, metadata, hierarchies, datasets, architecture
• Advanced SQL and PL/SQL proficiency, including stored procedures
• Strong Oracle Database experience
• Proven consulting experience across OFSAA implementation lifecycle, troubleshooting issues
• Strong communication to work with business users, technical teams, stakeholders

Culture & Benefits

• Comprehensive benefits: medical, dental, vision, 401(k), paid time off
• Potential for discretionary bonuses, commissions, or incentive programs
• Pay equity and transparency based on experience, skills, location, equity
• Equal opportunity employer
• Reasonable accommodations for disabilities