IT Data Management – Senior/Specialist (ITDMSS/ETS)

This recruitment is posted continuously. Application review will begin on January 21st, 2025, and you are encouraged to submit your application materials as soon as possible. The hiring manager reserves the right to close the posting at any time once a selection has been made.  

 
This position performs senior-level development functions including building out ETL processes, migrating large amounts of data, building out custom applications, and running reports. Technology used in these processes include Snowflake, AWS, .NET, Visual Studio, SQL, Power BI, and Edifecs. The ideal candidate will bring experience with large data projects, health data, cloud computing, and integration. If you are excited to bring data management skills to a position managing important projects that affect Washingtonians, 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 Enterprise Technology Services (ETS) division is the agency’s designated technology provider for the Health Care Authority (HCA). Integration Development Services (IDS) is the core work unit within ETS that delivers innovative and professional Information Technology (IT) software and integration solutions that support the mission of HCA divisions and business groups. IDS leverages employee expertise in software design and architecture as well as integration of IT resources to engineer high-quality, cost-effective solutions in partnership with business and project stakeholders.
 
About the position:
This position serves as an advanced technical expert for cross functional database and (full stack) .NET application development for support of Mental Health and Substance Use Disorder solutions. As an advanced technical specialist for custom application development, this position performs all front-end, middle-tier, and back-end development activities, and provides technical expertise for application programmers responsible for all aspects of the software development lifecycle, resulting in database software solutions supporting a broad organizational scope, with focus on production deployment of systems.
 
This position also supports efforts related to Data Integration/Pre-Arrest Diversion Platform/Behavioral Health Services Mapping, associated with 2E2SSB 5536. This bill states that HCA must develop a data integration platform to serve as a common database for diversion efforts across the state, to serve as a data collection and management tool for practitioners, and to assist in standardizing definitions and practices.
 
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. 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.Some of what you will do:

• Performs all database development-related activities including design, normalization, development, implementation, and maintenance of databases and data warehouses; data reporting using SQL Server Reporting Services (SSRS); and Extract-Transform-Load (ETL) processes using SQL Server Integration Services (SSIS).
• Responsibility includes all aspects of database development lifecycle (DBLC), resulting in database solutions that support a broad organizational scope with focus on development and deployment of systems supporting agency IT business solutions, mission-critical database functions, legal or financial time-sensitive customer and public support functions, and high-impact systems that span various applications that serve Medicaid providers.
• Uses object-oriented programming languages, web services, client and server application development processes, and internet technologies to construct new software systems.
• Works with database designers, IT and data governance, program managers, and data reporting staff to map out processes that best support the needs of various HCA programs.
• Defines how the data that is collected and validated will be stored, consumed, and managed by different databases and IT systems.
• Assists the enterprise architecture team in developing any necessary enterprise technology, strategic initiatives, business or data models, principles, policies, or standards.
• Ensures that appropriate/applicable laws, policies, and security requirements are met.
• Defines areas of improvement in the use of products as well as business processes that could leverage solutions.
• Defines data quality controls in conjunction with the program managers and the data architect.
• Designs, develops, tests, implements, and modifies/maintains the database and model-driven application architecture solutions for high-risk, high-visibility multi-dimensional web-enabled information systems built with Microsoft C#, ASP.NET, MVC, Razor, Webforms, Entity Framework, LINQ, JavaScript/jQuery, Bootstrap, Microsoft SQL Server RDBMS, Transact-SQL, SQL Server Integration Services, SQL Server Reporting Services, Power BI, Snowflake, and WCF or SOAP web service technologies.

Required qualifications:
 
Qualifying candidates will satisfy one of the following criteria options:

Option 1:

• Twelve (12) years of increasingly more complex information technology experience such as consulting, analyzing, designing, programming, installing and/or maintaining computer software applications, hardware, or network infrastructure equipment; directing projects; providing customer or technical support in information technology; or administering or supervising staff who performed work in any of these information technology disciplines 

Option 2:

• Associate degree in computer science or related field and 
• Ten (10) years of increasingly more complex information technology experience such as consulting, analyzing, designing, programming, installing and/or maintaining computer software applications, hardware, or network infrastructure equipment; directing projects; providing customer or technical support in information technology; or administering or supervising staff who performed work in any of these information technology disciplines.

Option 3:

• Bachelor's degree in computer science or related field and 
• Eight (8) years of increasingly more complex information technology experience such as consulting, analyzing, designing, programming, installing and/or maintaining computer software applications, hardware, or network infrastructure equipment; directing projects; providing customer or technical support in information technology; or administering or supervising staff who performed work in any of these information technology disciplines.

Option 4:

• Master’s degree in computer science or related field and 
• Six (6) years of increasingly more complex information technology experience such as consulting, analyzing, designing, programming, installing and/or maintaining computer software applications, hardware, or network infrastructure equipment; directing projects; providing customer or technical support in information technology; or administering or supervising staff who performed work in any of these information technology disciplines.

Option 5:

• Doctoral degree in computer science or related field and 
• Five (5) years of increasingly more complex information technology experience such as consulting, analyzing, designing, programming, installing and/or maintaining computer software applications, hardware, or network infrastructure equipment; directing projects; providing customer or technical support in information technology; or administering or supervising staff who performed work in any of these information technology disciplines.

Option 6:

• Three years as a journey level IT professional in state service.

 
Qualifying candidates will also satisfy all of the following requirements. All required experience may be gained concurrently: 

• Working-level knowledge of serving as a project lead and associated responsibilities.
• Five (5) years of experience with applications development with Microsoft Visual Studio, C# and .NET technologies, including application programming interfaces (APIs), software design patterns, Microsoft SQL Server, including relational database design and modeling, writing TSQL queries, developing Microsoft SQL Reporting Services and Microsoft SQL Integration Services solutions.
• Two (2) years of experience with Software Development Lifecycle Management (SDLC).
• One (1) year of experience in addressing application development security protocols and standards.
• One (1) year of experience being directly involved with Agile / Scrum methodology practices.
   

Preferred qualifications:
 

• Experience with big data and/or healthcare data projects.
• Experience in cloud computing and architecture.
• Experience with Enterprise Data Warehouse technologies or the Snowflake platform.
• Experience with Edifecs and/or BizTalk.
• Experience with healthcare data and including behavioral health data.
• Experience with PL/pgSQL, PostgreSQL technologies and various Amazon Web Service or Azure cloud-based solutions.
• Experience working with data visualization software such as Power BI or Tableau.
• Experience in agile development and/or Dev/Ops methodologies and practices.

 
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.

About HCA: 
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.
  
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:
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 HCA’s 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 HCAjobs@hca.wa.gov. Persons with disabilities needing assistance in the application process, or those needing this job announcement in an alternative format may contact Jake Nelko at jake.nelko@hca.wa.gov 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.
 

Salary : $90,060 - $121,116