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 systems related to the collection, monitoring, and auditing of data to ensure data integrity and facilitate analyses and reporting
- Consults with Vanier staff, managers, and working groups regarding data reporting requirements, including confirming project requirements by studying user needs and conferring with internal stakeholders
- Consults with London-Middlesex, Oxford-Elgin service area communities of practice, as appropriate; confirms project requirements by studying user requirements and conferring with group members
- Obtains meaningful data, conducts statistical analyses, and interprets quality improvement and performance measurement indicators
- Provides data and other support to external researchers
- Assists in supporting other agencies within the London-Middlesex, Oxford Elgin service area regarding data management, especially with respect to mandatory service statistics and performance measurement reporting
- Assists in setting performance measurement targets at multiple levels (e.g., program, team, agency, and service area)
- Assists in preparing performance indicator reports for internal and external stakeholders, including staff, managers, executives, the Board, and funders
- Participates in or attends meetings of other agency committees, as appropriate
- Maintains the confidentiality and security of client-related and agency information
- Maintains up-to-date technical knowledge through a variety of means, such as attending educational workshops, reading publications, establishing personal networks, and participating in technical societies
- Complies with the Occupational Health and Safety Act
- Other duties as assigned
Education/Training/Experience:
- Post-secondary education in Data Analytics, Computer Science, Statistics, Business Analytics or a related field (required)
- Master's level (preferred)
- SQL programming and database administration
- One to two years of experience in the data analysis field (preferred)
- Familiarity with the children’s mental health sector (preferred)
- One year is required to learn the full reporting cycles for various stakeholders
- Demonstrated proficiency in Microsoft Office Suite (Word, PowerPoint, Outlook) and statistical analysis software
- Advanced skills in Excel
- Advanced skills in SQL coding
- Advanced skills in data visualization and statistical analysis
- Working knowledge of performance measurement, program evaluation, and research methods
- Current driver’s license (mandatory)
- Responsible for upholding ethical and professional standards
- Errors in data entry, analysis, or interpretation, or in the communication of findings, may result in inappropriate changes in direction or policy
- Works independently with direction from the Lead Agency Supervisor, Quality Manager, and the Director of Quality, Data Strategy and Analytics
- Most deliverables are subject to review by the Lead Agency Supervisor, with approval by the reporting Director
Job Location:
Job Type:
Hours of Work
- Monday to Friday 35-hour work week
Benefits:
- Healthcare of Ontario Pension Plan (HOOPP)
- Extended health care
- Dental Plan
- Vision Care
- Disability & Life insurance
- Employee & family assistance program
- 4 Weeks' Vacation
- Statutory Holidays including a float stat day
- Free on-site parking
Please note that Vanier does not use Artificial Intelligence to screen, assess or select applicants.
Existing Vacancy
Vanier is committed to building a diverse workforce reflective of Canadian society. As a result, it promotes employment equity and encourages women, 2SLGBTQI+, Indigenous persons, persons with a disability and members of visible minority groups to apply.
Vanier is committed to developing inclusive, barrier-free selection and appointment processes and work environments. If contacted in relation to this process, please advise the organization's representative of your need for accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner. Vanier is committed to taking every reasonable precaution to protect employees, our clients/families and the healthcare systems in the communities in which we serve.
While we appreciate your interest, only those selected for an interview will be contacted. Any information obtained during the course of recruitment will be used for employment recruitment purposes only, and not for any other purpose.
