Entry Level Excel Data Analyst Jobs in California

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.
• Support CalMHSA's exploration of migrating data queries, reports, and pipelines to platforms such as Databricks.
• Perform other duties as assigned.

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 –

EDUCATION and/or EXPERIENCE 

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. Masters-level training preferred, but not required.

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. 

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

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 or Python, and SQL preferred.  Databricks experience highly preferred.

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.