Data Analyst Job at State of Washington Health Care Authority
State of Washington Health Care Authority Olympia, WA
$80,064 - $107,676 a year
Description
IT Data Management – Journey, IT Data Analyst (ITDM-J/CQCT)
71028834
Do you have a curious mind about data and data structures? Do you have a passion and curiosity for research and analyzing the bigger picture to see how things work? We are looking for a data developer that has a strong background in building operational reports, health care metrics, and sequel coding who can largely work independently but also as a member of a team that enjoys contributing to larger projects. If this sounds like you, please read on for this opportunity!
About the division:
The
Clinical Quality and Care Transformation (CQCT) division makes clinical policy decisions that guide medical coverage, maintain quality standards, and ensure evidence-based practices for those on whose behalf HCA purchases medical care. The
Chief Data Office (DATA) team is within the Clinical Quality and Care Transformation (CQCT) Division to provide data, analytics, and decision support tools to support HCA’s initiatives and programs. personnel work to provide data management, governance, and data-driven decision support applications to improve decisions about clinical quality and health care purchasing.
About the position:
The IT Data Management- Journey position reports directly to the Medicaid Data Management and Reporting Manager and works alongside a team of skill technical professionals. This position assists the team in reviewing design documents, identifying any potential issues, providing recommendations to implement the best technical solution, and executes ProviderOne release testing as well. The position contributes greatly to the overall data quality and integrity for both ProviderOne data warehouses, which are a critical source for operational, state, and federal reports, financial and clinical modeling, budget forecasting and clinical research. The position also works closely with business and technical staff and management throughout HCA to ensure data quality issues are fixed properly.
This position is eligible to telework and is typically not required to report on-site. Occasional travel may be required for the purpose of meeting with stakeholders or vendors. 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. Frequency of onsite work will vary based on business and operational needs. HCA may choose, but is not required, to support out-of-state telework on a case-by-case basis.
Duties
Some of what you will do:
- Develop SQL to provide reports or data sets for HCA business areas, state agencies, Washington State Institutional Review Board (WSIRB), or Public Disclosure Requests (PDRs).
- Design, develop and enhance business reports/dashboards using SQL Server Reporting Services (SSRS) and Tableau.
- Work with business users and stakeholders to research and analyze data needs and able to translate business questions/needs into requirements.
- Work with clients and end-users to understand, develop, design, build and maintain SSRS reports and Tableau Dashboards to fulfill business requirements.
- Design, develop and maintain interfaces using SQL Server Integration Services (SSIS)
- Identify and analyze potential data quality or other data warehouse related issues, conduct testing and verification of fixes made to the warehouses or the data that they hold. This also includes communication and coordination with the data warehouse vendors.
- Conduct analysis on potential issues discovered by the Data Warehouse users and determine if a problem exists.
- Works with vendors through daily or weekly meetings, frequent e-mail and help desk tickets, to solve complex system issues and problems.
- Using SQL code, build scripts to test the defects fixed for each scheduled ProviderOne code release.
- Works with project manager, business owner, business analyst and clients for gathering and documenting report or data pull requirements.
- Develops detailed report specifications, tests, maintains, and enhances complex analytical and business driven reports or data sets using ProviderOne data, through one or both Data Warehouses.
- Perform code review and peer review for other team members as part of the established Quality Assurance process.
- Coordinate and work with vendors to get issues resolved through established ProviderOne defect resolution process. Also work with appropriate business analyst(s) or HCA business owners to determine resolution of the issue, which could include logging defects or service requests with the vendors.
- Lead the maintenance and development of ProviderOne reports developed by ProviderOne vendors.
- Manage job tickets using Online Ticketing Repository System (OTRS), JIRA, Clear Quest, Smarter Track, ServiceNow and other ticketing systems.
Qualifications
Required qualifications:
A bachelor’s degree or higher in Information Technology, or a closely allied field.
AND
- Three (3) years (full-time equivalent) of professional experience in one or more of the following IT disciplines: consulting, analyzing, designing, programming, installing and/or maintaining computer software applications. A higher degree may substitute for one (1) year (full-time equivalent) of professional experience in one or more of the following IT disciplines: consulting, analyzing, designing, programming, installing and/or maintaining computer software applications.
- Two (2) years of experience working with a large data warehouse.
- Two (2) years of experience writing SQL code, performance tuning.
- Two (2) years of experience developing reports using Microsoft Reporting Services (SSRS) or equivalent software.
- Two (2) years of experience utilizing testing methodologies.
- Two (2) years of experience in interface development using SQL Server Integration Services (SSIS) or equivalent software.
Additional professional experience in one or more of the following IT disciplines: consulting, analyzing, designing, programming, installing and/or maintaining computer software applications may substitute year for year for the required education. Additional advanced education may substitute for one (1) year (full-time equivalent) of professional experience in one or more of the following IT disciplines: consulting, analyzing, designing, programming, installing and/or maintaining computer software applications.
Preferred qualifications:
Experience with the ProviderOne On-line system and data warehouses.- Experience with any helpdesk ticketing system.
- Experience in creating reports using Tableau or similar BI tool software.
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:
- 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 careers.wa.gov.
Supplemental Information
About HCA:
The Washington State Health Care Authority (HCA) is committed to whole-person care, integrating physical health and behavioral health services for better results and healthier residents.
HCA purchases health care for more than 2.5 million Washington residents through Apple Health (Medicaid), the Public Employees Benefits Board (PEBB) Program, and the School Employees Benefits Board (SEBB) Program. As the largest health care purchaser in the state, we lead the effort to transform health care, helping ensure Washington residents have access to better health and better care at a lower cost.
What we have to offer:
The Washington State Health Care Authority (HCA) is committed to whole-person care, integrating physical health and behavioral health services for better results and healthier residents.
HCA purchases health care for more than 2.5 million Washington residents through Apple Health (Medicaid), the Public Employees Benefits Board (PEBB) Program, and the School Employees Benefits Board (SEBB) Program. As the largest health care purchaser in the state, we lead the effort to transform health care, helping ensure Washington residents have access to better health and better care at a lower cost.
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.
- Tuition reimbursement
- And free parking!
Notes:
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. Our diversity and inclusion efforts include embracing different cultures, backgrounds and viewpoints while fostering growth and advancement in the workplace. Women, racial and ethnic minorities, persons of disability, persons over 40 years of age, disabled and Vietnam era veterans, as well as people of all sexual orientations and gender identities are encouraged to apply. Persons with disabilities needing assistance in the application process, or those needing this job announcement in an alternative format may contact Julie Laney at 360.725.5130 or julie.laney@hca.wa.gov.
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.
Please Note :
apexdining.ca is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, apexdining.ca provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.