OFSAA Data Modeling Consultant
New
F
FormativGroupFinancial Technology
Candidates must reside in the following U.S. states: FL, NJ, NY, or NCFull-TimeMiddle
Salary55 - 66 USD per hour
Apply NowOpens the employer's application page
Job Details
- Required Skills
- SQLETLData modeling
Requirements
- Strong 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
- Strong 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
- Strong communication skills with the ability to work directly with business users, technical teams, and client stakeholders
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
View Full Description & ApplyYou'll be redirected to the employer's site
