OFSAA Data Modeling Consultant

2 weeks, 6 days 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

Senior Microsoft Windows SQL Server DBA

PartnerOne 51-250 Media

Senior Microsoft Windows SQL Server DBA role at a large enterprise, responsible for owning mission-critical database environments and improving application performance across production and disaster recovery systems.

Active Directory Encryption New Relic PowerShell SQL Server Windows Server
3 hours, 13 minutes ago

Database Analyst

Carrie Rikon Associates 1-10 Professional Services

Database Analyst for an established New York City employee benefits consulting, insurance, and administration company, supporting database management, reporting, and technical workflow processes for employee benefits programs in a remote long-term temporary role.

SQL
3 hours, 14 minutes ago

Clinical Data Manager II/Senior Clinical Data Manager

Precision Medicine Group 251-1K Pharmaceuticals

Precision Medicine Group is hiring a Clinical Data Manager II or Senior Clinical Data Manager to manage clinical trial data activities across global projects from study start-up through database lock.

4 hours, 39 minutes ago

Sr Database Administrator

Lightspeed DMS 51-250 Automotive

Lightspeed is hiring a Senior PostgreSQL Database Administrator to manage and optimize its AWS-hosted PostgreSQL fleet for the Lightspeed DMS platform that supports dealership operations across North America.

AWS Datadog Encryption Hibernate Java Kubernetes PostgreSQL Spring Terraform
5 hours, 2 minutes 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