Pay
In line with similar jobs
$140K–$155K against $100K–$169K, the middle half of what similar US postings state.
From 163 postings in the last year. Stated ranges, not salaries paid.
Purchase, New York
Live, first seen by us 45 days agoExperience in insurance, financial services, or other highly regulated data environments is preferred. Salary Range: $140,000 - $155,000. Actual compensation for this role will depend on several factors including the cost of living associated with your work location, your qualifications, skills, competencies, and relevant experience. At Sompo, we recognize that the talent, skills, and commitment of our employees drive our success. This is why we offer competitive, high-quality compensation and benefit programs to eligible employees.Read the full posting
Employment type in the employer’s posting: Full timeFrom the employer’s posting
Lead end-to-end QA for data warehouse, Strategy and Power BI reporting projects
Manage and coordinate the work of the QA team, including onshore and offshore staff
Write SQL queries to validate data completeness, accuracy and transformations
Test Power BI reports, including visuals, measures, KPIs, and row-level security
Define QA strategy, test plans, and test cases for data warehouse and reporting projects
Lead end-to-end quality assurance activities for enterprise data warehouse, Strategy, and Power BI reporting initiatives.
Manage and coordinate the work of the QA resources, including assigning work, reviewing deliverables, tracking progress, and ensuring adherence to QA standards.
Develop and execute SQL queries to validate data completeness, accuracy, transformation logic, aggregations, calculations, and reconciliation results.
Lead testing of Power BI reports, including validation of report visuals, filters, slicers, measures, KPIs, calculations, drill-throughs, row-level security, refresh results, and alignment with business requirements.
Define QA strategy, test plans, test scenarios, test cases, test data requirements, and traceability matrices for data warehouse and reporting projects.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
In line with similar jobs
$140K–$155K against $100K–$169K, the middle half of what similar US postings state.
From 163 postings in the last year. Stated ranges, not salaries paid.
Day 45
Similar jobs usually come down between day 6 and day 52.
At Endurance, jobs usually come down by about day 77.
From 2,081 similar postings that came down, and 5 of Endurance’s. Coming down is not always a hire.
2 open jobs
Open jobs by the week we first saw them, last 12 weeks.
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
The Quality Assurance Lead will be responsible for leading QA activities for enterprise data warehouse data validation, Strategy and Power BI report testing. This role will oversee a QA team, including onshore and offshore team members, and will be accountable for defining, maintaining, and enforcing QA standards, policies, procedures, documentation, and testing best practices. This role requires strong experience in data warehouse testing, data reconciliation, SQL-based validation, report testing, test planning, defect management, and stakeholder communication. Location: This position will be based out of our Purchase, NY; Conshohocken, PA; or Charlotte, NC office. We strive for collaboration which is why we offer a work environment where our employees thrive and develop long lasting careers.
- Perform and oversee data validation, data reconciliation, source-to-target testing, ETL testing, regression testing, integration testing, user acceptance testing support, and production validation. Validate data movement across source systems, staging areas, enterprise data warehouse layers, semantic/reporting layers, Strategy outputs, and Power BI reports. - Review source-to-target mappings, business requirements, technical specifications, report requirements, and data models to identify test coverage needs and quality risks. Develop and execute SQL queries to validate data completeness, accuracy, transformation logic, aggregations, calculations, and reconciliation results. Lead testing of Power BI reports, including validation of report visuals, filters, slicers, measures, KPIs, calculations, drill-throughs, row-level security, refresh results, and alignment with business requirements. - Support testing of Strategy-related data outputs and reporting processes to ensure consistency, accuracy, completeness, and usability. Manage defect identification, documentation, prioritization, triage, tracking, retesting, and closure across QA cycles.
- Drive continuous improvement of QA processes, automation opportunities, documentation standards, and data validation practices. - Mentor QA team members and provide guidance on data warehouse testing, SQL validation, report testing, defect management, and quality assurance best practices. What you’ll bring:
- Strong hands-on experience with data warehouse testing, ETL testing, data reconciliation, source-to-target validation, data quality testing, and production validation. - Advanced SQL skills, including the ability to write complex queries for data validation, reconciliation, aggregation testing, transformation testing, and root-cause analysis. - Experience testing reports, dashboards, semantic models, datasets, measures, KPIs, filters, slicers, calculations, drill-through functionality, and report refresh results. Experience with PowerBI and Strategy preferred
- Experience reviewing source-to-target mappings, data models, technical specifications, report specifications, and business requirements to design effective test coverage. - Experience with defect management and test management tools such as Azure DevOps, Fresh Service, or similar platforms. - Experience establishing QA standards, policies, test templates, procedures, metrics, and governance practices.
Sompo has a unique opportunity for a Data Quality Assurance in our IT team. The Quality Assurance Lead will be responsible for leading QA activities for enterprise data warehouse data validation, Strategy and Power BI report testing. This role will oversee a QA team, including onshore and offshore team members, and will be accountable for defining, maintaining, and enforcing QA standards, policies, procedures, documentation, and testing best practices. This role requires strong experience in data warehouse testing, data reconciliation, SQL-based validation, report testing, test planning, defect management, and stakeholder communication.
What you’ll be doing: - Lead end-to-end quality assurance activities for enterprise data warehouse, Strategy, and Power BI reporting initiatives. Manage and coordinate the work of the QA resources, including assigning work, reviewing deliverables, tracking progress, and ensuring adherence to QA standards. - Develop, maintain, and enforce QA policies, procedures, testing standards, templates, documentation practices, and quality gates.
- Define QA strategy, test plans, test scenarios, test cases, test data requirements, and traceability matrices for data warehouse and reporting projects. - Perform and oversee data validation, data reconciliation, source-to-target testing, ETL testing, regression testing, integration testing, user acceptance testing support, and production validation. Validate data movement across source systems, staging areas, enterprise data warehouse layers, semantic/reporting layers, Strategy outputs, and Power BI reports. - Review source-to-target mappings, business requirements, technical specifications, report requirements, and data models to identify test coverage needs and quality risks. Develop and execute SQL queries to validate data completeness, accuracy, transformation logic, aggregations, calculations, and reconciliation results. Lead testing of Power BI reports, including validation of report visuals, filters, slicers, measures, KPIs, calculations, drill-throughs, row-level security, refresh results, and alignment with business requirements.
- Advanced SQL skills, including the ability to write complex queries for data validation, reconciliation, aggregation testing, transformation testing, and root-cause analysis. - Experience testing reports, dashboards, semantic models, datasets, measures, KPIs, filters, slicers, calculations, drill-through functionality, and report refresh results. Experience with PowerBI and Strategy preferred - Experience validating reports and analytics outputs against business requirements, source data, warehouse data, and defined business logic.
Complete your application on endurance.wd103.myworkdayjobs.com. The employer’s form will show what is required.
Already applied? Track this application
Are you looking for your next opportunity?
Sompo has a unique opportunity for a Data Quality Assurance in our IT team.
The Quality Assurance Lead will be responsible for leading QA activities for enterprise data warehouse data validation, Strategy and Power BI report testing. This role will oversee a QA team, including onshore and offshore team members, and will be accountable for defining, maintaining, and enforcing QA standards, policies, procedures, documentation, and testing best practices.
This role requires strong experience in data warehouse testing, data reconciliation, SQL-based validation, report testing, test planning, defect management, and stakeholder communication.
Location: This position will be based out of our Purchase, NY; Conshohocken, PA; or Charlotte, NC office. We strive for collaboration which is why we offer a work environment where our employees thrive and develop long lasting careers.
Our business, your impact, our opportunity:
What you’ll be doing:
What you’ll bring:
Salary Range: $140,000 - $155,000. Actual compensation for this role will depend on several factors including the cost of living associated with your work location, your qualifications, skills, competencies, and relevant experience.
At Sompo, we recognize that the talent, skills, and commitment of our employees drive our success. This is why we offer competitive, high-quality compensation and benefit programs to eligible employees.
Our compensation program is built on a foundation that promotes a pay-for-performance culture, resulting in higher incentive awards, on average, when the Company does well and lower incentive awards when the Company underperforms. The total compensation opportunity for all regular, full-time employees is a combination of base salary and incentives that gets adjusted upfront based on overall Company performance with final awards based on individual performance.
We continuously evaluate and update our benefit programs to ensure that our plans remain competitive and meet the needs of our employees and their dependents. Below is a summary of our current comprehensive U.S. benefit programs:
Who we are and what we stand for:
At Sompo, our shared purpose is to create meaningful value for clients, communities, and each other. We strive to foster a workplace where everyone feels respected, included, and empowered to excel. As a global organization, we embrace diversity and champion equal opportunity. Guided by our core values—Accountability, Agility, Collaboration, Development, and Integrity—we build trust and support one another to achieve our goals worldwide. Life at Sompo page
Our values come to life in how we hire and grow talent. Employment decisions are based on qualifications, merit, and organizational need, and we strive to ensure equitable access to opportunities so everyone can do their best work. If you need an accommodation for any part of the application process, please contact the recruiter in charge.
New Data Governance postings at the employers we follow are up 164% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Data Governance, by the work the posting describes.
Data governance staff keep a company's data accurate, documented and used within the rules. They agree what key fields mean, set up quality checks, track who owns each dataset and look after master data.
Postings ask for SQL, a governance tool such as Collibra or Informatica, knowledge of privacy and data rules, and a lot of work with other teams.
A data engineer builds the systems that move data; governance staff set and check the standards that data has to meet.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
Experience in insurance, financial services, or other highly regulated data environments is preferred. Salary Range: $140,000 - $155,000. Actual compensation for this role will depend on several factors including the cost of living associated with your work location, your qualifications, skills, competencies, and relevant experience. At Sompo, we recognize that the talent, skills, and commitment of our employees drive our success. This is why we offer competitive, high-quality compensation and benefit programs to eligible employees.
Purchase, New York
Working pattern and location restrictions need checking in the full posting.
No clear work-authorization passage found. Eligibility is unconfirmed.