If you are interested in applying for the Article 4.3 transfer and would like to review the position description prior to applying, please send a request via e-mail to April Yancey at firstname.lastname@example.org
Within the Washington State Health Care Authority (HCA) this professional position is the highest level authority for ensureing the quality of the data stored in the ProviderOne data warehouses. ProviderOne is a HCA mission-critical system that processes/pays claims in excess of $5 billion annually to providers of services to approximately 1.2 million Medicaid clients statewide. The ProviderOne data warehousing environment is one of the largest and most complex in Washington State government with over 10 terabytes of business data and growing. This position provides technical and strategic direction for ProviderOne data warehouse data quality and supports HCA operations and strategic initatives with timely and relevant data to support the decision-making process.
Primary objectives of the position include design and implementation of agency-wide data quality capabilities/framework to ensure the integrity and usefulness of the ProviderOne Data Warehouse data platforms. Responsible for providing strategic ETL and data integrity testing to verify the integrity of data which resides in the ProviderOne Operational Data Store (ODS) and ProviderOne Ad-hoc Data Warehouse (ADW). Both ODS and ADW must accurately reflect the contents of the ProviderOne On-line Transaction Processing (OLTP) environment. This position will ensure that all three environments (OLTP, ODS, and ADW) are kept in sync, as data patches, data conversion corrections and weekly ETL and interface records are applied. This position establishes agency wide metadata standards to ensure consistent and accurate information is available to internal and external users.
This position provides expert level data analysis and reporting, using SQL, PL/SQL and other Business Intelligence and reporting tools.
The ODS and ADW are used throughout HCA, as well as at OFM and at the Caseload Forecasting Council, for pulling data to use in Federal reporting, for budget management, for program management, for auditing, etc. Managing this data warehouse solution is entirely new work for the state and is being managed by the Business Intelligence Services (BIS) unit within OMSD.
Centrally managing the metadata and data dictionary definitions for ProviderOne data is a fundamental Data Warehouse requirement. Additional data elements will be added as Phase 2 of the ProviderOne project progresses and with ICD-10 and other large projects or mandates. This position is the agency-wide technical lead for ensuring the integrity of these definitions – not only for the data elements, but also for agency-wide standard definitions of derived values. This position provides leadership, technical expertise and mentoring to data analysts and data warehouse super users in all HCA divisions and across other state agencies.
The position also is responsible for extensive communications and coordination with all HCA vendors as it relates to the data warehouses on a daily basis. The position also serves as the technical liaison for business staff, management, and both internal and external stakeholders.
This recruitment is open for internal transfer ONLY in accordance with WFSE CBA Article 4.3, and will be awarded in order of seniority among those who submit a request for transfer.
An employee's transfer request will be granted to another position within the bargaining unit provided:
1. The employee holds permanent status in the job classification;
2. The employee has demonstrated or been assessed to have the position specific skills, abilities, and qualifications necessary to perform the duties of the position;
3. There are no disciplinary action(s) in his/her personnel file for the past twelve (12) months;
4. There is no pending disciplinary action or the employee is not under investigation into alleged misconduct;
5. The employee has not been granted previous internal movement within the past two (2) years;
6. There are no performance issues being addressed, as documented in the employee's supervisory file;
7. The appointment will not create a violation of Agency policy;
8. It meets the needs of the work unit.
The Appointing Authority may consider other requests for transfer, demotion, or requests for reassignment, consistent with the provisions of Article 4.2, Article 42.9, and Article 42.10 in the event there are no employees requesting internal movement within the same class (Article 4.3). To be considered, for an employee initiated transfer, you must:
1. Hold permanent status in a position with the same or higher salary range maximum;
2. Submit a detailed profile or attach a resume through www.careers.wa.gov prior to the closing date.
Note, per the CBA:
1. If you request a transfer under Article 4.3 and you refuse the offer, you cannot request another Article 4.3 transfer for 12 months.
2. If you have accepted a transfer under Article 4.3, you are not eligible to request another transfer under article for 24 months.
To Apply for the Internal Transfer:
Please apply through www.careers.wa.gov . You must include a detailed profile or attach a resume that demonstrates how you meet the skills and abilities for the position being sought.
Whether it's helping a vulnerable child, making highways safer or restoring salmon habitat, the work that we do matters to the people of...