IT Data Management – Journey (ITDM-JSPI) Internal

IT Data Management Journey (ITDM-J/SPI)

Are you a strategically thinking data technician Do you have an interest in improving the quality of behavioral health data used by state programs This position creates data management monitors and processes to ensure quality standards are met for data collected and/or utilized by behavioral health programs and providers across Washington. If you have experience with gathering and extracting this complex data this may be the position for you!

All HCA employees will apply an equity lens to their work which may include but is not limited to all analyses of core business and processes.

About the division:

The Strategy Policy and Innovation (SPI) Division makes policy decisions that guide medical coverage maintain quality standards and ensure evidence-based practices for those on whose behalf HCA purchases medical care. The Data Acquisition Transformation and Analytics (DATA) Team is within the SPI Division to provide data analytics and decision support tools to support HCAs initiatives and programs personnel work to provide data management governance and data-driven decision support applications to improve decisions and clinical quality and health care purchasing.

About the position:

This position is responsible for leading and supporting Behavioral Health Data Infrastructure (BHDI) projects for data quality processes and source improvements. Through providing strategic and tactical data integrity ingestion testing to verify the integrity of behavioral health care data which resides Behavioral Health Data Stores (BHD); Behavioral Health Data Repositories (BHDR); and ultimately HCAs Enterprise Data Warehouse (EDW). HCAs BHD must accurately measure document and improve the integrity/quality of the behavioral health data submitters and the ingestion process. This position will ensure that all three environments are kept in sync as data patches refreshes and data conversion corrections and weekly/monthly ETL and interface records are applied and/or ingested. This position establishes agency wide metadata standards to ensure consistent and accurate information is available to internal and external analysts and users.

This position is eligible to telework and is typically not required to report on-site.The default assigned work location of all Health Care Authority (HCA) positions both on-site and telework eligible positions is within the State of Washington. This position reports to Olympia WA. Frequency of onsite work will vary based on business and operational needs. HCA has currently suspended the ability to support out-of-state telework.

Some of what you will do:

• Serve as lead in the technical strategic planning and tactical operation of BHD data quality needs.
• Develop logic code and processes to support large agency extracts for internal and external use.
• Independently evaluate define and implement new data quality tools technologies and strategies.
• Work closely with the HCAs Division of Behavioral Health and Recovery (DBHR) and BHDS vendors in management of data quality and other issues with the warehouses.
• Lead and facilitate all data quality meetings with vendor staff and business stakeholders.
• Assist in development and implementation of test methodology/process.
• Review vendors work plans infrastructure diagrams and documentation and any other technical documentation.
• Establish productive working relationships across all DBHR data warehouse super users and lead super user group meetings.
• Develop data quality training plans.
• Responsible for BHD EDW data quality framework including design development and maintenance standards and capabilities.
• Conduct comprehensive review of all data warehouse related design documentation (data model ETL design etc.).
• Participate in and conduct reviews of all Change Request (CR) related documentation.
• Assist with testing and approval process for data warehouse ETL changes build and/or review test templates.
• Design code test and execute complex reports (e.g. Python Edifecs PowerBI Tableau etc.) and SQL data extracts.
• Responsible for tactical planning of large or critical data pulls.

Required qualifications:

Qualifying candidates will meet one of the following criteria options:

Option 1:

• Seven (7) years of consultative administrative or supervisory experience in information technology analysis system maintenance or troubleshooting/ problem resolution experience or analyzing designing or programming computer systems applications or databases.

Option 2:

• Associate degree and
• Five (5) years of consultative administrative or supervisory experience in information technology analysis system maintenance or troubleshooting/problem resolution experience or analyzing designing or programming computer systems applications or databases.

Option 3:

• Bachelors degree and
• Three (3) years of consultative administrative or supervisory experience in information technology analysis system maintenance or troubleshooting/problem resolution experience or analyzing designing or programming computer systems applications or databases.

Option 4:

• Masters degree and
• One (1) year of consultative administrative or supervisory experience in information technology analysis system maintenance or troubleshooting/problem resolution experience or analyzing designing or programming computer systems applications or databases.

Option 5:

• Three years as an Entry Level IT Professional in state service.

Additionally qualified candidates will also satisfy all of the following requirements. Experience may be gained concurrently with the required experience above:

• Three (3) years of experience working with a large data warehouse.
• Intermediate knowledge and experience writing SQL code Java and Python performance tuning.
• Three (3) years of experience utilizing data quality testing methodologies.
• Three (3) years of experience in interface development using SQL Server Integration Services (SSIS) or equivalent software.

Required competencies:

• The ability to take action to learn and grow.
• The ability to take action to meet the needs of others.
• Experience with and knowledge of prevailing industry data quality and database development standards.
• Experience with and knowledge of Extract Transform and Load technologies.
• Experience with and knowledge of metadata business data definitions and data dictionaries.
• Extensive knowledge of Structured Query Language (SQL) PL/SQL Python MS Excel MS Visio and Java.
• Experience with and knowledge of data reporting using Business Intelligence software.

Preferred qualifications:

• Experience with behavioral health data warehouses.
• Experience with behavioral health systems.
• Experience in creating reports using Power BI or similar BI tool software.
• Experience with any helpdesk ticketing system.

How to apply:

Only candidates who reflect the minimum qualifications on their NEOGOV profile will be considered. Failure to follow the application instructions below may lead to disqualification. To apply for this position you will need to complete your profile which includes three professional references and attach in separate files:

• A cover letter that specifically addresses how you meet the qualifications for this position
• Current resume

To take advantage of veteran preference please do the following:

• Attach a copy of your DD214 (Member 4 long-form copy) NGB 22 or USDVA signed verification of service letter.
• Please black out any PII (personally identifiable information) data such as social security numbers. Include your name as it appears on your application in .

About HCA:
Functioning as both the states largest health care purchaser and its behavioral health authority the Washington State Health Care Authority (HCA) is a leader in ensuring Washington residents have the opportunity to be as healthy as possible.

There are three pillars of our work: Apple Health (Medicaid); the Public Employees Benefits Board (PEBB) and School Employees Benefits Board (SEBB) programs; and behavioral health and recovery. Under these pillars HCA purchases health care including behavioral health treatment for more than 2.7 million Washington residents and provides behavioral health prevention crisis and recovery supports to all Washington residents.

What we have to offer:

• Meaningful work with friendly co-workers who care about those we serve Voices of HCA
• A clear agency mission that drives our work and is person-centered HCAs Mission Vision & Values
• A healthy work/life balance including alternative/flexible schedules and mobile work options.
• A great total compensation and benefit package WA State Government Benefits
• A safe pleasant workplace in a convenient location with restaurants and shopping nearby.
• And free parking!

Notes:

This position is covered by the Washington Federation of State Employees (WFSE). Once the listed position(s) is(are) filled this recruitment announcement may also be used to fill additional position(s) for up to sixty (60) days.

Prior to a new hire a background check including criminal record history will be conducted. Information from the background check will not necessarily preclude employment.

HCA is an equal opportunity employer. We value the importance of creating an environment in which all employees can feel respected included and empowered to bring unique ideas to the agency. HCA has five employee resource groups (ERGs). ERGs are voluntary employee-led groups whose aim is to foster a diverse inclusive workplace aligned with HCAs mission.Our diversity and inclusion efforts include embracing different cultures backgrounds and viewpoints while fostering growth and advancement in the workplace. Studies have shown women racial and ethnic minorities and persons of disability are less likely to apply for jobs unless they feel they meet every qualification as described in a job description. Persons over 40 years of age disabled and Vietnam era veterans as well as people of all sexual orientations and gender identities are also encouraged to apply. If you have any questions about the required qualifications or how your experience relates to them please contact us at . Persons with disabilities needing assistance in the application process or those needing this job announcement in an alternative format may contact Jake Nelko at or 360.725.0945.

The Washington State Health Care Authority (HCA) is an E-Verify employer. All applicants with a legal right to work in the United States are encouraged to apply.

E-Verify is a registered trademark of the U.S. Department of Homeland Security.

Subscribe to our weekly newsletter to receive a list of new job postings at HCA.