The CalMHSA Way: 

• Curiosity
• Innovation
• Grounded in Mission
• Ownership
• Clarity

SUMMARY: The Data Analyst is a full-time staff position within California Mental Health Services Authority (CalMHSA) and is responsible for the entire lifecycle of data analysis – including validating and visualizing data from electronic health records and other sources. This role requires expertise in the technical and functional aspects of data analysis and interpretation. The Data Analyst will enhance existing and develop new analysis and reporting capabilities while monitoring performance and quality of analytic products to identify opportunities for improvement.

DUTIES AND RESPONSIBILITIES include but are not limited to:

• 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.
• Perform other duties as assigned, demonstrating flexibility and commitment to organizational success.

BACKGROUND CHECK ELIGIBLE DUTIES
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.

QUALIFICATIONS –

An acceptable equivalent combination of education, experience, and skill will be considered. 

EDUCATION 

Bachelor’s degree in healthcare, data science, computer science and/or a related field.

EXPERIENCE 

One year of qualifying Healthcare Dashboard Visualization/Data Informatics/Analytics experience:

• Experience developing data analysis visualizations and supporting data linkages to produce those visualizations. 
• Experience with data modeling and database development and management

To perform this job successfully, an individual must be able to perform each essential function satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. 

JOB-SPECIFIC KNOWLEDGE & SKILLS

• Demonstrate the ability to use dashboarding tools, such as PowerBI, to create visualizations that provide key insights.
• Demonstrate the ability to interpret data, analyze results using statistical techniques and coding languages, and provide ongoing reports. 
• Demonstrate the ability to identify, analyze, and interpret trends or patterns in data sets.
• Demonstrate the ability to identify potential use cases for data products and key insights that data visualizations may provide to users.
• Demonstrate the ability to identify confidential and sensitive information and handle with tact and discretion.

COMMUNICATION, COLLABORATION, & TIME MANAGEMENT

• Exceptional written and verbal communication skills with demonstrated passion for documentation and knowledge organization 
• Comfortable asking fundamental questions and surfacing basic assumptions that others may consider "obvious" or unnecessary 
• Demonstrate the ability to operate with high autonomy while maintaining accountability to leadership.
• Demonstrate the ability 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. 

PROBLEM SOLVING

• Critical thinking, problem-solving, and a strategic mindset, with the ability to think ahead and initiate proactive solutions.
• Strong attention to detail, with a focus on operational excellence and efficiency.

PERSONAL ATTRIBUTES

• Curious, tech-savvy, and adaptable, with a growth mindset and enthusiasm for learning.
• Detail-oriented and organized, with a strong commitment to code quality and best practices.
• Demonstrates initiative, independence, and resourcefulness in completing assignments.
• Comfortable working in dynamic settings, including both remote environments.
• Able to adhere to a structured work schedule as set by the department supervisor, attend virtual meetings on time, and consistently report on work productivity.

COMPUTER SKILLS – Knowledge of graphic and visualization tools, with intermediate to advanced proficiency with MS Power BI and ArcGIS Pro preferred. Experience with data automation, analysis and visualization tools, with intermediate to advanced proficiency with Excel, R, and SQL preferred. Demonstrated experience with Data Bricks a plus.

LANGUAGE SKILLS and MATHEMATICAL SKILLS - Demonstrate the ability to read, comprehend, and respond appropriately through written or verbal form; demonstrate tactfulness when communicating including internal communication with staff members of all levels; ability to communicate with a variety of audiences effectively. 

REASONING – Demonstrate the ability to effectively apply common sense and follow through to daily tasks; demonstrate the ability to work with little or no supervision; demonstrate excellent analytical skills; demonstrate the ability to efficiently conduct research and ask appropriate probing questions to complete necessary tasks.

PHYSICAL DEMANDS - The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is frequently required to sit and stand; use phone and headset; use hands, arms, fingers to type; answer phones; write; use calculator; demonstrate strength to lift and carry materials weighing up to 10 pounds; demonstrate clear vision to read printed materials and a computer screen; hearing and speech to communicate in person and over the telephone; and drive a motor vehicle on public roads and highways.

SENSORY DEMANDS - The incumbent must spend long hours in intense concentration. The incumbent must also spend long hours on the computer entering information which requires attention to detail and high levels of accuracy.

MENTAL DEMANDS - There are a number of deadlines associated with this position, which may cause significant pressure. The incumbent must also deal with a wide variety of people on various issues.

REGULAR WORK SCHEDULE – May vary depending on business needs; however, CalMHSA standard business hours are 8:00am to 5:00pm, Monday – Friday.