Data & Reporting Analyst

Repost Date: July 21, 2026

Closing Date: August 10, 2026

Status: Vacancy

Data & Reporting Analyst

Full-time, Permanent (37.5 hr/wk) | Start Date: ASAP | Location: Waterloo

Salary: $61,500 - $76,600

Why Join KidsAbility?

Every year, more than 17,000 children and youth rely on KidsAbility to support their growth, development, and well-being. Through innovative, family-centred services, we help children and families navigate challenges, celebrate successes, and achieve meaningful goals.

As a non-profit organization serving the Waterloo and Guelph-Wellington regions, we believe that when we work together with compassion, expertise, and purpose, we can make a lasting impact. Join us in helping children, youth, and families discover a future of possibilities.

The impact we make starts with our people. That's why we foster a supportive and purpose-driven workplace where employees can grow, contribute, and thrive. We offer:

• Ongoing professional development, leadership growth, and learning opportunities
• A collaborative and inclusive culture that values diverse perspectives and teamwork
• Opportunities to contribute to innovation, research, and continuous improvement initiatives
• Programs that support employee well-being, connection, and work-life balance
• A comprehensive total rewards package, including extended health and dental benefits, an optional group RRSP, disability income protection, generous vacation entitlements, and paid personal leave

The Opportunity

KidsAbility is seeking a Data & Reporting Analyst to support our growing need for data-driven insights and enhanced business intelligence capabilities. This role is ideal for a data professional who is passionate about transforming data into meaningful stories, building impactful reporting solutions, and helping teams make informed decisions.

Reporting to the Manager of Data & Quality, the Data & Reporting Analyst will design, develop, and maintain reports, dashboards, and analytical tools that support clinical, operational, and strategic decision-making across the organization.

This is an exciting opportunity to contribute to a mission-driven organization while expanding your expertise in business intelligence, data governance, reporting automation, and advanced analytics.

Your Impact

Reporting & Analytics

• Develop, maintain, and enhance dashboards, reports, and visualizations using Power BI, Excel, and other reporting tools.
• Analyze clinical, operational, and organizational data to identify trends, measure performance, and generate actionable insights.
• Conduct ad hoc analyses and present findings through clear, meaningful data stories tailored to both technical and non-technical audiences.
• Automate and optimize recurring reporting processes to improve efficiency and accessibility.

Data Management & Governance

• Support data quality, integrity, and consistency by identifying and resolving reporting and data issues.
• Contribute to the development and maintenance of data definitions, reporting standards, metadata documentation, and a centralized data dictionary.
• Assist in establishing scalable reporting processes and best practices that support organizational data governance.

Collaboration & Stakeholder Support

• Partner with teams across Clinical Services, HR, Finance, and other departments to understand reporting needs and develop effective solutions.
• Translate business requirements into accessible reports and dashboards that support operational and strategic decision-making.
• Support staff in understanding and using data effectively to inform their work and improve outcomes.

Continuous Improvement

• Identify opportunities to enhance reporting capabilities, improve data literacy, and increase organizational access to meaningful insights.
• Champion a data-informed culture by making data approachable, relevant, and actionable across the organization.

Your Experience and Expertise

To be successful in this role, you will have a Bachelor's degree in Computer Science, Statistics, Health Informatics, Data Management, Social Sciences, or a related field. An equivalent combination of education and experience will also be considered.

In addition, you will bring

• 4–6 years of experience in data analytics, reporting, business intelligence, or a related field.
• Advanced proficiency with Power BI, including DAX, and Microsoft Excel, including Pivot Tables and Power Query.
• Strong SQL skills for data extraction, transformation, and reporting.
• Experience working with large and complex datasets, with a focus on data quality, integrity, and accuracy.
• Demonstrated ability to create effective data visualizations and translate complex information into clear, actionable insights for diverse audiences.
• Strong communication and stakeholder engagement skills, including gathering requirements, presenting findings, and supporting data-informed decision-making.
• Knowledge of data governance principles, including data standards, metadata management, privacy, and security practices.
• A collaborative approach, with the ability to work effectively across teams and support organizational reporting needs.

The following qualifications would be considered assets

• Experience with Python or R for data preparation, automation, analytics, or ETL processes.
• Familiarity with cloud and Microsoft data platforms such as Azure Synapse Analytics, Power Platform, SharePoint, or related technologies.
• Experience in healthcare, community services, non-profit, or other mission-driven environments.
• Microsoft Certified: Power BI Data Analyst Associate (or equivalent certification).
• Certifications in data management, analytics, or other business intelligence platforms (ie. Tableau, Qlik).

Valid Ontario Driver's Licence and access to a reliable vehicle to support work across multiple sites is required.

To Apply

We invite applications from those interested in this position to apply through the KidsAbility Career Centre.

Please note: KidsAbility sites will be closed as of Friday, July 24 at 4:30pm and will reopen on Monday, August 10 at 8:00am. This closure may affect the timeline of the recruitment process.

---

KidsAbility strives to create an accessible and inclusive application and selection process and is committed to working with and providing reasonable accommodations to job applicants who may require provisions to participate in the selection process. Should any applicant require accommodation please contact Human Resources in advance for assistance.

Equity, Diversity, and Inclusion are the core values of KidsAbility. We are a diverse workforce with wide perspectives and creative ideas that benefit our clients and the community. It is the policy of KidsAbility to ensure equal employment opportunity without discrimination or harassment.

We welcome applications from visible minority groups, women, Indigenous Peoples, persons with disabilities, religion, age, sex, sexual orientation, gender identity or expression, marital or domestic/civil partnership status, genetic information or any other ground protected by applicable law.

Please note that all prospective KidsAbility employees are subject to mandatory immunization requirements, including the full and ongoing COVID-19 vaccination, as a condition of obtaining and maintaining employment. We will make accommodations as directed by the Ministry of Children, Community and Social Services and the Chief Medical Officer of Health.