Data Warehouse QA & Report Analyst

The mission of Washington Health Benefit Exchange (Exchange) is to radically improve how Washington residents secure health insurance through innovative and practical solutions, an easy-to-use customer experience, our values of integrity, respect, equity and transparency, and by providing undeniable value to the health care community.

The Exchange is a public-private partnership that operates Washington Healthplanfinder, the eligibility and enrollment portal used by one in four Washington residents to obtain health and dental coverage. Through this platform, and with support from a Customer Support Center and statewide network of in-person navigators and brokers, individuals and families can shop, compare and enroll in private, qualified health plans (as defined in the Affordable Care Act) or enroll in Washington Apple Health, the state Medicaid program.

The Exchange embraces the following equity statement adopted by our Board of Directors:

Equity is fundamental to the mission of the Washington Health Benefit Exchange. The process of advancing toward equity and becoming anti-racist is disruptive and demands vigilance to dismantle deeply entrenched systems of privilege and oppression. While systemic racism is a root cause of many societal inequities, we must also use an intersectional approach to address all forms of bias and oppression, which interact with and often exacerbate racial inequities. To be successful, we must recognize the socioeconomic drivers of health and focus on people and places where needs are greatest. As we listen to community, we must hold ourselves accountable to responding to recommendations to remedy inequitable policies, systems, or practices within the Exchange’s area of influence. Our goal is that all Washingtonians have full and equal access to opportunities, power and resources to achieve their full potential.

SUMMARY

The Data Warehouse Quality Assurance (QA) and report analyst is responsible for all data products’ quality process by monitoring, inspecting, and proposing measures to correct or improve final data products to meet established quality standards. In addition, this position will be responsible to respond to ad hoc report requests.

DUTIES AND RESPONSIBILITIES

• Create quality measurements to track improvement in data/reports products

• Execute quality improvement testing and activities

• Develop quality assurance standards and processes

• Ensure data products (reports, dashboards, ETL, etc.) meet established standards of accuracy and customers’ expectation

• Create log documenting errors and issues for fixing

• Performing routine inspections and quality tests

• Identifying and resolving workflow and production issues

• Addressing and discussing issues and proposed solutions with manager

• Work closely with DW developers and report developers to improve current processes/products

• Maintain standards for reliability and performance of production

• Develop and analyze DW reports using SQL and PowerBI

QUALIFICATIONS

Required:

• 4 years’ experience in Quality Assurance

• Experience in methods and concepts of data warehouse quality assurance

• 3 years of SQL experience, including developing test cases

• 2 years’ experience working with PowerBI

• Experience in automating test cases

• Knowledge of standards, best practice of DW Quality assurance

• Experience in cross checking, validating, and analyzing data and reports

• Outstanding attention to details

• Strong verbal communication and can develop and manage user relationships

• Ability to function in a high volume setting with tight deadlines

• Strong stakeholder engagement

• Strong organizational skills

Desired:

• MS Azure Cloud and AAS knowledge

• Data Warehousing modeling

APPLICATION INSTRUCTIONS

This position will be open until we find a suitable number of candidates to review. If interested, please submit an application with a cover letter as soon as possible. The Exchange reserves the right to close the recruitment at any time.

SALARY INFORMATION

The hiring salary range is between minimum of $79,723.00 and the midpoint of $86,656.00 depending on candidate experience, internal equity, and the market. Our compensation policy reserves the salary range above the midpoint for meeting and exceeding expectations and growth and development, up to the maximum of $103,987.00.

BENEFITS

Take a peek at our benefits package.

WORKING CONDITIONS

Core business hours are 8:00 a.m. to 5:00 p.m., Monday through Friday. There are times where irregular hours will be required. The preferred duty station is our Olympia, Washington headquarters. The nature of this role relies heavily on remote and in-person collaboration. While a hybrid remote and on-site schedule may be considered, the position will require flexibility to allow for in-office availability as business needs dictate. Travel requirements will be limited, however there may be occasions where an employee is required to travel and work irregular hours to attend meetings or trainings. Duties of this position require the use of standard office furniture and equipment, including setup for remote work. The employee is responsible for providing and maintaining a safe, ergonomic, and secure workspace at their remote location.

The working conditions and physical demands are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

SPECIAL REQUIREMENTS

A criminal background screen will be conducted for candidates under final consideration, and if hired, every five years of employment where highly sensitive data is processed or maintained by the position. The result of this background screen must meet the Exchange’s eligibility standards.

OTHER INFORMATION

The above statements are intended to describe the general nature and levels of work being performed. They are not intended to be construed as an exhaustive list of responsibilities, duties and skills of personnel so classified.

This is not an employment agreement or contract. Management has the exclusive right to alter this job description at any time without notice.

The Washington Health Benefit Exchange is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, marital status, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

We participate in E-Verify. You can view the Department of Justice's Right to Work poster here.