OFSAA Data Modeling Consultant at FormativGroup

<p><strong>Summary:</strong></p> <p data-start="623" data-end="1003">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.</p> <p data-start="1005" data-end="1320">&nbsp;</p> <p data-start="1005" data-end="1320"><strong>Responsibilities:</strong></p> <ul data-start="1343" data-end="2529"> <li data-section-id="1urj8z0" data-start="1343" data-end="1452">Partner with business analysts, users, and technical teams to analyze requirements, identify gaps, and design effective OFSAA-based solutions</li> <li data-section-id="1urj8z0" data-start="1343" data-end="1452">Design, develop, and maintain ETL/ELT processes to load, transform, and validate data across OFSAA applications and source systems</li> <li data-section-id="1urj8z0" data-start="1343" data-end="1452">Customize, merge, and deploy the OFSAA data model in alignment with client-specific business and regulatory requirements</li> <li data-section-id="1urj8z0" data-start="1343" data-end="1452">Support OFSAA staging and reporting data model activities, including data lineage, metadata, and data mapping</li> <li data-section-id="1urj8z0" data-start="1343" data-end="1452">Act as an escalation point for application support, troubleshooting complex production issues and driving root-cause resolution</li> <li data-section-id="1urj8z0" data-start="1343" data-end="1452">Support end-to-end implementation activities, including UAT, production deployments, defect fixes, system enhancements, and post-production support</li> <li data-section-id="1urj8z0" data-start="1343" data-end="1452">Collaborate with client stakeholders and internal teams across multiple phases of the OFSAA implementation lifecycle</li> </ul> <p>&nbsp;</p> <p><strong>Qualifications:</strong></p> <ul data-start="2550" data-end="3562"> <li data-section-id="17pwyca" data-start="2550" data-end="2657">Strong expertise in OFSAA staging and reporting data models, with solid understanding of data lineage and data modeling concepts</li> <li data-section-id="17pwyca" data-start="2550" data-end="2657">Hands-on experience with OFSAA ELT utilities such as Excel File Upload, F2T, T2T, Unified Metadata Manager, SCD, and AMHM</li> <li data-section-id="17pwyca" data-start="2550" data-end="2657">In-depth knowledge of OFSAAI products, frameworks, metadata management, hierarchies, datasets, and core architectural components</li> <li data-section-id="17pwyca" data-start="2550" data-end="2657">Advanced proficiency in SQL and PL/SQL, including stored procedures</li> <li data-section-id="17pwyca" data-start="2550" data-end="2657">Strong experience working with Oracle Database</li> <li data-section-id="17pwyca" data-start="2550" data-end="2657">Proven experience supporting clients across multiple phases of the OFSAA implementation lifecycle in a consulting environment</li> <li data-section-id="17pwyca" data-start="2550" data-end="2657">Experience troubleshooting OFSAA application issues, production defects, data load failures, and system performance concerns</li> <li data-section-id="17pwyca" data-start="2550" data-end="2657">Strong communication skills with the ability to work directly with business users, technical teams, and client stakeholders</li> </ul> <p data-start="3579" data-end="3796">&nbsp;</p> <p data-start="3579" data-end="3796"><strong>Work Model:&nbsp;</strong></p> <p data-start="3579" data-end="3796">This is a remote role. Candidates must be able to work first week onsite in either Charlotte, NC, Hoboken, NJ, or Tampa, FL.</p> <p>&nbsp;</p> <ul> <li><strong><span class="NormalTextRun SCXW111917344 BCX0">Applicants must&nbsp;</span><span class="NormalTextRun SCXW111917344 BCX0">be&nbsp;</span><span class="NormalTextRun SCXW111917344 BCX0">authorized</span><span class="NormalTextRun SCXW111917344 BCX0">&nbsp;to</span><span class="NormalTextRun SCXW111917344 BCX0">&nbsp;work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa&nbsp;</span><span class="NormalTextRun SCXW111917344 BCX0">currently</span><span class="NormalTextRun SCXW111917344 BCX0">.</span></strong></li> <li><span data-contrast="auto">To be considered for this position, candidates must reside in the following U.S. states: FL, NJ, NY, or NC</span></li> <li><span data-contrast="auto">Candidates residing outside these states are not eligible for consideration currently.</span><span data-contrast="none">&nbsp;</span><span data-ccp-props="{&quot;201341983&quot;:0,&quot;335559685&quot;:720,&quot;335559739&quot;:200,&quot;335559740&quot;:276}">&nbsp;</span></li> <li><span data-ccp-props="{&quot;201341983&quot;:0,&quot;335559685&quot;:720,&quot;335559739&quot;:200,&quot;335559740&quot;:276}">Not&nbsp;open&nbsp;to&nbsp;3rd&nbsp;party/C2C&nbsp;engagement</span></li> </ul> <p>&nbsp;</p><div class="content-pay-transparency"><div class="pay-input"><div class="description"><p><span data-contrast="auto">We are committed to pay equity and transparency. The compensation range for this position represents our good faith estimate of the range we reasonably expect to pay for this role at the time of posting. The actual compensation offered will be determined based on factors such as the candidate’s experience, skills, education, work location, and internal equity.</span><span data-ccp-props="{&quot;201341983&quot;:0,&quot;335559685&quot;:720,&quot;335559739&quot;:200,&quot;335559740&quot;:276}">&nbsp;</span></p> <p><span data-contrast="auto">In addition to base pay, employees may be eligible for discretionary bonuses, commissions, or other incentive programs, as well as a comprehensive benefits package that includes medical, dental, vision, 401(k), paid time off, etc.</span><span data-ccp-props="{&quot;201341983&quot;:0,&quot;335559685&quot;:720,&quot;335559739&quot;:200,&quot;335559740&quot;:276}">&nbsp;</span></p></div><div class="title">Estimated Compensation Range:</div><div class="pay-range"><span>$55</span><span class="divider">&mdash;</span><span>$66 USD</span></div></div></div><div class="content-conclusion"><p><span data-contrast="none">FormativGroup&nbsp;operates within the critical middle layer of business technology, where applications and systems connect infrastructure to business processes. We are specialists who help the middle market take full advantage of their technology investments with deep, industry-centric&nbsp;expertise, all in one place, to unify fragmented systems.&nbsp;</span><em><span data-contrast="none">With deep technical&nbsp;expertise&nbsp;across cloud architecture, system integration, AI, and data strategy, we bridge the gap between business goals and modern platforms.</span></em><span data-contrast="auto">&nbsp;</span><span data-ccp-props="{&quot;201341983&quot;:0,&quot;335559685&quot;:720,&quot;335559739&quot;:200,&quot;335559740&quot;:276}">&nbsp;</span></p> <p><span data-contrast="auto">FormativGroup is an equal opportunity employer providing opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.</span></p> <p><span data-contrast="auto">ADA Specifications: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.</span><span data-ccp-props="{&quot;201341983&quot;:0,&quot;335559685&quot;:720,&quot;335559739&quot;:200,&quot;335559740&quot;:276}">&nbsp;</span></p> <p><span data-ccp-props="{&quot;201341983&quot;:0,&quot;335559685&quot;:720,&quot;335559739&quot;:200,&quot;335559740&quot;:276}"><span class="TextRun SCXW90414986 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW90414986 BCX0">#formativgroupcareers #WorkWithUs</span></span></span></p> <p>&nbsp;</p> <p><span data-ccp-props="{&quot;201341983&quot;:0,&quot;335559685&quot;:720,&quot;335559739&quot;:200,&quot;335559740&quot;:276}"><span class="TextRun SCXW90414986 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW90414986 BCX0">Click here to view our <a href="https://formativgroup.io/2025/11/19/privacy-policy/" target="_blank">Privacy Policy</a></span></span></span></p></div>