Business Analyst - Full Time #1136

February 13, 2025 #hp Job Posting #1136 #hp 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!