Description

This senior developer performs functions across the software development lifecycle for integrations and migration of behavioral health data with HCA’s enterprise data warehouse. This position will support testing, perform Power BI reporting, and use Edifecs for data mapping and ETL functions. The ideal candidate will bring data management skills to this position performing important work with critical data that helps Washingtonians receiving behavioral health care.

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 Health Care Authority 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 (full stack) .NET application and database 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 will also contribute to designing, implementing, and supporting a series of data collection and validation services. Currently, HCA’s selected vendor to supply these services is Edifecs. This position will be the senior designer and developer of the data collection methods and tools used to provide data to program managers and data analysts at both HCA and potentially other state agencies.

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.

Duties

Some of what you will do:

• Develop, test, and modify/maintain the database and model-driven application architecture solutions for information systems built with Microsoft C#, ASP.NET, MVC, Razor, Webforms, Entity Framework, LINQ, Java Script/j Query, Bootstrap, Microsoft SQL Server RDBMS, Transact-SQL, SQL Server Integration Services, SQL Server Reporting Services, Power BI, Snowflake, and RESTful web service technologies.
• Evaluate software architecture patterns, object-oriented design concepts and abstraction techniques, coding languages, view model technologies, OLTP database modeling and design, query languages, entity modeling, performance tuning, and security best practices and standards.
• Utilize multiple and disparate technology system Application Programming Interfaces (APIs) to perform systems integration for development of end-to-end workflow solutions.
• Design and develop complex software solutions.
• Perform data structuring and data modeling, normalizing data structures, system design and development, data security, and data programming methodologies by applying journey level proficiency and knowledge of Relational Database Management Systems.
• Design and develop Extract, Transform, Load (ETL) technologies.
• Evaluate business problems or goals to architect solutions.
• Utilize Agile process models and continuous integration methodologies.
• As senior developer of data collection and validation solutions, use procured Edifecs Structured Data Capture (SDC) and XEngine (XESaa S) to develop agency data collection and validation solutions.
• Perform requirements gathering, design, architecture and deployment of agency procured Saa S solutions that supports business requirements.
• Develop, track, test, and implement system configurations and functionality.
• Author and maintain technical documentation.
• Apply skills and expertise in programming HTML, CSS, Java Script, j Query, and related frameworks and technologies to support the agency’s enterprise data systems and assets.

Qualifications

Required qualifications:

Qualifying candidates will satisfy one of the following criteria options:

Option 1:

• Master’s degree or equivalent in computer science or related field and
• Six (6) years of progressive professional IT 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:

• Bachelor’s degree or equivalent in computer science or related field and
• Eight (8) years of progressive professional IT 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:

• Associate degree or equivalent in computer science or related field and
• Ten (10) years of progressive professional IT 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:

• Twelve (12) years of progressive professional IT 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:

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

Qualifying candidates will also satisfy all of the following requirements (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 in cloud computing and architecture.
• Experience with PL/pg SQL, Postgre SQL technologies and various Amazon Web Service or cloud-based solutions.
• Experience with enterprise data warehousing and related tools, such as Snowflake.
• Experience with healthcare data and including behavioral health data.
• Experience with other relevant enterprise tools such as Biz Talk and Edifecs.
• Experience designing, developing, testing, implementing, and managing API and integration projects.
• Experience with data ingestion and querying tools like SQL and SSIS.
• Experience with Electronic Data Interchange (EDI) technologies.
• 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.

Supplemental Information

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.

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.

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.

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, are entitled to three (3) 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

Please visit the State HR Website for more detailed information regarding benefits.

Updated 12-31-2022