IT Data Management - Journey (ITDM-J/SPI)

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 HCA's Enterprise Data Warehouse (EDW). HCA's 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., 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 HCA's 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., We understand that your life revolves around more than just your career. Like everyone, your first priority is ensuring that you and your family will maintain health and financial security. That's why choice is a key component of our benefits package. We have a selection of health and retirement plans, paid leave, staff training and other compensation benefits that you can mix and match to meet your current and future needs.

Read about our benefits: The following information describes typical benefits available for full-time employees who are expected to work more than six months. Actual benefits may vary by appointment type or be prorated for other than full-time work (e.g. part-time); view the job posting for benefits details for job types other than full-time.

Note: If the position offers benefits which differ from the following, the job posting should include the specific benefits.

Insurance Benefits Employees and their families are covered by medical (including vision), dental and basic life insurance. There are multiple medical plans with affordable monthly premiums that offer coverage throughout the state.

Staff are eligible to enroll each year in a medical flexible spending account which enables them to use tax-deferred dollars toward their health care expenses. Employees are also covered by basic life and long-term disability insurance, with the option to purchase additional coverage amounts.

To view premium rates, coverage choice in your area and how to enroll, please visit the Public Employees Benefits Board (PEBB) website. The Washington Wellness program from the Health Care Authority works with PEBB to support our workplace wellness programs.

Dependent care assistance allows the employee to save pre-tax dollars for a child or elder care expenses.

Other insurance coverage for auto, boat, home, and renter insurance is available through payroll deduction.

The Washington State Employee Assistance Program promotes the health and well-being of employees.

Retirement and Deferred Compensation State Employees are members of the Washington Public Employees' Retirement System (PERS). New employees have the option of two employer contributed retirement programs. For additional information, check out the Department of Retirement Systems' web site.

Employees also have the ability to participate in the Deferred Compensation Program (DCP). This is a supplemental retirement savings program (similar to an IRA) that allows you control over the amount of pre-tax salary dollars you defer as well as the flexibility to choose between multiple investment options.

Social Security All state employees are covered by the federal Social Security and Medicare systems. The state and the employee pay an equal amount into the system.

Public Service Loan Forgiveness If you are employed by a government or not-for-profit organization, and meet the qualifying criteria, you may be eligible to receive student loan forgiveness under the Public Service Loan Forgiveness Program.

Holidays Full-time and part-time employees are entitled to paid holidays and one paid personal holiday per calendar year.

Note: Employees who are members of certain Unions may be entitled to additional personal leave day(s), please refer to position specific Collective Bargaining Agreements for more information.

Full-time employees who work full monthly schedules qualify for holiday compensation if they are employed before the holiday and are in pay status for at least 80 nonovertime hours during the month of the holiday; or for the entire work shift preceding the holiday.

Do you have experience in Visio?, Do you have a Master's degree?, 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!, * 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:

• Bachelor's 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:

• Master's 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., * 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., * 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.

$88,332 - $118,800 a year Paid training, Loan forgiveness, Military leave, Health insurance, Retirement plan, Vision insurance, Dental insurance, Paid military leave, Flexible spending account, Bereavement leave, Life insurance, Employee assistance program, Free parking, Disability insurance, Paid holidays, Wellness program, Dependent care reimbursement, Flexible schedule Hybrid work in Olympia, WA, 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 HCA's 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!, Part-time employees who are in pay status during the month of the holiday qualify for the holiday on a pro-rata basis. Compensation for holidays (including personal holiday) will be proportionate to the number of hours in pay status in the month to that required for full-time employment, excluding all holiday hours. Pay status includes hours worked and time on paid leave.

Sick Leave Full-time employees earn eight hours of sick leave per month. Overtime eligible employees who are in pay status for less than 80 hours per month, earn a monthly proportionate to the number of hours in pay status, in the month to that required for full-time employment. Overtime exempt employees who are in pay status for less than 80 hours per month do not earn a monthly accrual of sick leave.

Sick leave accruals for part-time employees will be proportionate to the number of hours in pay status, in the month to that required for full-time employment. Pay status includes hours worked, time on paid leave and paid holiday.

Vacation (Annual Leave) Full-time employees accrue vacation leave at the rates specified in WAC 357-31-165(1) or the applicable collective bargaining agreement (CBA). Full-time employees who are in pay status for less than 80 nonovertime hours in a month do not earn a monthly accrual of vacation leave.

Part-time employees accrue vacation leave hours in accordance with WAC 357-31-165(1) or the applicable collective bargaining agreement (CBA) on a pro rata basis. Vacation leave accrual will be proportionate to the number of hours in pay status, in the month to that required for full-time employment.

Pay status includes hours worked, time on paid leave and paid holiday.

As provided in WAC 357-58-175, an employer may authorize a lump-sum accrual of vacation leave or accelerate the vacation leave accrual rate to support the recruitment and/or retention of a candidate or employee for a Washington Management Service position. Vacation leave accrual rates may only be accelerated using the rates established WAC 357-31-165.

Note: Most agencies follow the civil service rules covering leave and holidays for exempt employees even though there is no requirement for them to do so. However, agencies are required to adhere to the applicable RCWs pertaining holidays and leave.

Military Leave Washington State supports members of the armed forces with 21 days paid military leave per year.

Bereavement Leave Most employees whose family member or household member dies, or for loss of pregnancy, are entitled to five (5) days of paid bereavement leave. In addition, the employer may approve other available leave types for the purpose of bereavement leave.

Additional Leave Leave Sharing Parental Leave Family and Medical Leave Act (FMLA) Leave Without Pay

Functioning as both the state's 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., 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. More than Just a Paycheck! Employee benefits are not just about the kind of services you get, they are also about how much you may have to pay out of pocket. Washington State offers one of the most competitive benefits packages in the nation.