February 13, 2025

Job Posting

Business Analyst

Full Time

The York Region Children's Aid Society (YRCAS) is a non-profit community organization legally mandated to protect children and youth from abuse and neglect. As a leader within the child welfare sector, we partner with parents, caregivers, and community to provide a safe environment for children and youth, through equitable, culturally aligned services.

Comprised of interdisciplinary teams of diverse professionals who push boundaries in support of family centered care, we engage with children and families for a stronger, healthier community within the York Region.

YRCAS is fully committed to a culture of belonging and an inclusive environment that encourages every team member to lead within their role, generate innovative ideas that reinforce our mission and goal to create a healthy workplace and community where children youth and families thrive.

To support us on our journey, YRCAS is looking for a Business Analyst to support our Equity, Innovation and Community Engagement Department.

Why Work for Us?

Hybrid working model (working virtual and in person)
Casual dress code
Employer paid Group Insurance and Health & Dental Benefit
Four (4) Weeks of Vacation accrued per calendar year
Five (5) float days per calendar year
One day off every three (3) weeks during Winter months
Shortened Summer hours
OMERS Pension, with employer and employee sharing premiums equally
Mileage Reimbursement
Enhanced Wellness Initiatives Virtual Fitness Classes

SUMMARY OF DUTIES & RESPONSIBILITIES

Reporting to Quality Improvement Specialist, the Business Analyst plays a critical role in improving operational efficiency, data management, and service delivery. This role involves analyzing business processes, identifying areas for improvement, and implementing technology-driven solutions to support child welfare programs. The Business Analyst collaborates with both external and internal stakeholders, such as MCCSS, OACAS, caseworkers, program managers, and IT teams, to ensure effective data tracking, compliance, and reporting in alignment with legislative and organizational requirements.

NATURE OF POSITION:

Translate Business Needs

Convert business requirements into technical specifications to guide data analytics and reporting initiatives.
Creates and maintains service data related documentation, technical and functional design documents.

Requirements & Data Modeling

Work with internal and external stakeholders (MCCSS and other agencies) to identify and document requirements for new and existing data analytics, data sets, and reporting projects.
Develop and maintain data models that ensure data is accurate, complete, and consistent.

Dashboard & Report Development

Design, build, test, and maintain Power BI dashboards and reports.
Utilize SQL, Cognos, and other Business Intelligence tools to support robust and efficient reporting solutions.
Identify and bring forward opportunities to QA team to improve the user experience and response times of dashboards and reports.

Research & Analysis

Conduct research on industry best practices related to reporting and analytics.
Analyze large data sets to address business needs and provide actionable insights.
Stay up to date on emerging trends in data analytics and reporting, incorporating new approaches and technologies when beneficial.
Stay up to date on new reporting release by Ministry and OACAS.

Data Quality & Collaboration

Ensure the quality and accuracy of data used in analytics and reporting, identifying and resolving issues as needed.
Collaborate with cross-functional teams to identify and implement process improvements, automation, and innovative solutions that boost efficiency and effectiveness.
Ability to assess, evaluate and interpret information for data quality.

Continuous Improvement

Lead initiatives to enhance reporting processes, focusing on automation, efficiency gains, and standardized workflows. For example, working with internal stakeholders to automate data collection and data analysis.
Promote clarity, data-driven decision-making, and ongoing enhancements to support organizational objectives.

QUALIFICATIONS

Education and Experience

Bachelor's degree in Business Administration, Computer Science or Mathematics
Minimum of 3 years experience in reporting and data analytics in Ontario, preferably in the child welfare sector

Knowledge and Skills

Strong analytical skills, with the ability to work collaboratively in teams and translate business requirements into technical solutions
Demonstrated experience developing and maintaining data models
Demonstrated knowledge of programming language and coding experience
Experience in ETL (extract- transform-load) technology and data Warehousing design strategies
Knowledge and experience with Microsoft ecosystem (e.g. Azure, SSRS, SSAS, SSIS and SQL Server, Office365, Power BI.
Proficiency in IBM Cognos
Proficiency in SQL- Write complex SQL queries, functions, triggers, stored procedures
Proficiency in Microsoft Power BI, DAX, RLS
Proficiency in Microsoft Power Apps- Canvas App and Dataverse App
Strong collaboration skills for cross-functional teamwork
Strong problem-solving abilities, including the capacity to identify issues and implement solutions
Excellent communication skills, capable of effectively conveying complex ideas to both technical and non-technical audiences
Preferred: Child welfare experience

PAY GRADE: Non-Union Pay Grade 6 ($85,455.52 to $108,300.25) under review

HOURS OF WORK 33.75 hours per week

Candidates who meet the qualifications are welcome to apply no later than February 25, 2025 by 11:59PM.

Internal Applicants: Please apply for this opportunity using your Agency ADP account.

External Applicants: Apply here: yorkcas.org/careers

We appreciate all applications received. All communications will be held in strict and professional confidence. Only those candidates selected for an interview will be contacted. We thank all applicants for their submissions.

Employment at York Region Children's Aid Society is conditional upon the verification of credentials, a satisfactory vulnerable sector check, and a class "G" driver's license with daily access to an insured vehicle. York Region Children's Aid Society works in a hybrid virtual and on-site working environment.

Anti-Oppression/Anti-Racism at York Region Children's Aid Society

YRCAS is committed to having a workforce that is reflective of the diversity of York Region and strongly encourages application from all qualified individuals, especially those who can provide different perspectives and contribute to a further diversification of ideas.

Diversity, Equity & Inclusion

York Region Children's Aid Society is committed to employment equity, diversity and inclusion in the workplace, and fostering equity, diversity and inclusion in recruitment practices is a key aspect of the search process. The current posting is in search of candidates who identified from the following equity seeking groups; women, racialized persons/persons of colour, Indigenous Peoples, persons with disabilities, and persons of the 2SLGBTQ+ community. If you are of the aforementioned identities, and feel comfortable making it known, you may choose to self-identify as member of a designated group. Any information directly related to you is kept confidential and used in a safe manner to inform our recruitment process towards being an equal opportunity employer.

Vaccination Policy

York CAS prioritizes the health and safety of their employees and closely follows the Public Health Guidelines and Recommendations. The agency's mandatory COVID-19 vaccination requirement as a condition of employment is currently suspended. Should the mandatory COVID-19 vaccination requirement be reinstated, all active agency employees will be required to comply with YRCAS' Mandatory COVID-19 policy (providing proof of COVID-19 vaccination-2 doses required).

Accommodation at YRCAS

We are committed to a selection process and work environment that is inclusive and barrier free. Accommodation will be provided in accordance with the Ontario Human Rights Code. Applicants that may require accommodation during the selection process are encouraged to notify the Human Resources Department when contacted for an interview.

Human Resources will work together with the hiring committee to arrange reasonable and appropriate accommodation for the selection process, which will enable you to be assessed in a fair and equitable manner.

Children at the heart of all that we do!