RemoteLeads Logo
Sign Up Sign In

OFSAA Data Modeling Consultant

2 months ago
United States
Contract
Senior
Data Architect
Software Development
SQL
Apply Now
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
View All Jobs 2

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

Bounteous

SQL Developer + DBA (AWS & Azure Experience)

Bounteous 1K-5K Internet Software & Services

Bounteous is hiring an experienced SQL Developer + Database Administrator to manage and optimize production database environments across Azure SQL, AWS MySQL, and related applications in a fast-paced digital consultancy setting.

United States Contract Senior Database Administrator Software Engineer
AWS Entity Framework MySQL SQL Server
1 day, 13 hours ago
TWO95 International

Sr SAP HANA DBA - 110hr - Remote Work

TWO95 International 51-250 Internet Software & Services

Remote contract role for a Senior SAP HANA DBA supporting database operations, maintenance, and troubleshooting in a cloud environment.

United States Contract Senior Database Administrator
$208k-$250k
Ansible Shell Scripting
2 days, 12 hours ago
U

Databricks Solution Architect

Unison Group Technology consulting

Senior Consultant – Databricks at a Singapore-based consulting engagement, responsible for delivering and optimizing Lakehouse data and AI solutions for enterprise customers.

India Contract Lead Data Architect Data Engineer
AWS Azure CI/CD Databricks GCP Git Hugging Face LLM Machine Learning MLflow MLOps Prometheus Python Scala Splunk Terraform
4 days, 13 hours ago
TWO95 International

Senior Informatica IDMC Migration Consultant for 14 week project | Contract |

TWO95 International 51-250 Internet Software & Services

Two95 International is hiring a remote Senior Informatica IDMC Migration Consultant for a 14-week engagement to lead migration work from on-premises Informatica governance and data quality tools into the IDMC cloud platform.

India Contract Senior Data Architect
6 days, 13 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