Data Integration Specialist
- Lakewood, United States
Posted 2 days ago
About the role
**Federal Project - Applicant must be a United States Citizen, with the ability to obtain a Public Trust**
Baer is looking for Data Integration Specialist for a 9 month Federal Remote Project.
Title: Data Integration Specialist
Location: Remote (Must be based in US)
Duration: 9+ Months
Rate: All-Inclusive
Alignment: W2 or C2C
Summary:
We are seeking a Mid-Level Data Integration Specialist to design, develop, and support data ingestion, transformation, integration, and orchestration workflows supporting Oracle APEX applications and GenAI-enabled solutions. This role will help modernize and migrate data from a legacy .NET application into the Oracle ecosystem while ensuring reliable, secure, and high-quality data for applications and AI pipelines.
Working under the Data Integration Lead, this position collaborates with APEX developers, GenAI engineers, business analysts, and DevOps teams to implement established data models, mappings, and integration standards.
Responsibilities:
- Develop and maintain ETL/ELT pipelines supporting Oracle APEX and GenAI solutions.
- Build transformations, validations, business rules, views, materialized views, stored procedures, and data services.
- Support migration of legacy .NET data schemas and business logic into modern Oracle/APEX data models.
- Integrate enterprise data into Oracle databases using REST APIs, ORDS endpoints, and approved integration tools.
- Implement data quality checks, reconciliation, exception handling, and pipeline monitoring.
- Troubleshoot data loading, transformation, schema, query performance, and integration issues.
- Partner with APEX developers to optimize application-facing queries and data structures.
- Support GenAI engineers with clean, structured data for embeddings, retrieval/RAG, and evaluation datasets.
- Collaborate with DevOps on scheduling, data refreshes, deployments, and environment management.
Experience:
- 3+ years of experience in data integration, ETL/ELT, data engineering, or application data support.
- Strong SQL skills with experience in Oracle databases.
- Hands-on experience with PL/SQL, views, materialized views, and stored procedures.
- Experience with ETL/ELT tools, source-to-target mapping, data transformation, and workflow scheduling.
- Understanding of relational data modeling and business data structures.
- Experience integrating RESTful APIs, ORDS, or service-based data sources.
- Strong troubleshooting skills across data quality, schemas, transformations, and performance.
- Experience working within Agile delivery environments.
Public Trust Security Clearance is the lowest level of additional background screening that the federal government requires for applicants of certain jobs, which includes completing a Standard Form 85 (SF85) form.
Company Overview:
Baer provides best-in-class engagement experiences for our consultants. Our job requirements are carefully vetted and are typically associated with pivotal programs offering tremendous opportunities to expand your skills leveraging the latest solutions.
Baer is an equal opportunity employer including disability/veteran.