Data Modeling Consultant

FormativGroup

OFSAA Data Modeling Consultant developing scalable OFSAA-based solutions. Partnering with teams to analyze requirements and implement data models across client environments.

Posted 5/14/2026full-timeFlorida, New Jersey, New York, North Carolina • 🇺🇸 United StatesMid-LevelSenior💰 $55 - $66 per hourWebsite

Tech Stack

Tools & technologies

ETLOracleSQL

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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

Benefits

Comp & perks

Medical
Dental
Vision
401(k)
Paid time off

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

OFSAAETLELTSQLPL/SQLOracle Databasedata modelingdata lineagemetadata managementstored procedures

Soft Skills

communicationcollaborationtroubleshootingproblem-solvingclient support