Data Integration Engineer II

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

Benefits offered by this job

Employee Assistance Program

401K

Medical/Dental/Vision Insurance

Life/Short-Term Disability/CriticalIll

15 PTO Days

11 Federal Holidays

Up to $5K towards continuing education

Job summary

ApplyLogic Consulting Group, LLC is seeking a Data Integration Engineer II to join our team in Northern Virginia (Alexandria/Falls Church area). The role involves building and operating data integration solutions, working with SQL, ETL/ELT processes, APIs, and data pipelines to ensure accurate data movement across systems.

The position requires 2+ years in data integration or related fields, a Bachelor's degree in a technical discipline, and the ability to obtain government clearance.

Qualifications

• Bachelor's degree or equivalent in a technical field.
• 2+ years in data integration or data engineering.
• Strong SQL ability and data validation.
• Experience with ETL/ELT pipelines and data movement.
• Experience with relational databases and data governance is a plus.

Responsibilities

• Support development, maintenance, and operation of data integration solutions.
• Develop and execute SQL queries to retrieve and move data between systems.
• Assist with ETL/ELT process development and maintenance.
• Support integration between databases, applications, APIs, and enterprise systems.
• Monitor pipelines and troubleshoot data issues; perform validation and reconciliation.

Skills

SQL queries and data validation

Data integration concepts

ETL/ELT processes

Problem solving and debugging

Strong communication skills

Education

Bachelor's degree in CS/IT/Data Science or related field

Tools

SSIS

Informatica

Talend

Azure Data Factory

REST APIs

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 II to join our team supporting a complex Federal Government customer in Northern Virginia (Alexandria/Falls Church area). This individual will support the development and operation of data integration solutions that move and transform data across enterprise systems. You will work with SQL, ETL/ELT processes, APIs, and data pipelines to help ensure data is transferred accurately, reliably, and efficiently.

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

• Support the development, maintenance, and operation of data integration solutions and data pipelines.
• Develop and execute SQL queries to retrieve, transform, validate, and move data between systems.
• Assist with the development and maintenance of ETL/ELT processes.
• Support integrations between databases, applications, APIs, and other enterprise systems.
• Monitor data pipelines and integration processes to identify errors, failures, and performance issues.
• Troubleshoot data integration and pipeline issues and assist with root-cause analysis.
• Perform data validation and reconciliation to ensure data is transferred accurately and completely.
• Support data transformation and migration activities.
• Assist with the development and testing of integration solutions.
• Document data flows, integration processes, configurations, and operational procedures.
• Work with data engineers, developers, database administrators, analysts, and other technical teams.
• Follow established security, data governance, change management, and configuration management practices.

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 experience.
• 2+ years of professional experience in data integration, data engineering, ETL/ELT, database development, software development, or a related discipline.
• Experience using SQL to query, manipulate, and validate data.
• Experience supporting ETL/ELT processes or data pipelines.
• Understanding of data integration concepts and data transformation processes.
• Experience working with relational databases or other structured data sources.
• Experience troubleshooting data processing, integration, or pipeline issues.
• Ability to analyze technical problems and identify appropriate solutions.
• Strong attention to detail and ability to validate data for accuracy and completeness.
• Strong written and verbal communication skills.
• Ability to work independently while collaborating effectively with technical teams.

Preferred Qualifications

• Experience with SQL Server, Oracle, PostgreSQL, or similar relational databases.
• Experience with ETL/integration tools such as SSIS, Informatica, Talend, Azure Data Factory, or similar technologies.
• Experience developing or consuming REST APIs or web services.
• Experience with Python, PowerShell, or other scripting languages.
• Experience with AWS, Azure, or other cloud platforms.
• Experience with data migration and transformation projects.
• Experience with data warehousing and data modeling.
• Experience with enterprise data governance and data quality practices.
• Experience with source control and CI/CD practices.
• Experience supporting complex enterprise environments.
• Experience supporting U.S. government or federal contracting programs.
• Active or previously held U.S. government security clearance.

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

$85,000-$105,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.