Full Description

Data Analyst Engineer (ETL QA Focused)

📍 Location: Seattle, WA (Remote)

🕒 Employment Type: Full-Time

🔒 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. Testing Strategy & Governance 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. Collaboration 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 ✅ Git / Version Control 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. Regulatory/compliance-driven data environments. Why Join Us? Work on large-scale AWS data platforms and modern data architectures. Drive enterprise-wide data quality initiatives. Influence testing strategy, governance, and release readiness. Collaborate with highly skilled Data Engineering and Analytics teams. Important Requirement 🚨 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. #DataEngineering #AnalyticsEngineering #DataQuality #ETLTesting #AWS #Redshift #Athena #LakeFormation #Python #SQL #RemoteJobs #USCitizen #GreenCard #HiringNow

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 secure@hcltech.com 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.