Data Analyst

California Mental Health Services Authority (CalMHSA) is seeking a Data Analyst to manage the full lifecycle of data analysis using electronic health records and other data sources. The role develops dashboards, queries, visualizations, reports, benchmarks, and data pipelines while supporting data quality, validation, and migration initiatives.

What you'll do:

• Develop, maintain and monitor dashboards in partnership with internal and external users focused on diverse uses such policy assessment and implementation, quality improvement, service insights, and fiscal management
• Work with clinical and non-clinical users to understand reporting needs, which products best meet these needs, and consider the end user in produce development
• Develop and maintain standardized data queries and data visualizations to share insights with internal and external partners, including continuously monitoring and integrating user feedback into these queries and visualizations
• Execute, support, and maintain data extraction, data transformation, and data loading into data visualization products
• Prepare reports and visualizations for various stakeholders to help them understand data insights and make informed decisions based on facts and trends
• Develop benchmarks for county plans to evaluate expected behavior for internal and external measures in data visualizations
• Strengthen the organization's data monitoring and validation processes to ensure data quality and completeness
• Maintain a shared library of reusable assets created during work, making them a resource to the wider team
• Support CalMHSA's exploration of migrating data queries, reports, and pipelines to platforms such as Databricks
• Perform other duties as assigned
• This position will have access to various applications that house confidential information, including county records, employee demographic and private behavioral health information; ensure that access is used responsibly, maintaining the integrity and security of systems while preventing accidental or malicious misuse

What they're looking for:

• Requires a bachelor's degree in healthcare, data science, computer science and/or a related field, a minimum of one year of qualifying Healthcare Dashboard Visualization/Data Informatics/Analytics experience, or an acceptable equivalent combination of education and experience
• Ability to use dashboarding tools, such as PowerBI, to create visualizations that provide key insights
• Ability to interpret data, analyze results using statistical techniques and coding languages, and provide ongoing reports
• Experience developing data analysis visualizations and supporting data linkages to produce those visualizations
• Ability to identify, analyze, and interpret trends or patterns in data sets
• Ability to identify potential use cases for data products and key insights that data visualizations may provide to users
• Experience with data modeling and database development and management
• Ability to multi-task, to prioritize work, to take initiative, to meet deadlines of assignments, to be flexible and adaptable and to work well under pressure when faced with fluctuating workloads, pressures of deadlines and competing demands
• Able to act with a high degree of emotional intelligence
• Strong communication and management skills
• Ability to identify confidential and sensitive information and handle with tact and discretion
• Knowledge of graphic and visualization tools, with intermediate to advanced proficiency with MS Power BI and ArcGIS Pro preferred