OFSAA Data Modeling Consultant

1 month, 2 weeks 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 PHP Engineer with strong DB experience

Intetics 1K-5K Internet Software & Services

Intetics Inc. is seeking a Senior PHP Engineer to develop, maintain, and enhance web applications for a cybersecurity-focused client and its risk-based vulnerability management platform.

Agile AWS Cybersecurity Linux PHP Scrum SQL
15 hours, 58 minutes ago

Principal Collibra Architect

Attain Partners 251-1K Media

Attain Partners is hiring a Principal Collibra Architect (Ranger) to lead enterprise data governance and data intelligence implementations for clients across higher education, nonprofit, public sector, and commercial environments.

AWS Azure CRM Databricks ERP GCP Snowflake
16 hours, 13 minutes ago

MDM Data Specialist (L2)

Twilio 5K-10K Diversified Telecommunication Services

Twilio is hiring a remote MDM Data Specialist (L2) in India to steward enterprise master data, strengthen data quality, and support governance across core business domains.

Databricks GCP Snowflake SQL Twilio
1 day, 14 hours ago

Product Data Engineer

Anduril Industries 1K-5K Aerospace & Defense

Anduril Industries is hiring a Product Data Engineer to support configuration management across complex defense programs, maintaining accurate product data from requirements through manufacturing and sustainment.

Confluence JIRA
1 day, 15 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