POSITION SUMMARY

The Clinical Support System for Serious Mental Illness (CSS-SMI), known as SMI Adviser, is a 5-year initiative funded by SAMHSA. SMI Adviser offers training activities, on-demand consultation, and vetted resources to support delivery of evidence-based practices by frontline clinicians caring for those with serious mental illness (SMI), including major depression, bipolar disorder, and schizophrenia.

The Data Visualization Analyst reports to the SMI Adviser Director and serves as a key technical member of SMI Adviser grant and supports the Division Education’s Chief with special data visualizations initiatives across the division and the APA.  The Data Visualization Analyst designs, builds, and maintains business intelligence reporting solutions which aggregate online user data from, but not limited to, Salesforce, Google Analytics, and APA’s Learning Management System to create near real-time data reports and visualizations which describe user activities across the grant’s various websites.  The Data Visualization Analysts makes data sets useful and meaningful by presenting key information in a variety of ways which is useful and appealing to end users.  Responsibilities include requirements gathering, design, website+app development from the perspective of data collection, deployment and maintenance of business intelligence (BI) solutions and preparing tables + figures for reports and presentations.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Design, organize, and automate data collection around key grant objectives.
• Create and maintain a schema for a central data warehouse that will integrate user data from across project related computer systems.
• Work with web-development/IT team and contractors to design, integrate, test, and deploy mechanism for data collection across project websites.
• Ensure data quality and integrity from reporting system
• Maintain PowerBI dashboard of key grant metrics which summarizes data via interactive tables and visualizations.
• Design, code, test, and document a BI/Reporting systems, applications, and programs.
• Coordinate with APA’s IT department to develop the semantic layer, metadata, reports, and report definitions.
• Extract insights from data for stakeholder reporting.
• Develop Data Analysis Summaries for reports and presentations. (Methods, benefits, problems)
• Develop and deploy reports, dashboards and other output from BI and transactional systems.
• Prepare analog data tables and graphs for inclusion in stakeholder reports and presentations.
• Publish key data visualizations and explanatory descriptions to project websites.
• Other duties as assigned.