#1147 Report Automation and Systems Analyst - Full Time
Apply NowCompany: York Region Children's Aid Society
Location: Newmarket, ON L3X 1Z9
Description:
April 3, 2025
Job Posting #1147 #hp
Report Automation & Systems Analyst
Permanent 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 Report Automation and Systems 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 the Quality Improvement Specialist, the Report Automation and Research Analyst is responsible for analyzing and designing solutions to automate processes, enhance efficiency and accuracy, and resolve related technical issues.
NATURE OF POSITION:
QUALIFICATIONS
Education and Experience
Knowledge and Skills
PAY GRADE: Non-Union Pay Grade 5 ($75,669.21 - $95,756.65)
HOURS OF WORK 33.75 hours per week
Candidates who meet the qualifications are welcome to apply no later than April 14, 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!
Job Posting #1147 #hp
Report Automation & Systems Analyst
Permanent 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 Report Automation and Systems Analyst to support our Equity, Innovation and Community Engagement Department.
Why Work for Us?
SUMMARY OF DUTIES & RESPONSIBILITIES:
Reporting to the Quality Improvement Specialist, the Report Automation and Research Analyst is responsible for analyzing and designing solutions to automate processes, enhance efficiency and accuracy, and resolve related technical issues.
NATURE OF POSITION:
- Provide insight on data integrity in supported systems
- Deliver insights through Power BI Dashboards - Create clean, user-friendly dashboards that can communicate advanced insights in simple and understandable ways
- Analyze case trend through time series forecasting using various statistical techniques and modeling
- Create and implement data collection tools, mechanisms, and databases by leveraging new software
- Manipulate data and create data sets to develop reports and dashboards that meet the goals of the Agency and its stakeholders
- Support Service Excellence team in Data Quality improvement Projects to create organizational efficiencies and improvements
- Assist in the development of methodologies for program review, evaluation, and outcome measurement, as well as stakeholder feedback initiatives
- Support and contribute to the improvement of analysis and reporting systems for findings of quality assurance activities and mandatory quality and compliance related activities
- Provide insight on data integrity in supported systems
- Develop and train staff using data visualization tools
- Maintaining data documentation and definitions
- Serve as a resource to projects, committees, and Agency initiatives as applicable
- Participate in committees and provincial and community working groups as applicable
- Experience working with very large data sets, able to manipulate, extract, and analyze data
- Serve as a resource to projects, committees, and Agency initiatives as applicable
- Other duties as assigned
QUALIFICATIONS
Education and Experience
- Diploma in Data Analytics, Business Intelligence, Data Visualization, Applied Statistics, Data Science or a related field
- Minimum of 2-4 years of progressive work experience in the field of Power BI development, SQL programming, reporting, analytics experience, AI, Power Apps, Cloud, Web developer and data analytics experience
- Strong working knowledge of MS Excel
Knowledge and Skills
- Experience working with a Business Intelligence (BI) tool: Power BI/Fabric or Tableau, Databricks, Cognos
- Power BI tools - Power Query, Advance Query Editor, Power BI Desktop, Power BI Service
- Strong SQL skills; write complex SQL queries, functions, triggers, stored procedures
- Experience with Microsoft Power Platforms and Microsoft SQL Server
- Experience calculating columns and calculating measures using DAX and data modeling
- Comfortable with Microsoft Power Platforms - Create Data and Model Driven Apps
- Experienced using Structured Query Language (SQL)- Comfortable working in a relational database, querying, cleaning, and creating stored procedures and data sets
- Skilled in the areas of Data warehousing, Business Intelligence, and data analytics
PAY GRADE: Non-Union Pay Grade 5 ($75,669.21 - $95,756.65)
HOURS OF WORK 33.75 hours per week
Candidates who meet the qualifications are welcome to apply no later than April 14, 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!