Data Analyst- ETL QA Focused

HCLTech; United States; On-site; USD 78,000 - 148,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) plan

Paid time off

Paid holidays

Life insurance

Disability insurance

Employee assistance program

Job summary

HCLTech is seeking a Data Analyst Engineer with a strong Data Quality, ETL/ELT Testing, and Analytics Engineering background to drive data validation and quality governance across large-scale AWS-based data platforms.

You will partner with Data Engineers, Product Teams and stakeholders to ensure data accuracy, completeness, and reliability across critical datasets, and you will design automated validation frameworks to prevent defects before production.

Qualifications

• 6–10 years in Data Eng, Analytics Eng, or Data QA.
• Ownership of data quality strategy for production platforms.
• Experience defining release gates and preventing defective data deployments.
• Hands-on with automated validation frameworks.
• Ability to review transformation logic and orchestration workflows.
• Experience supporting data products powering applications and reporting.
• Experience with CI/CD, data governance, or data SLAs/SLOs.

Responsibilities

• Validate ETL/ELT transformations against business requirements.
• Perform source-to-target data reconciliation for completeness and accuracy.
• Identify data anomalies and quality issues across pipelines.
• Design and maintain automated data validation frameworks.
• Create dashboards to track data quality metrics.
• Configure monitoring and alerting for data quality thresholds.
• Collaborate with Data Engineers and stakeholders to ensure data reliability.
• Lead quality improvement initiatives and define DoD standards.

Skills

Advanced SQL

AWS Data Services

Python for automation

ETL/ELT architectures

Test planning & QA

Data profiling

Great Expectations/dbt Tests

Tools

Great Expectations

dbt Tests

Soda Core

Airflow

AWS Glue

Job description

Work Authorization: US Citizen or Green Card Holder Required (Due to program compliance requirements)

About the Role

We are seeking a Data Analyst Engineer with a strong Data Quality, ETL/ELT Testing, and Analytics Engineering background to drive data validation, quality governance, and testing strategy across large-scale AWS-based data platforms. This role is ideal for someone who enjoys defining "what good data looks like" and building automated frameworks that prevent data issues before they reach production.

You will partner closely with Data Engineers, Product Teams, and Business Stakeholders to ensure data accuracy, completeness, consistency, and reliability across critical reporting and application datasets.

Key Responsibilities

Data Quality & Validation

• Validate ETL/ELT transformation logic against business requirements and specifications.
• Perform source-to-target reconciliation to ensure data completeness and accuracy.
• Identify data anomalies, schema drift, silent failures, and quality issues.
• Design and maintain automated data validation frameworks and test suites.
• Conduct periodic audits and quality assessments across data pipelines.
• Define acceptance criteria and quality gates for ETL pipelines.
• Create comprehensive test plans covering functional, integration, regression, and performance testing.
• Establish Definition of Done (DoD) standards for production-ready data assets.
• Implement release validation processes and defect management workflows.
• Develop data quality SLAs for freshness, accuracy, and completeness.

Monitoring & Reporting

• Build dashboards and reporting solutions to track data quality metrics.
• Configure monitoring and alerting for data quality threshold violations.
• Measure and report on DQ scores, defect density, MTTR, and SLA compliance.
• Lead continuous improvement initiatives and quality retrospectives.
• Participate in data architecture and pipeline design reviews.
• Work with business stakeholders to translate requirements into measurable test criteria.
• Partner with Data Engineers to improve pipeline reliability and performance.
• Support downstream teams in validating data used by applications and dashboards.

Required Qualifications

Technical Skills

• Advanced SQL (CTEs, Window Functions, Complex Joins, Data Profiling)
• AWS Data Services: Redshift, Athena, Lake Formation, S3 Data Lakes
• Python for automation, validation, and data testing frameworks
• Strong knowledge of ETL/ELT architectures and failure modes
• Test Planning, Defect Lifecycle Management, and QA Methodologies
• Data Profiling, Reconciliation, and Statistical Validation Techniques
• Experience with Great Expectations, dbt Tests, Soda Core, or similar frameworks

Experience

• 6-10 years of experience in Data Engineering, Analytics Engineering, or Data QA.
• Proven ownership of data quality strategy for production data platforms.
• Experience defining release gates and preventing defective data deployments.
• Hands-on experience building automated validation frameworks.
• Ability to review and validate transformation logic and orchestration workflows.
• Experience supporting data products that power business applications and reporting.

Preferred Qualifications

• BDD-style testing for data transformations.
• CI/CD integration for automated data quality controls.
• Experience defining Data SLAs and SLOs.
• AWS Glue, Redshift Spectrum, Step Functions, or Airflow experience.
• Data governance, IAM, and Lake Formation access controls.
• Performance testing and pipeline observability.

Why Join Us?

• Work on large-scale AWS data platforms and modern data architectures.
• Influence testing strategy, governance, and release readiness.
• Collaborate with highly skilled Data Engineering and Analytics teams.

This role requires candidates to be US Citizens or Green Card Holders due to program compliance requirements. Candidates requiring current or future sponsorship cannot be considered.

Pay and Benefits

Pay Range Minimum: $ 78000 per year

Pay Range Maximum: $ 148000 per year

HCLTech is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to [e-mail] for investigation.

A candidate’s pay within the range will depend on their skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year); and 10 paid holidays per year

How You’ll Grow

At HCLTech, we offer continuous opportunities for you to find your spark and grow with us. We want you to be happy and satisfied with your role and to really learn what type of work sparks your brilliance the best. Throughout your time with us, we offer transparent communication with senior-level employees, learning and career development programs at every level, and opportunities to experiment in different roles or even pivot industries. We believe that you should be in control of your career with unlimited opportunities to find the role that fits you best.