Data & Reporting Analyst

KidsAbility Centre for Child Development; Waterloo; On-site; CAD 65,000 - 85,000; Full time

Job summary

A non-profit organization in Waterloo seeks a Data & Reporting Analyst to enhance business intelligence and provide data-driven insights. The employee will develop dashboards, collaborate with stakeholders, and analyze data trends while ensuring a data-informed culture. Ideal candidates will possess strong skills in Power BI and excellent communication abilities.

Benefits

Ongoing training and development opportunities

Comprehensive benefits package

Employee and Family Assistance Program

Qualifications

• 4–6 years of professional experience in data analytics or business intelligence roles.
• Solid understanding of data-visualization best practices.
• Experience with large or complex datasets.

Responsibilities

• Develop and maintain interactive dashboards using Power BI.
• Collaborate with stakeholders for meaningful visualizations.
• Analyze trends in clinical and operational data.

Skills

Proficiency in Power BI

Experience with SQL

Data storytelling

Strong communication skills

Education

Bachelor’s degree in Computer Science or related fields

Tools

Excel

SQL

Python

R

Job description

About KidsAbility:

We are a not-for-profit, equal opportunity employer supporting over 17,000 children and youth to reach their social, physical, communication and behavioural goals each year. Providing early and exceptional family-centred services in the Waterloo and Guelph-Wellington regions, we believe that by living our values, our impact can be profound, and together, we can build brighter futures. We’re looking for the right people to join our team; supporting children, youth, and families to realize their potential, while realizing your own. At KidsAbility, we offer:

• Ongoing training and development opportunities, empowering you to enhance your skills
• A supportive, collaborative, and inclusive work environment dedicated to family-centred care
• Organizational commitment to innovation and research; continually evolving our approaches so we may serve with purpose and value
• Initiatives to support your well-being including social events, opportunities to give back to your community and access to Employee and Family Assistance Program
• Comprehensive benefits and optional group RRSP program, short- and long-term disability income protection benefits, and generous vacation package and paid personal leave days

About the Opportunity:

KidsAbility is seeking a Data & Reporting Analyst to support the organization’s growing need for data-driven insights and improved business intelligence infrastructure. This role is ideal for someone with a passion for data storytelling, a strong foundation in Power BI and Excel, and a collaborative mindset. Reporting to the Director of ITS and working closely with the BI Specialist, the Data Analyst will help design, build, and maintain reports and dashboards that support clinical, operational, and strategic decision-making across the organization. This is a great opportunity for a data professional looking to grow their impact in a mission-driven environment while developing skills in data strategy, governance, and advanced analytics. Responsibilities of this role include but are not limited to:

• Develop and maintain interactive dashboards and reports using Power BI, Excel, and other tools.
• Collaborate with stakeholders to translate business needs into meaningful and accessible visualizations.
• Assist in automating regular reports to improve data accessibility and reduce manual work.
• Support the creation of scalable and standardized reporting tools for internal performance tracking.
• Analyze trends and patterns in clinical and operational data to provide actionable insights.
• Translate complex data sets into clear, easy-to-understand narratives and visual stories for both technical and non-technical audiences.
• Conduct ad hoc analysis in response to internal requests, supporting teams across the organization.
• Contribute to the development of data definitions, metadata documentation, and data quality standards.
• Help maintain a centralized data dictionary and support data integrity initiatives.
• Work with cross-functional teams to resolve data inconsistencies and improve reporting accuracy.
• Partner with departments such as Clinical Services, HR, and Finance to understand data needs and align reporting efforts.
• Support staff in interpreting and using data effectively in their roles.
• Champion a data-informed culture by making data insights approachable and usable across the organization.

More About You:

To qualify, applicants should have Bachelor’s degree in Computer Science, Statistics, Health Informatics, Data Management, Social Sciences, or another related discipline; equivalent work experience will be considered. In addition to:

• 4–6 years of professional experience in data analytics, reporting, or business intelligence roles
• Strong proficiency in Power BI (including advanced DAX), Microsoft Excel (pivot tables, Power Query/M-Code), and SQL for dashboard/report development and data querying
• Experience with Python or R for ETL, data manipulation, or ad hoc analyses is an asset
• Solid understanding of data-visualization best practices and “data storytelling” to translate complex analyses into clear, compelling narratives
• Experience working with large or complex datasets, ensuring data integrity and quality
• Excellent written and verbal communication skills, with demonstrated ability in stakeholder engagement—eliciting requirements, presenting findings, and facilitating data-driven decision-making
• Familiarity with data-governance principles, including metadata documentation, security controls, and data privacy standards
• Exposure to cloud data platforms (e.g., Azure Synapse, Power Platform, SharePoint) is a plus
• Experience in healthcare, non-profit, or other mission-driven environments is preferred
• Microsoft Certified: Data Analyst Associate (DA-100) or equivalent certification is an asset.
• Certifications in data management or other BI tools (e.g., Tableau, Qlik)
• Valid Ontario Driver’s License and access to a vehicle may be required to support multi-site operations.

We invite applications from those interested in this position to submit a detailed cover letter and resume.

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, Aboriginal people, 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.