Data Engineer II

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

Benefits offered by this job

Employee Assistance Program

401K

Medical/Dental/Vision Insurance

Life/Disability/Critical Illness/Acc마다

Job summary

ApplyLogic Consulting Group, LLC in Vienna, VA, seeks a data engineer to support enterprise data infrastructure and ETL/ELT pipelines onsite in the Northern Virginia (Alexandria/Falls Church) area. You must be a U.S.

citizen capable of obtaining government security clearance and have 2+ years in data engineering or related roles. Responsibilities include developing SQL queries, maintaining data pipelines, and ensuring data quality.

Qualifications

• Bachelor's degree in a related technical field or equivalent combination of education and experience.
• 2+ years in data engineering, database administration, data integration, ETL/ELT.
• Strong SQL and relational database experience.
• Experience with ETL/ELT data pipelines and data integration concepts.
• Ability to analyze problems and implement solutions.
• Excellent documentation and collaboration skills.
• Ability to work independently and manage multiple priorities.

Responsibilities

• Support the administration, maintenance, and day-to-day operation of enterprise data infrastructure and database environments.
• Develop, maintain, and execute SQL queries to retrieve, validate, transform, and analyze data.
• Support ETL/ELT processes and data pipelines development, maintenance, and monitoring.
• Assist with data integration across databases, applications, and enterprise systems.
• Monitor data processes to identify performance issues, errors, and data quality concerns.
• Troubleshoot and resolve issues related to databases, data pipelines, and data processing.
• Document data processes, configurations, and troubleshooting activities.
• Collaborate with developers, analysts, and DBAs to resolve data-related issues and support business requirements.
• Assist with performance tuning, optimization, and improvements to data processing and database operations.
• Support scheduled data loads and operational data management tasks.
• Follow security, configuration management, change management, and data governance practices.

Skills

SQL development

Relational databases

ETL/ELT pipelines

Data integration

Data quality

Documentation

Collaboration

Independent work

Education

Bachelor's degree in Computer Science/IT/Data Science/IS/Engineering

Equivalent combination of education and experience

Tools

SQL Server

Oracle

PostgreSQL

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.

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 administration, maintenance, and day-to-day operation of enterprise data infrastructure and database environments.
• Develop, maintain, and execute SQL queries to retrieve, validate, transform, and analyze data.
• Support the development, maintenance, and monitoring of ETL/ELT processes and data pipelines.
• Assist with data integration activities across databases, applications, and other enterprise systems.
• Monitor data processes and infrastructure to identify performance issues, errors, and potential data quality concerns.
• Troubleshoot and resolve issues related to databases, data pipelines, data transfers, and data processing.
• Perform data validation and quality checks to ensure data is accurate, complete, and available to downstream systems and users.
• Document data processes, technical procedures, configurations, and troubleshooting activities.
• Work with developers, analysts, database administrators, and other technical teams to resolve data-related issues and support business requirements.
• Assist with performance tuning, optimization, and improvements to data processing and database operations.
• Support scheduled data loads, recurring processing activities, and operational data management tasks.
• Follow established security, configuration management, change management, and data governance practices.
• Participate in testing, implementation, and troubleshooting of enhancements to data infrastructure and integration processes.

Required Education, Experience, & Skills:

• Bachelor's degree in Computer Science, Information Technology, Data Science, Information Systems, Engineering, or a related technical field.
• Equivalent combination of education, training, and relevant professional experience may be considered.
• 2+ years of experience in data engineering, database administration, data integration, ETL/ELT, or a related technical discipline.
• Strong SQL development and database skills.
• Experience with relational databases and enterprise data environments.
• Experience developing, maintaining, or troubleshooting ETL/ELT processes and data pipelines.
• Understanding of data integration concepts and system-to-system data exchange.
• Experience troubleshooting data processing, database, and pipeline issues.
• Ability to analyze technical problems, identify root causes, and implement effective solutions.
• Experience working with structured data and data transformation processes.
• Strong documentation, communication, and collaboration skills.
• Ability to work independently and manage multiple priorities in a technical environment.

Preferred Qualifications:

• Experience with SQL Server, Oracle, PostgreSQL, or similar relational database platforms.
• Experience with cloud data platforms such as AWS or Azure.
• Experience with data integration or ETL tools such as SSIS, Informatica, Talend, Azure Data Factory, or similar technologies.
• Experience developing or consuming REST APIs.
• Experience with data warehousing and dimensional data modeling.
• Experience with PowerShell, Python, or other scripting languages.
• Experience with enterprise data governance and data quality practices.
• Experience supporting large-scale or complex enterprise environments.
• Experience supporting U.S. government or federal contracting environments.
• 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

$75,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.