Senior Test Lead - analytics - functional testing, SQL

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, Big Query, 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, Big Query, 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, Big Query, 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