Data Engineer

ADP, Inc.; Herndon (VA); On-site; USD 110,000 - 150,000; Full time

Job summary

ADP, Inc. is seeking a Data Engineer in Herndon, VA to design, build, and maintain data infrastructure supporting a modernized platform. The role focuses on ETL pipelines, data migrations, and governance to ensure data quality and traceability across systems.

The candidate will collaborate with SMEs, define mappings, and optimize SQL Server workloads while adhering to CI/CD practices and Agile ceremonies. A technical bachelor’s degree and U.S. eligibility are required.

Qualifications

• 4+ years of data engineering, ETL, database, or data migration experience.
• Experience designing ETL pipelines using SSIS or comparable tools.
• Strong proficiency with Microsoft SQL Server, including database/schema design and query optimization.
• Experience with enterprise data migration, source-to-target mapping, data transformation, validation, and data quality.
• Ability to obtain and maintain a Public Trust Background Investigation.

Responsibilities

• Design, develop, and maintain ETL/data pipelines for legacy data migration.
• Define and document source-to-target mappings, transformation rules, validation logic, and data migration procedures.
• Collaborate with SMEs and stakeholders to validate data mappings, business rules, and migrated data.
• Design and maintain scalable data architectures, database schemas, Data Dictionaries, and ERDs.
• Manage ETL processes and monitor execution results to ensure data quality and traceability.
• Optimize Microsoft SQL Server schemas, queries, indexes, and data workflows for performance.
• Design and support data interfaces and integrations with internal and external systems, including APIs.
• Ensure data governance, security, and API standards are followed.
• Maintain CI/CD and automated data-layer testing and traceability to user stories.
• Troubleshoot data migration, transformation, integration, and database performance issues.
• Participate in Agile/Scrum ceremonies and maintain technical documentation.

Skills

Data engineering

ETL development

Data migration

SQL proficiency

Analytical thinking

Education

Bachelor's degree in a technical field

Bachelor’s degree in Computer Science, Information Systems, Engineering, or related technical field

Tools

SSIS

Microsoft SQL Server

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Herndon, VA, US

Employment Type: Full-Time, 40 hours per week

Employment Eligibility: This position requires U.S. Citizenship to meet federal contract requirements. Candidates must be legally authorized to work in the United States without current or future employer sponsorship. This position is not eligible for visa sponsorship.

Clearance Requirement:: Public Trust Background Investigation

Experience: Minimum 4 years

Education: Bachelor’s degree in a technical field preferred

Position Summary: The Data Engineer is responsible for designing, building, and maintaining data infrastructure and architecture for a mission-critical application modernization effort. This role supports data migration from legacy systems to the modernized platform, develops and manages ETL processes, and ensures data quality, integrity, traceability, performance, and compliance with established data governance standards.

Key Responsibilities

• Design, develop, and maintain ETL/data pipelines using SQL Server Integration Services (SSIS) or comparable technologies for legacy data migration.
• Define and document source-to-target mappings, transformation rules, validation logic, and data migration procedures.
• Collaborate with SMEs and stakeholders to validate data mappings, business rules, and migrated data.
• Design and maintain scalable data architectures, database schemas, Data Dictionaries, and Entity Relationship Diagrams (ERDs).
• Manage ETL processes and monitor execution results to ensure data quality, integrity, completeness, and traceability.
• Optimize Microsoft SQL Server schemas, queries, indexes, and data workflows for application and reporting performance.
• Design and support data interfaces and integrations with internal and external systems, including APIs and enterprise data sources.
• Ensure database and data migration activities comply with applicable data governance, security, and API standards.
• Support CI/CD and automated data-layer testing, maintaining traceability between data activities and applicable user stories.
• Troubleshoot data migration, transformation, integration, and database performance issues.
• Participate in Agile/Scrum ceremonies, including sprint planning, standups, reviews, and retrospectives.
• Maintain clear technical documentation for data architecture, transformations, migration activities, validation results, and data interfaces.

Required Qualifications

• Minimum 4 years of relevant data engineering, ETL, database, or data migration experience.
• Experience designing and implementing ETL pipelines using SSIS or comparable tools.
• Strong proficiency with Microsoft SQL Server, including database/schema design, query optimization, and index tuning.
• Demonstrated experience with enterprise data migration, source-to-target mapping, data transformation, validation, and data quality.
• Experience designing data architectures optimized for transactional and/or analytical workloads.
• Strong analytical, troubleshooting, documentation, and communication skills.
• Ability to obtain and maintain a Public Trust Background Investigation.

Prefreed Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related technical field from an accredited institution.
• Microsoft Certified: Azure Data Engineer Associate or comparable certification.
• Experience with federal data governance frameworks and NIST SP 800-53/FedRAMP environments.
• Experience with REST APIs, JSON, XML, and CSV data integrations.
• Experience supporting federal law enforcement, case management, or other government systems.
• Familiarity with Agile/Scrum and Digital.ai or similar tools.
• Experience with GIS data formats, ESRI technologies, or i2 Analyst’s Notebook.

Equal Opportunity Employer: We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.