Data Analyst 2

at  Mental Health Office of

MINIMUM QUALIFICATIONS

Candidates must have one year of permanent service as a Data Analyst 1 OR bachelor’s degree and three years of experience* in data visualization, and statistical models and data mining tools.
A master’s degree in data or computer science, informatics, economics, statistics, mathematics, or a related field, may substitute for one year of the specialized experience. A Ph.D. in the above fields may substitute for two years of the specialized experience

The incumbent will lead planning, execution, and management of data ecosystem and lifecycle activities to support forensic operational needs. Specific duties to be performed may include, but are not limited to, the following:

• Utilize knowledge of SQL, coding, and relational database design to develop and maintain practices for manipulating, cleaning, and combining data from various disparate data sources (flat files, databases, etc.)
• Develop Use Cases, assess data structures, and build database tables for forensic applications.
• Assess the content and quality of data and data systems to ensure that they support the analytic needs of the forensic facilities and DFS.
• Investigate data discrepancies for patterns and root cause.
• Research, recommend, and develop adjustments to data systems to support streamlining, automation, and efficiency.
• Develop and maintain data visualizations, dashboards, and reports (using Tableau and Power BI) to communicate key findings and insights to forensic stakeholders and ensure policy and program decisions are made based on accurate information.
• Participate in quality improvement initiatives to enhance data collection methods, analysis techniques, and reporting practices.
• Monitor and evaluate changes in program performance data, identifying differences and proposing solutions for corrective actions.
• Assist with various data governance and documentation activities such as creating program specifications, workflow diagrams or structured charts, and logical data models.
• Prepare comprehensive written reports containing analysis and interpretation of forensic data for internal and external use.
• Lead in the design and operationalization of low-code data driven applications for data collection and distribution. (e.g., Sharepoint, Teams, Power Automate, REDCap) to support program needs.
• Maintain a collaborative environment that fosters and supports creative solutions and continuous improvement.