FormativGroup
OFSAADataModelingConsultant
Neural analysis suggests this role is
optimal for Mid+ candidates.
“OFSAA Data Modeling Consultant at FormativGroup. Skills: OFSAA data modeling, ETL/ELT development, SQL, PL/SQL. support the design, development, implementation, and support of Oracle Financial Services Analytical Applications solutions. OFSAA data modeling”
Industry & Context.
troubleshooting complex production issues; driving root-cause resolution; Experience troubleshooting OFSAA application issues, production defects, data load failures, and system performance concerns
Candidates must be able to work first week onsite in either Charlotte, NC, Hoboken, NJ, or Tampa, FL, Applicants must be authorized to work for ANY employer in the U. S., We are unable to sponsor or take over sponsorship of an employment visa currently, Candidates must reside in the following U. S. states: FL, NJ, NY, or NC, Not open to 3rd party/C2C engagement
What They're Looking For.
Must Have
expertise in OFSAA staging and reporting data models, solid understanding of data lineage and data modeling concepts, Hands-on experience with OFSAA ELT utilities such as Excel File Upload, F2T, T2T, Unified Metadata Manager, SCD, and AMHM, In-depth knowledge of OFSAAI products, frameworks, metadata management, hierarchies, datasets, and core architectural components, Advanced proficiency in SQL and PL/SQL, including stored procedures, experience working with Oracle Database, Proven experience supporting clients across multiple phases of the OFSAA implementation lifecycle in a consulting environment, Experience troubleshooting OFSAA application issues, production defects, data load failures, and system performance concerns, communication skills with the ability to work directly with business users, technical teams, and client stakeholders, Candidates must be able to work first week onsite in either Charlotte, NC, Hoboken, NJ, or Tampa, FL, Applicants must be authorized to work for ANY employer in the U. S., Candidates residing outside these states are not eligible for consideration currently
Nice to Have
Candidates must reside in the following U. S. states: FL, NJ, NY, or NC
What You'll Do.
and support of Oracle Financial Services Analytical Applications solutions
implementation activities across client environments
deliver scalable OFSAA-based solutions aligned to business and regulatory needs
and maintain ETL/ELT processes to load
and validate data across OFSAA applications and source systems
and deploy the OFSAA data model in alignment with client-specific business and regulatory requirements
Support OFSAA staging and reporting data model activities
including data lineage
Act as an escalation point for application support
Support end-to-end implementation activities
production deployments
and post-production support
Collaborate with client stakeholders and internal teams across multiple phases of the OFSAA implementation lifecycle
How You'll Work.
Team & Collaboration
partner with business, technical, and user teams; Partner with business analysts, users, and technical teams; Collaborate with client stakeholders and internal teams
Communication Scope
communication skills with the ability to work directly with business users, technical teams, and client stakeholders
Process & Methodology
end-to-end implementation activities
Full Job Description
Summary: The OFSAA Data Modeling Consultant will support the design, development, implementation, and support of Oracle Financial Services Analytical Applications solutions. This role focuses on OFSAA data modeling, ETL/ELT development, metadata management, application support, and implementation activities across client environments. The consultant will partner with business, technical, and user teams to analyze requirements, identify gaps, and deliver scalable OFSAA-based solutions aligned to business and regulatory needs. Responsibilities: Partner with business analysts, users, and technical teams to analyze requirements, identify gaps, and design effective OFSAA-based solutions Design, develop, and maintain ETL/ELT processes to load, transform, and validate data across OFSAA applications and source systems Customize, merge, and deploy the OFSAA data model in alignment with client-specific business and regulatory requirements Support OFSAA staging and reporting data model activities, including data lineage, metadata, and data mapping Act as an escalation point for application support, troubleshooting complex production issues and driving root-cause resolution Support end-to-end implementation activities, including UAT, production deployments, defect fixes, system enhancements, and post-production support Collaborate with client stakeholders and internal teams across multiple phases of the OFSAA implementation lifecycle Qualifications: Strong expertise in OFSAA staging and reporting data models, with solid understanding of data lineage and data modeling concepts Hands-on experience with OFSAA ELT utilities such as Excel File Upload, F2T, T2T, Unified Metadata Manager, SCD, and AMHM In-depth knowledge of OFSAAI products, frameworks, metadata management, hierarchies, datasets, and core architectural components Advanced proficiency in SQL and PL/SQL, including stored procedures Strong experience working with Oracle Database Proven experience supporting clients across
Applying for this OFSAA Data Modeling Consultant role?
Most applicants get filtered before a human reads their resume. See if yours makes the cut.
How to Apply on Greenhouse
- Create a Greenhouse profile before applying — it saves time across multiple applications.
- Upload your resume as a PDF; the parser handles it better than Word.
- Answer all knockout questions carefully — wrong answers auto-reject before a human sees you.
- Enable email notifications to track application status in real time.
ANONYMOUS · UNFILTERED
What do employees actually say about FormativGroup?
Real rants from real employees. Read before you apply.