Lead Data Integration Engineer: Oracle and ETL Pipelines

Concept Plus, LLC; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Concept Plus, LLC is seeking a Data Scientist/Oracle Integration Engineer to provide technical leadership for the client management capability across federal IT programs. You will design and maintain ETL/ELT pipelines, optimize SQL workflows, and ensure data integrity across enterprise systems.

You will prioritize hands-on integration engineering, work with XML/JSON, APIs, and data mapping, and collaborate with stakeholders to ensure accurate data movement and reliable data exchanges.

Qualifications

• US Citizen required
• Bachelor's degree in data science, information systems, computer science, or related field
• 5+ years of experience in data integration supporting federal IT programs
• Secret Clearance (or higher) required

Responsibilities

• Serve as technical lead for enterprise data integration efforts
• Design, develop, and maintain ETL/ELT pipelines and data exchange processes
• Build and optimize SQL-based data workflows with Oracle emphasis
• Implement data integration using XML/JSON, APIs, and data mapping techniques
• Ensure data integrity by validating transformations and monitoring data flows
• Troubleshoot issues related to system-to-system data movement and ensure high availability
• Understand authoritative data sources and how data moves and is validated across the enterprise
• Apply domain knowledge to preserve operational meaning in integrations
• Prioritize hands-on integration engineering experience over tooling specifics

Skills

Data integration

ETL/ELT pipelines

SQL

Oracle

APIs

Data mapping

Data quality

Troubleshooting

Education

Bachelor's degree in data science / information systems / computer science

Tools

Oracle Integration

XML/JSON

Job description

Concept Plus, LLC is seeking a Data Scientist/Oracle Integration Engineer to provide technical leadership for the client management capability across federal IT programs. You will design and maintain ETL/ELT pipelines, optimize SQL workflows, and ensure data integrity across enterprise systems.

You will prioritize hands-on integration engineering, work with XML/JSON, APIs, and data mapping, and collaborate with stakeholders to ensure accurate data movement and reliable data exchanges.