It Data Management – Journey, It Data Analyst (Itdm-J/Cqct)

• Perform code review and peer review for other team members as part of the established Quality Assurance process.
• Conduct analysis on potential issues discovered by the Data Warehouse users and determine if a problem exists.
• Using SQL code, build scripts to test the defects fixed for each scheduled ProviderOne code release.
• 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 enhance business reports/dashboards using SQL Server Reporting Services (SSRS) and Tableau.
• 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.
• Works with project manager, business owner, business analyst and clients for gathering and documenting report or data pull requirements.
• Design, develop and maintain interfaces using SQL Server Integration Services (SSIS)
• Work with business users and stakeholders to research and analyze data needs and able to translate business questions/needs into requirements.
• 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.
• 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).
• Manage job tickets using Online Ticketing Repository System (OTRS), JIRA, Clear Quest, Smarter Track, ServiceNow and other ticketing systems.
• Works with vendors through daily or weekly meetings, frequent e-mail and help desk tickets, to solve complex system issues and problems.
• 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.

• 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 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 in interface development using SQL Server Integration Services (SSIS) or equivalent software.
• Two (2) years of experience working with a large data warehouse.
• Two (2) years of experience utilizing testing methodologies.

• Experience with any helpdesk ticketing system.
• Experience with the ProviderOne On-line system and data warehouses.
• Experience in creating reports using Tableau or similar BI tool software.

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:

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

• 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.

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