King County's Department of Community and Human Services (DCHS) needs to support the King County Integrated Care Network (KCICN) by developing sophisticated tracking measures and dashboards, managing administrative databases, creating analytic tools, conducting advanced quantitative analyses, and preparing reports to inform the operation of the behavioral healthcare system in King County. The goal is to provide insights for data-informed program and policy decisions and test innovative approaches to tackle system, policy, and service delivery challenges.
Requirements
- Extensive expertise working with large SQL databases and writing queries using Structured Query Language (SQL). Including experience in extracting, matching, cleaning, managing, and validating data.
- Skills with data management, analysis, and visualization tools, such as SQL, R, SAS, Python, and Tableau.
- Demonstrated experience conducting statistical analyses and preparing dashboards, reports, and presentations for non-technical audiences.
- Expert skills in SQL and R, including developing tools and packages.
- Experience working with version control systems, preferably Git/GitHub.
- Understanding of health and behavioral health measurement and management processes, indicators, and tools.
- Experience utilizing, managing, and analyzing data from large administrative healthcare databases.
Responsibilities
- Perform queries in Structured Query Language (SQL) to extract, clean, and transform data from large, complex administrative databases to make tables for use in the production of performance measures, dashboards, and reports.
- Develop standardized and streamlined processes using R and Git for producing performance metrics on Tableau dashboards that can be replicated across BHRD bodies of work.
- Perform complex data analyses, analyze trends, and construct key performance measures to inform King County staff on behavioral health program and service implementation and utilization.
- Lead work with internal and external partners to design, create, and maintain production of key performance indicators, reports, dashboards, and trend analyses to improve the performance of King County's behavioral health systems.
- Develop tools to streamline key performance indicators and automation techniques to highlight actual performance change and identify any data system changes or data quality issues.
- Work independently to manipulate, analyze, and interpret data using appropriate statistical methods and data manipulation tools.
- Develop and maintain interactive dashboards, charts, reports, and presentations that visually represent key findings for non-technical audiences, communicating results in a way that is actionable.
Other
- 3 or more years of demonstrated relevant work experience, or an equivalent combination of education and work experience in finance, social sciences, statistics, public health, behavioral health, or a related field with coursework in research methods and statistics, and/or equivalent education and experience.
- Knowledge of equity and social justice principles and practices; lived experience with and/or understanding of the effect of place-, race- and policy & systems inequities on communities and populations.
- Ability to develop a strong understanding of the key business processes, financial drivers, and programmatic features reflected in the administrative data.
- Experience working with medical or behavioral health claims or encounter data.
- Superb attention to detail.
