Data Integration Engineer

Apply Logic is a fast-paced Service-Disabled Veteran-Owned Small-Business, headquartered in Vienna, VA. Our people are our greatest asset, and our company culture is grounded on that belief. We offer challenging and interesting work in a friendly and supportive environment. Through prime and subcontracts, we deliver best-in-class expertise to solve complex technical problems.

We're looking for a talented Data Integration Engineer IV to join our team supporting a complex Federal Government customer in Northern Virginia (Alexandria/Falls Church area). This individual will serve as a senior technical expert responsible for designing and leading complex enterprise data integration solutions. You will work across databases, applications, APIs, data pipelines, and data platforms to ensure data can move securely, reliably, and efficiently across the enterprise.

• Onsite – Northern Virginia (Alexandria/Falls Church area)

Must be a U.S. Citizen with the ability to obtain and maintain Government security clearance.

• Lead the design, development, implementation, and optimization of enterprise data integration architectures and solutions.
• Provide senior technical expertise in ETL/ELT, data pipelines, APIs, data transformation, system integration, and enterprise data platforms.
• Design scalable and reliable integration solutions connecting complex systems, databases, applications, and data sources.
• Establish technical patterns, standards, and best practices for data integration and pipeline development.
• Lead complex data migration, transformation, consolidation, and modernization initiatives.
• Develop and optimize advanced SQL, data transformations, integration workflows, and pipeline architectures.
• Lead troubleshooting and root-cause analysis for complex and high-impact integration issues.
• Evaluate integration environments and recommend improvements to architecture, performance, scalability, automation, and reliability.
• Establish monitoring and operational practices for enterprise integration processes.
• Review integration designs, data mappings, interfaces, code, and implementation approaches for quality and adherence to standards.
• Collaborate with enterprise architects, developers, data engineers, database administrators, analysts, and business stakeholders.
• Translate complex technical and business requirements into scalable integration solutions.
• Provide technical leadership and mentorship to Data Integration Engineers and other technical staff.
• Develop and maintain integration architecture documentation, data flows, interface specifications, standards, and procedures.
• Identify opportunities to automate integration processes and improve operational efficiency.
• Ensure integration solutions comply with applicable security, data governance, and organizational requirements.

• Bachelor's degree in Computer Science, Information Technology, Data Science, Information Systems, Engineering, or a related technical field, or equivalent combination of education and relevant professional experience.
• 7+ years of progressively responsible experience in data integration, data engineering, ETL/ELT, database engineering, software development, or a related discipline.
• Demonstrated experience designing and leading enterprise data integration solutions.
• Advanced proficiency in SQL and enterprise relational database technologies.
• Extensive experience designing, developing, and optimizing ETL/ELT processes and data pipelines.
• Demonstrated experience integrating complex enterprise systems, applications, databases, and APIs.
• Extensive experience with data transformation, mapping, migration, validation, and reconciliation.
• Demonstrated ability to troubleshoot and resolve complex, high-impact integration and data pipeline issues.
• Experience evaluating integration architectures and recommending improvements for scalability, reliability, performance, and maintainability.
• Experience establishing technical standards, integration patterns, documentation, and development practices.
• Demonstrated ability to provide technical leadership and mentorship to other engineers.
• Strong analytical, problem-solving, communication, and stakeholder management skills.
• Ability to independently lead complex technical initiatives and manage multiple priorities.

• Advanced experience with SQL Server, Oracle, PostgreSQL, or other enterprise database technologies.
• Expert-level experience with SSIS,…