OFSAA Data Modeling Consultant

2 months, 1 week ago
Contract
Senior
Software Development
Formativ Group

Formativ Group

We are focused on enabling dynamic workflows, implementing the right application solutions, and ensuring your data is available when and where it’s needed.

Internet Software & Services

Description

  • 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 to load, transform, and validate data across OFSAA applications and source systems.
  • Customize, merge, and deploy the OFSAA data model to align with client 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 by 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 throughout the OFSAA implementation lifecycle.

Requirements

  • Strong expertise in OFSAA staging and reporting data models, including 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 and the ability to work directly with business users, technical teams, and client stakeholders.
  • Must be authorized to work for any employer in the U.S.; sponsorship is not available.
  • Must reside in FL, NJ, NY, or NC and be able to work onsite during the first week in Charlotte, NC, Hoboken, NJ, or Tampa, FL.
  • Not open to 3rd-party or C2C engagement.

Benefits

  • Estimated compensation range of $55 to $66 USD per hour.
  • Eligible for discretionary bonuses, commissions, or other incentive programs.
  • Comprehensive benefits package including medical, dental, and vision coverage.
  • 401(k) retirement plan.
  • Paid time off.
  • Remote work arrangement, with an onsite first week requirement.
  • Reasonable accommodations available for individuals with disabilities.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Sr. Database Administrator I (6685)

MetroStar 251-1K IT Services

MetroStar is hiring a Sr. Database Administrator I to support Oracle and Microsoft SQL database operations for production systems in a federal environment, ensuring reliability, security, and performance.

SQL Server
18 hours, 29 minutes ago

Head of Data Strategy & Core Systems

Climate First Bank is hiring a Director of Core Systems to own its Jack Henry Silverlake core banking environment and related lending and digital platforms, supporting product growth, operational efficiency, risk management, and customer experience.

Cybersecurity
18 hours, 59 minutes ago

Data Governance

impact.com 1K-5K Internet Software & Services

impact.com is hiring a Data Governance Manager to establish and maintain governance standards across Salesforce and internal tools to improve data quality, compliance, and business value.

CRM HIPAA Salesforce
19 hours, 14 minutes ago

Systems Administrator - OneStream

AvePoint 1K-5K Internet Software & Services

AvePoint is seeking a System Administrator - OneStream to help implement and support its finance operating system across financial reporting and connected business systems.

CRM NetSuite Power BI SAP
1 day, 18 hours ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers