Data Integration Engineer IV

ApplyLogic Consulting Group, LLC; Alexandria (VA); Hybrid; USD 125,000 - 155,000; Full time

Benefits offered by this job

Employee Assistance Program

401K

Medical/Dental/Vision Insurance

Life/Short-Term Disability/Critical Il

Job summary

ApplyLogic Consulting Group, LLC is seeking a Data Integration Engineer IV to support a Federal Government customer in Northern Virginia (Alexandria/Falls Church). The role requires designing and leading complex data integration solutions across databases, applications, APIs, data pipelines, and platforms to move data securely and efficiently.

Onsite work in Northern Virginia with a U.S. government clearance requirement is required.

Qualifications

• Bachelor's degree in a technical field or equivalent experience.
• 7+ years of experience in data integration, data engineering, ETL/ELT, or related discipline.
• Experience designing and leading enterprise data integration solutions.

Responsibilities

• Lead design, development, and optimization of enterprise data integration architectures.
• Provide senior expertise in ETL/ELT, data pipelines, APIs, and data platforms.
• Design scalable integration solutions across complex systems and data sources.
• Establish standards, patterns, and best practices for data integration.
• Lead data migration, transformation, and modernization initiatives.
• Develop and optimize SQL, transformations, and pipeline architectures.
• Lead troubleshooting for complex integration issues.

Skills

SQL

ETL/ELT

Data pipelines

API integration

Enterprise data platforms

Troubleshooting

Leadership

Data transformation

Problem solving

Education

Bachelor's degree in Computer Science or related field

Tools

SSIS

Informatica

Talend

Azure Data Factory

Job description

ApplyLogic 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.

Work Location: Onsite – Northern Virginia (Alexandria/Falls Church area)

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

Primary Roles and Responsibilities

• 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.

Required Education, Experience, & Skills

• 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.

Preferred Qualifications

• Advanced experience with SQL Server, Oracle, PostgreSQL, or other enterprise database technologies.
• Expert-level experience with SSIS, Informatica, Talend, Azure Data Factory, or similar enterprise integration platforms.
• Experience designing and implementing REST APIs, web services, microservices, or event-driven integrations.
• Experience with Python, PowerShell, Java, or other programming languages used for integration and automation.
• Experience with AWS, Azure, or other cloud-based data integration services.
• Experience designing data integration solutions across hybrid cloud and on-premises environments.
• Experience with enterprise data warehouses, data lakes, lakehouses, and modern data platforms.
• Experience with data architecture, data modeling, and enterprise integration architecture.
• Experience leading large-scale data migration, modernization, or system consolidation initiatives.
• Experience with CI/CD, DevOps, Infrastructure as Code, and automated deployment practices.
• Experience with messaging technologies, streaming data, or real-time integration.
• Experience implementing data quality, metadata, and data governance requirements within integration solutions.
• Experience establishing enterprise integration standards and architecture patterns.
• Experience leading or mentoring technical engineering teams.
• Experience supporting U.S. government or federal contracting programs.
• Active or previously held U.S. government security clearance.
• Relevant professional certifications in cloud, data engineering, integration, architecture, or database technologies.

The Perks of Being on Our Team

ApplyLogic offers competitive salaries with a robust Fortune-500 type benefits package. Some of the benefits you will receive when you join us are:

• Employee Assistance Program
• 401K
• Medical/Dental/Vision Insurance
• Life/Short-Term Disability/Critical Illness/Accident Insurance
• 15 PTO Days
• 11 Federal Holidays
• Up to $5K towards continuing education and/or professional development

Salary Range

$125,000-$155,000

The posted salary range represents the anticipated compensation for this position. Final compensation will be based on the selected candidate's qualifications, years of directly relevant experience, education, certifications, security clearance, contract requirements, and other business considerations.