Senior Test Lead - analytics - functional testing, SQL
United States
Job Description
Senior Test Lead - analytics - functional testing, SQL
Washington, New York

Job Summary

Sr Data Testing Engineer Role Summary We are looking for a Data Testing Engineer to ensure the accuracy, completeness, integrity, performance and reliability of semantic models and business reports. This role will be responsible for validation of semantic models, data and referential integrity, transformational logic, reconcile measures with source data and visualization are up to standards and validate only authorized and approved users has access to the data. And, shall have knowledge of health care and understand the functional details, guide the team of test engineers, ensure data testing deliverables are on track and provide complete test coverage Key Responsibilities Data Testing & Validation •    Develop and maintain test strategy - scenarios & cases, test plans, and test scripts to validate the semantic model, business rules and transformation logic by validating measures, KPIs, calculated attributes. •    Focus on 100% coverage of functional test cases specific to Data Product versions. •    Align Test Scenarios & Cases with overall test strategy / Plan , if applicable. •    Understand data product versions, functional artifacts for the business and transformation logic for the measures, KPIs. •    Validate data accuracy, completeness, and consistency and ensure semantic models serve as a single source of truth. •    Perform data reconciliation against source to identify any data discrepancies at the earliest. •    Ensure cosmetic visuals including text/image consistency, color coding, charts, scale remain consistent under various scenarios. •    Validate data refresh frequency, availability of latest data in semantic models and reports. •    Ensure performance meets SLAs, perform peak data volume testing and capture metrics. •    Provide test coverage based on overall use case understanding. Test Automation & Scripting •    Utilize data testing tool for creating & executing test cases and custom queries. •    Increase automation ratio by identifying highly repetitive scenarios. •    Develop anomaly detection scripts to monitor data integrity. •    Maintain centralized repository for test artifacts. Security & Compliance •    Work with data product teams to understand source systems and identify PII & PHI data. •    Ensure only authorized users have access to the data. Collaboration & Defect Management •    Work with UAT users, business/data analysts and product teams. •    Identify, log, and track data quality issues. •    Drive defect triage with root cause analysis. •    Communicate test results and metrics. •    Analyze UAT defects to avoid recurrence. •    Participate in sprint ceremonies (DSU, planning, retrospectives). •    Demo test strategy and results. Required Skills •    5 years testing experience in semantic models and reporting (Power BI). •    Strong analytical and issue triaging skills. •    Ability to prioritize critical issues. •    Proficient in SQL, BigQuery, GCS, JSON, XML. •    Python scripting for automation. •    Data quality tools experience. •    Strong debugging skills. •    Team guidance capability. •    Provide test summary with metrics and KPIs. •    Identify automation opportunities. •    2-3 years performance & reliability tes

Key Responsibilities

Sr Data Testing Engineer Role Summary We are looking for a Data Testing Engineer to ensure the accuracy, completeness, integrity, performance and reliability of semantic models and business reports. This role will be responsible for validation of semantic models, data and referential integrity, transformational logic, reconcile measures with source data and visualization are up to standards and validate only authorized and approved users has access to the data. And, shall have knowledge of health care and understand the functional details, guide the team of test engineers, ensure data testing deliverables are on track and provide complete test coverage Key Responsibilities Data Testing & Validation •    Develop and maintain test strategy - scenarios & cases, test plans, and test scripts to validate the semantic model, business rules and transformation logic by validating measures, KPIs, calculated attributes. •    Focus on 100% coverage of functional test cases specific to Data Product versions. •    Align Test Scenarios & Cases with overall test strategy / Plan , if applicable. •    Understand data product versions, functional artifacts for the business and transformation logic for the measures, KPIs. •    Validate data accuracy, completeness, and consistency and ensure semantic models serve as a single source of truth. •    Perform data reconciliation against source to identify any data discrepancies at the earliest. •    Ensure cosmetic visuals including text/image consistency, color coding, charts, scale remain consistent under various scenarios. •    Validate data refresh frequency, availability of latest data in semantic models and reports. •    Ensure performance meets SLAs, perform peak data volume testing and capture metrics. •    Provide test coverage based on overall use case understanding. Test Automation & Scripting •    Utilize data testing tool for creating & executing test cases and custom queries. •    Increase automation ratio by identifying highly repetitive scenarios. •    Develop anomaly detection scripts to monitor data integrity. •    Maintain centralized repository for test artifacts. Security & Compliance •    Work with data product teams to understand source systems and identify PII & PHI data. •    Ensure only authorized users have access to the data. Collaboration & Defect Management •    Work with UAT users, business/data analysts and product teams. •    Identify, log, and track data quality issues. •    Drive defect triage with root cause analysis. •    Communicate test results and metrics. •    Analyze UAT defects to avoid recurrence. •    Participate in sprint ceremonies (DSU, planning, retrospectives). •    Demo test strategy and results. Required Skills •    5 years testing experience in semantic models and reporting (Power BI). •    Strong analytical and issue triaging skills. •    Ability to prioritize critical issues. •    Proficient in SQL, BigQuery, GCS, JSON, XML. •    Python scripting for automation. •    Data quality tools experience. •    Strong debugging skills. •    Team guidance capability. •    Provide test summary with metrics and KPIs. •    Identify automation opportunities. •    2-3 years performance & reliability tes

Skill Requirements

1. Proficiency in analytics functional testing methodologies and tools
2. Strong sql querying skills for data validation and troubleshooting
3. Ability to interpret and understand complex data models and structures
4. Excellent analytical and problem-solving abilities
5. Strong communication and collaboration skills to work effectively in a team environment

Other Requirements

Sr Data Testing Engineer Role Summary We are looking for a Data Testing Engineer to ensure the accuracy, completeness, integrity, performance and reliability of semantic models and business reports. This role will be responsible for validation of semantic models, data and referential integrity, transformational logic, reconcile measures with source data and visualization are up to standards and validate only authorized and approved users has access to the data. And, shall have knowledge of health care and understand the functional details, guide the team of test engineers, ensure data testing deliverables are on track and provide complete test coverage Key Responsibilities Data Testing & Validation •    Develop and maintain test strategy - scenarios & cases, test plans, and test scripts to validate the semantic model, business rules and transformation logic by validating measures, KPIs, calculated attributes. •    Focus on 100% coverage of functional test cases specific to Data Product versions. •    Align Test Scenarios & Cases with overall test strategy / Plan , if applicable. •    Understand data product versions, functional artifacts for the business and transformation logic for the measures, KPIs. •    Validate data accuracy, completeness, and consistency and ensure semantic models serve as a single source of truth. •    Perform data reconciliation against source to identify any data discrepancies at the earliest. •    Ensure cosmetic visuals including text/image consistency, color coding, charts, scale remain consistent under various scenarios. •    Validate data refresh frequency, availability of latest data in semantic models and reports. •    Ensure performance meets SLAs, perform peak data volume testing and capture metrics. •    Provide test coverage based on overall use case understanding. Test Automation & Scripting •    Utilize data testing tool for creating & executing test cases and custom queries. •    Increase automation ratio by identifying highly repetitive scenarios. •    Develop anomaly detection scripts to monitor data integrity. •    Maintain centralized repository for test artifacts. Security & Compliance •    Work with data product teams to understand source systems and identify PII & PHI data. •    Ensure only authorized users have access to the data. Collaboration & Defect Management •    Work with UAT users, business/data analysts and product teams. •    Identify, log, and track data quality issues. •    Drive defect triage with root cause analysis. •    Communicate test results and metrics. •    Analyze UAT defects to avoid recurrence. •    Participate in sprint ceremonies (DSU, planning, retrospectives). •    Demo test strategy and results. Required Skills •    5 years testing experience in semantic models and reporting (Power BI). •    Strong analytical and issue triaging skills. •    Ability to prioritize critical issues. •    Proficient in SQL, BigQuery, GCS, JSON, XML. •    Python scripting for automation. •    Data quality tools experience. •    Strong debugging skills. •    Team guidance capability. •    Provide test summary with metrics and KPIs. •    Identify automation opportunities. •    2-3 years performance & reliability tes

Maximum Salary (US):  121000
Minimum Salary (US):  79000
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 226,300 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending December 2025 totaled $14.5 billion.

Compensation and Benefits

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.