More jobs:
Data Integration Specialist; Security Clearance
Job in
Lakewood, Jefferson County, Colorado, USA
Listed on 2026-08-31
Listing for:
Baer
Full Time
position Listed on 2026-08-31
Job specializations:
-
Software Development
Data Engineering, SQL Developer
Job Description & How to Apply Below
** 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 Dev Ops 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 Dev Ops 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. ALL OPEN JOBS
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×