Data Engineer II

ApplyLogic Consulting Group, LLC; United States; On-site; USD 75,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

Continuing education support

Job summary

ApplyLogic Consulting Group, LLC in Northern Virginia is seeking a data engineer to support enterprise data infrastructure and data pipelines. You will develop SQL queries, validate data, and help monitor ETL/ELT processes while collaborating with cross-functional teams.

Requirements include a Bachelor's degree in a technical field and 2+ years in data engineering, with strong SQL skills and experience with relational databases. U.S.

Qualifications

• 2+ years in data engineering, DB administration, data integration, ETL/ELT.
• Bachelor's degree in a related technical field; equivalence considered.
• Strong SQL development and relational DB skills.
• Experience with ETL/ELT processes and data pipelines.
• Ability to analyze problems and identify root causes.
• Strong documentation and collaboration skills.
• Ability to work independently and manage multiple priorities.

Responsibilities

• Support administration, maintenance, and day-to-day operation of enterprise data infrastructure and databases.
• Develop, maintain, and execute SQL queries to retrieve and analyze data.
• Support ETL/ELT processes and data pipelines.
• Assist data integration across databases, applications, and systems.
• Monitor data processes and identify performance issues and data quality concerns.
• Troubleshoot database and data pipeline issues.
• Document data processes and configurations.
• Work with developers and analysts to resolve data-related issues.
• Assist with performance tuning and optimizations.
• Support scheduled data loads and processing tasks.
• Follow security, change management, and data governance practices.
• Participate in testing and troubleshooting enhancements.

Skills

SQL development

Data integration

ETL/ELT

Troubleshooting

Documentation

Collaboration

Independent work

Education

Bachelor's degree in a related technical field

Tools

SSIS

Informatica

Talend

Azure Data Factory

AWS

Azure

SQL Server

Oracle

PostgreSQL

REST APIs

PowerShell

Python

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.