Data Integration Engineer

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

Benefits offered by this job

Employee Assistance Program

401K

Medical/Dental/Vision Insurance

Life/Short-Term Disability/CriticalIll

11 Federal Holidays

PTO

Continuing education stipend

Job summary

ApplyLogic is a fast-paced Service-Disabled Veteran-Owned Small-Business in Vienna, VA, seeking a Data Integration Engineer IV to lead enterprise data integration efforts for a Federal Government customer in the Northern Virginia area. You will design, implement, and optimize data integration architectures across databases, applications, and APIs, ensuring secure, reliable data movement.

The role requires senior technical leadership, hands-on ETL/ELT expertise, and the ability to mentor other

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Science, Information Systems, Engineering, or a related field.
• 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.

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.

Skills

SQL proficiency

ETL/ELT design

Data integration

Leadership

Stakeholder mgmt

Analytical thinking

Communication

Education

Bachelor's degree

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.