Vanier Children’s Mental Wellness is proud to be recognized across Southwestern Ontario as a trusted leader in children’s mental health. We are the Lead Agency for Child and Youth Mental Health System planning in our region. We’ve been here for families, for more than 60 years, offering innovative care and support for children and youth who are facing emotional and behavioural challenges.
As a registered charity and not-for-profit organization, we are funded by the Ministry of Health and the Ministry of Children, Community and Social Services. We deliver culturally responsive, accessible mental health services to children, youth, and families while providing system leadership and advocating to improve care in our community.
Summary
The Data Analyst has a key role in ensuring evaluation processes that enhance evidence-based decision-making. The Data Analyst reports to the Lead Agency Manager and supports the Quality and Strategy team in planning, designing, implementing, and maintaining integrated databases, as well as managing data from other agencies within the London-Middlesex, Oxford-Elgin service area.
The Data Analyst provides user-support related to Vanier databases for staff and managers within Vanier, and the Data Analyst consults with other agencies within the London-Middlesex, Oxford-Elgin service area regarding data management. The Data Analyst generates and interprets data reports as needed by stakeholders and trains stakeholders to access and interpret data. The Data Analyst not only extracts data from existing databases but also supports the creation of both ongoing quality improvement tools and project-specific surveys. The Data Analyst has the primary role in data visualization and statistical analysis.
Roles & Responsibilities
- Supports performance measurement by assisting the Lead Agency Manager in planning and designing integrated databases capable of generating performance indicators that draw on all aspects of Vanier operations (including client, human resources, and financial data)
- Assists in planning, designing, and updating databases for service data from multiple agencies in the London-Middlesex, Oxford-Elgin service area
- Codes database metadata (e.g., triggers, stored procedures, functions, and data views) in Structured Query Language (SQL) and creates parameterized data reports for use by end users in Visual Studio
- Supports Vanier Digital service team in maintaining agency databases using SQL Server Management Studio (SSMS)
- Supports Vanier staff and managers in the use of specialized software (e.g., case management software, Amazon Quicksight, BI tools)
- Manages complex datasets, including developing and implementing