RemoteLeaf Logo
Log in Sign up

OFSAA Data Modeling Consultant

16 hours, 45 minutes 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 13

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

Provectus

Data/ ML Solution Architect (GenAI, AWS)

Provectus 251-1K Professional Services

Provectus is hiring a Data/ML Solution Architect in a remote role to design and lead cloud and on-premise data and AI/ML solutions that support customer transformations and business outcomes.

Colombia Costa Rica Full-time Lead Data Architect Machine Learning Engineer
Agile AWS AWS CDK Azure Docker GCP Generative AI Java Kubernetes Machine Learning Microservices MLflow MLOps Neo4j Python PyTorch Terraform TypeScript
5 minutes ago
CloudLinux

Senior Database Reliability Engineer (DBRE) (worldwide remote)

CloudLinux 51-250 IT Services

CloudLinux / TuxCare is hiring a Senior Database Reliability Engineer to own and improve the reliability, automation, and incident response of its production PostgreSQL and broader database infrastructure.

Montenegro Poland Slovakia Spain Armenia Georgia Full-time Senior Database Administrator Site Reliability Engineer (SRE)
Ansible ClickHouse DNS GitLab Grafana JIRA Linux MongoDB OpsGenie PostgreSQL Redis Terraform TLS
54 minutes ago
3Cloud

Database Administrator - Cloud Platform / Infrastructure

3Cloud 251-1K Internet Software & Services

3Cloud is seeking an experienced Database Administrator to support multiple customer database migration and Azure data services projects across development, test, and production environments.

Philippines Full-time Senior Database Administrator Infrastructure Engineer
Azure Oracle SQL Server Terraform
4 hours, 2 minutes ago
Nebius

Data Engineering Team Lead (Agentic Search)

Nebius 51-250 Internet Software & Services

Nebius is seeking a Data Engineering Team Lead to own the data platform supporting its agent-native search product, spanning ingestion, warehouse architecture, analytics, and trustworthy datasets for product and business decisions.

Israel Full-time Senior Data Architect Data Engineer
Apache Airflow Apache Spark AWS dbt GCP Kafka MapReduce Python Snowflake SQL
5 hours, 7 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