Data Engineer, Mental Health and Substance Use Disorder (ITDM-J/ETS)

Description

Data Engineer, Mental Health and Substance Use Disorder (ITDM-J/ETS)

71082791

This data engineer will maintain pipeline for behavioral health data extracted from multiple sources provided to Health Care Authority business partners. The pipeline is in the process of being modernized from SSIS to dbt, so the successful candidate will demonstrate an interest and ability in learning new technologies while navigating ambiguity. If you have an exploratory nature and experience with modernization solutions, this may be the opportunity 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:

Within the Enterprise Technology Services (ETS) Division, the Office of Enterprise Data Delivery (EDD) has responsibility for the development and operation of an enterprise-wide data infrastructure, ensuring quality data, enabling analytics, and supporting reporting processes. The Agency's Enterprise Data Analytics infrastructure, also known as the Enterprise Data Platform (EDP), is multiple mission critical systems that operate together as the core of HCA's data and analytics suite. The EDP is built within Amazon Web Services (AWS), and includes operational databases, a data lake, Enterprise Data Warehouse (EDW), extract transform load (ETL) tools, enterprise data visualization tools, and metadata management tools.

About the position:

This position is funded by grants for Mental Health and Substance Use Disorder (MH&SUD) programs, and, accordingly, this position prioritizes work on data products that are used by program staff to ensure compliance of external organizations with contractual obligations related to MH&SUD. This position serves as a data engineer supporting the pipeline from the Behavioral Health Data Consolidation (BHDC) operational database to end-user data products.

As a technical expert supporting both data pipelines, and user-facing data products, this position requires a strong understanding of database development, expertise on data transformations, and a strong grasp on business intelligence tools.

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. This position reports to Olympia, WA. Frequency of onsite work will vary based on business and operational needs. HCA has currently suspended the ability to support out-of-state telework.

Duties

Some of what you will do:

• Develop data transformation pipelines for MH&SUD data products which support end user reporting and analysis.
• Independently design, develop, and document ETL data workflows and code for new data integrations and maintain/enhance existing workflows and code.
• Create ETL data landing and staging structures as well as source to target mapping documents.
• Support complex reporting, data visualizations, and Business Intelligence solutions by ensuring interoperability between systems.
• Utilize report tools to develop user-friendly reports that provide value in making day-to-day business decisions.
• Maintain and follow coding standards, best practices and policies in relation to database development, release management, access security, audit, and source code control systems.
• Collaborate with Division of Behavioral Health and Recovery (DBHR) and broader EDD team to design data models and processes for MH&SUD management.
• Research, analyze, propose, design, and deliver database systems that are appropriate for the agency’s business and technology strategies.

Qualifications

Required qualifications:

Qualifying candidates will satisfy all of the following criteria:

• Three (3) years of experience with developing data pipelines from multiple data sources in different formats.
• Three (3) years of experience writing queries and performance tuning using SQL.
• One (1) year of experience with Object Oriented Programming or script development. May include experience with programming languages such as C#, Java, C++ etc. or scripting languages such as python, JSON, PowerShell, and Unix shell scripts.
• One (1) year of experience with version control systems (VCS) such as Git.

Qualifying candidates will meet one of the following criteria options:

Option 1:

• Seven (7) years of professional information technology experience in IT programming, data integration, database administration, and analytic experience with large, complex administrative databases.

Option 2:

• Associate degree, including significant coursework on IT, computer science, or data science, and
• Five (5) years of professional information technology experience in IT programming, data integration, database administration and analytic experience with large, complex administrative databases.

Option 3:

• Bachelor’s degree, including significant coursework on IT, computer science, or data science, and
• Three (3) years of professional information technology experience in IT programming, data integration, database administration and analytic experience with large, complex administrative databases.

Option 4:

• Three (3) years of experience as an Entry level technician in IT Data Management in state service.

Preferred qualifications:

Professional experience with:

• dbt
• Git
• Health care claims processing data
• Behavioral health data
• SSIS
• Python
• Snowflake (SQL)
• AWS

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 in separate files:

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

Subscribe to our weekly newsletter to receive a list of new job postings at HCA.