Data Assurance & ValidationManager

Ampcus, Inc; Chantilly (VA); On-site; USD 100,000 - 130,000; Full time

Job summary

A consulting firm is seeking a Data Assurance & Validation Manager in Chantilly, VA. This role demands 10 years of experience in data assurance and validates complex data transformation projects. Responsibilities include leading data validation, engaging clients directly, performing SQL analysis, and overseeing ETL testing. The ideal candidate must communicate effectively, manage team dynamics, and have strong technical skills. Competitive compensation package offered including advanced tools and team collaboration opportunities.

Qualifications

• 10 years of experience in data assurance or ETL testing.
• Hands-on experience with SQL profiling and validation.
• Ability to work independently and own deliverables.

Responsibilities

• Lead end-to-end data validation for migration and transformation.
• Act as primary liaison with clients for data validation plans.
• Validate ETL workflows using various ETL tools.

Skills

Advanced SQL

ETL testing

Data migration validation

Communication skills

Data analysis

Education

Bachelor's or Master's degree in Computer Science, Information Systems

Tools

Informatica

DataStage

Azure Data Factory

AWS Glue

Oracle

SQL Server

PostgreSQL

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. Job Title: Data Assurance & Validation Manager Location: Chantilly, VA

Job Summary:

This role is ideal for a data professional who combines technical mastery with delivery ownership - someone who can write complex SQL, interpret STTMs, guide ETL testing, and communicate confidently with clients. The Data Assurance & Validation Lead will be trusted to ensure data correctness across every stage of the pipeline while representing the team's technical and quality leadership.

Job Description:

The Data Assurance & Validation Lead/ Data Assurance Manager is responsible for ensuring the accuracy, integrity, and consistency of enterprise data across migration, transformation, and reporting projects. This role blends leadership with hands‑on execution, overseeing data quality strategy, ETL testing, and client engagement while also directly performing complex SQL validation and data reconciliation. The ideal candidate will build client confidence, mentor team members, and independently drive project delivery from planning through validation sign‑off.

Key Responsibilities:

• Lead end-to-end data validation and assurance for data migration, transformation, and consolidation initiatives.
• Act as the primary liaison with the client, translating business and technical requirements into actionable data validation plans.
• Review and interpret Source-to-Target Mapping (STTM) documents to confirm transformation accuracy, business rule alignment, and data lineage completeness.
• Perform hands‑on SQL analysis and reconciliation across multiple relational databases (Oracle, SQL Server, PostgreSQL).
• Validate ETL workflows and transformations using tools such as Informatica, DataStage, Azure Data Factory, or AWS Glue.
• Collaborate with data engineers, developers, and BI/reporting teams to resolve data discrepancies and ensure end‑to‑end accuracy.
• Design and execute data quality test plans, including record‑count checks, transformation verification, and exception handling.
• Establish repeatable templates, reusable queries, and documentation standards for data validation projects.
• Monitor and report progress, issues, and data quality metrics to internal leadership and client stakeholders.
• Mentor junior team members and coordinate testing deliverables across distributed teams.
• Proactively identify risks, recommend process improvements, and support continuous enhancement of data quality practices.

Required Qualifications:

• 10 years of experience in data assurance, ETL testing, or data migration validation across complex enterprise environments.
• Advanced SQL skills for profiling, transformation validation, and reconciliation.
• Hands‑on experience with Oracle, SQL Server, and PostgreSQL databases.
• Proficient in ETL tools such as Informatica, DataStage, Azure Data Factory, or AWS Glue.
• Demonstrated understanding of Source-to-Target Mapping (STTM) and ability to validate transformation logic end-to-end.
• Exposure to data analytics and reporting validation (e.g., Tableau, Power BI, OBIEE).
• Strong communication and presentation skills with experience engaging directly with clients.
• Ability to work independently and take full ownership of deliverables without constant supervision.
• Experience working within Agile/Scrum frameworks and using tools like JIRA or Azure DevOps.

Preferred Qualifications:

• Experience leading small teams or coordinating distributed QA/ETL resources.
• Familiarity with data governance, data lineage, and quality frameworks.
• Experience in federal or financial domains.
• Bachelor's or Master's degree in Computer Science, Information Systems, or a related discipline.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.