Data Analyst

Vanier; London; Hybrid; CAD 55,000 - 85,000; Full time

Job summary

An established industry player in children's mental health is seeking a Data Analyst to enhance evidence-based decision-making. This role involves managing integrated databases, generating insightful reports, and supporting data visualization and statistical analysis. You'll collaborate with various stakeholders, ensuring data integrity and facilitating impactful analyses. With a commitment to improving lives, this position offers a unique opportunity to contribute to meaningful change in the community. Join a forward-thinking organization that values your expertise and supports your professional growth in a hybrid work environment.

Benefits

Healthcare of Ontario Pension Plan (HOOPP)

Extended health care

Disability & Life insurance

Employee assistance program

On-site parking

4 Weeks' Vacation & Stat

Vision care

Qualifications

• Experience in data analysis with a focus on performance measurement.
• Proficient in SQL coding and database administration.

Responsibilities

• Create management reports to inform system decisions.
• Support data integrity and facilitate analyses and reporting.

Skills

SQL programming

Data visualization

Statistical analysis

Microsoft Office Suite

Data integrity management

Lean Six Sigma

Project management

Education

Post-secondary education in computer science

Master's degree

Tools

EMHWare software

SQL Server Management Studio

Visual Studio

Statistical analysis software

Job description

Recognized throughout Southwestern Ontario as a leader in children’s (birth-18 years) mental health, Vanier Children’s Mental Wellness provides innovative treatment programs and services for children, experiencing emotional and behavioural challenges. As a registered charity and not-for-profit agency, Vanier has been in operation for over 54 years and is funded by the Ontario government. Vanier Children's Mental Wellness mission is to improve the lives of infants, children, and their families through the provision of mental health services based on clinical excellence, collaboration, partnerships, and system leadership. Appointed by the Ontario Government as “Lead Agency for Child/Youth Mental Health (CYMH) System Management” in London-Middlesex (2014), Vanier is also accountable for community-wide Child/Youth Mental Health System Planning (MCYS: “Moving on Mental Health”).

Position 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 Supervisor and works to assists 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 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 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.

Job Duties:

• Support and responsible for creation of several management reports including monthly, quarterly, and annual data to inform system decisions
• Supports performance measurement by assisting the Lead Agency Supervisor 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)
• Responsible for completing data presentations within Vanier, and across Lead Agency
• Responsible for pulling data to support board, ministry and Lead Agency requests
• Assists in planning, designing, and updating databases for service data from multiple agencies in the London-Middlesex 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 IT staff 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)
• 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
• Supporting data across Core Service Providers in the CYMH sector within London-Middlesex

Education/Training/Experience:

• Experience with EMHWare software preferred
• Post-secondary education in computer science, statistics, or related field
• Masters level (preferred)
• SQL programming and database administration
• Lean Six Sigma and Project experience
• Proficient in Microsoft Office Suite (Word, PowerPoint, Outlook)
• Experience with statistical analysis software, preferred
• Advanced skills in Excel
• Advanced skills in SQL coding (Microsoft SQL)
• Advanced skills in data visualization and statistical analysis
• One to two years of experience in data analysis field, preferred
• Familiarity with the children’s mental health sector, preferred
• Working knowledge of performance measurement, program evaluation, and research methods
• Current driver’s license preferred
• Police Check is required
• TB Test is required

Hours of work:

• 35 hours a week.
• Required flexibility for occasional evening and Saturday work as required
• Hybrid opportunities available, approval required

License/Certification:

• Driving License (preferred) and access to a reliable vehicle
  
  

Benefits:

• Healthcare of Ontario Pension Plan (HOOPP)
• Extended health care
• Disability & Life insurance
• Employee assistance program
• Life insurance
• On-site parking
• 4 Weeks' Vacation & Stat
• Vision care

Vanier is committed to building a diverse workforce reflective of Canadian society. As a result, it promotes employment equity and encourages women, 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.

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.