Business Intelligence Specialist

About YOU

You are Business Intelligence Specialist with a track record of leading cross-functional initiatives that drive strategic and operational impact. You bring strong organizational and communication skills. You excel at building relationships, facilitating collaboration, and keeping projects on track from start to finish. You will be responsible for designing, developing and maintaining high quality dashboards, managing and analyzing complex datasets and applying advanced analytical techniques to identify trends, forecast demand and support strategic and operational improvement initiatives agency’s mission of delivering high-quality, equitable, and accessible services to children, youth and families. You are adaptable, detail-oriented, and thrive in mission-driven environments where your leadership can create lasting, meaningful change.

About ROCK

ROCK (Reach Out Centre for Kids) is recognized as the number one non-profit employer of choice, leading the way in providing mental health services to children, youth, and families in the Halton region. We are an accredited organization with exemplary standings from Accreditation Canada, reflecting our commitment to high-quality care. Our dynamic and collaborative team is dedicated to achieving our mission and vision, fostering a positive and inclusive environment that mirrors the diversity of the community we serve. At ROCK, we offer various professional development opportunities, company events, and a supportive culture that encourages innovation and growth. ROCK is site certified in the Neurosequential Model of Therapeutics (NMT) a developmentally sensitive, neurobiology-informed approach to clinical problem solving. Our hybrid work model provides flexibility, combining on-site and virtual environments, to best meet the needs of our staff and clients. Join us in making a meaningful impact in mental health care.

The ROLE

The Business Intelligence Specialist plays a critical role in advancing data-informed decision-making within the agency through the development and delivery of data and analytics tools. This role is responsible for designing, developing and maintaining high quality dashboards, managing and analyzing complex datasets and applying advanced analytical techniques to identify trends, forecast demand and support strategic and operational improvement initiatives

This is a newly created Contract Full Time role within the Clinical Strategy and Performance Excellence team until March 31, 2028.

RESPONSIBILITIES

Business Intelligence & Dashboard Development

Design, develop and maintain interactive dashboards and reports using built-in reporting functionality within existing case management tools and other tools including but not limited to excel, MS Power BI and Air Tables.

Translate business requirements into effective data visualizations that clearly communicate trends and enable business users to draw insights for action or improvement.

Ensure dashboards and reports follow data storytelling best practices.

Data Management

Extract, transform, and manage data from multiple sources to support reporting and analysis.

Develop and maintain SQL-based reports and queries within existing case management systems to support operational and quality reporting needs.

Ensure alignment between system-based reports and enterprise BI dashboards to maintain consistency and data integrity.

Develop and maintain data models, documentation and metadata to support transparency and interpretation.

Identify data quality issues and collaborate with system owners, data stewards and others to resolve them.

Implement and manage data validation and quality assurance processes.

Data Analysis

Conduct advanced statistical analyses including regression analysis, cluster analysis and other multivariate techniques to identify drivers, patterns and relationships within service and outcome data.

Develop forecasting models to support capacity planning, demand forecasting and trend projections.

Use R and/or Python including the application of R and Python libraries to perform advanced analytics.

Project Management

Lead and coordinate 2 to 3 small/medium scale projects concurrently, ensuring that they are delivered on time and within scope.

Manage project planning, project timelines, stakeholder communications and training activities.

Facilitate project meetings, track milestones and proactively address risks or barriers with leadership consultation.

Stakeholder Engagement & Change Management

Engage internal stakeholders throughout the project lifecycle.

Facilitate Working Groups and project meetings to gather input and communicate updates.

Build positive relationships across the agency to support shared understanding and collaborative decision-making.

Help teams adapt to new tools, processes, or changes by applying change management best practices.

Contribute positively to a collaborative, respectful, and solutions-oriented team environment.

Coaching & Leadership

Provide guidance on performance measurement, indicator development, and data-informed decision-making practices.

Stay current on emerging BI tools, analytical methods and trends relevant to data and analytics in community mental health.

Support the evolution of ROCK’s data and analytics capabilities through the development of tools and peer coaching.

Compliance, Safety, and Safeguarding Responsibilities

Comply with the Occupational Health and Safety Act, including the requirements of Section 28, and follow all agency health and safety policies.

Operationalize client safety by adhering to policies and guidelines that support consistent delivery of safe, high-quality services.

Commit to supporting client-centered care by adhering to ROCK’s principles of respect, collaboration, and service planning as outlined in the agency’s strategic plan.

Collaboration and Communication

Communicate clearly and professionally with internal staff and management.

Provide responsive and respectful customer service to internal stakeholders.

Supervisory or Leadership Responsibilities

This position does not have direct supervisory responsibilities but is expected to demonstrate accountability, initiative, and professional leadership within the scope of the role.

QUALIFICATIONS:

EDUCATION

Bachelor’s degree in data science, Statistics, Computer Science, Health Informatics, Analytics or a related field; Master’s degree is considered an asset.

Relevant certifications such as MS Power BI, data analytics, data science or health informatics credentials are considered an asset.

EXPERIENCE

Minimum of 2 to 3 years of relevant experience in business intelligence, data analytics or related role, ideally in a mental health, healthcare or non-profit environment.

Familiarity with healthcare or mental health service data/indicators is an asset.

Familiarity with privacy legislation and data governance practices relevant to healthcare data is an asset.

Familiarity with children’s services or community-based programming is an asset.

Advanced proficiency in Microsoft Excel and Microsoft Office applications.

Proficiency in MS Power BI, SQL, R and Python.

Strong analytical, problem-solving, and communication skills.

Ability to work collaboratively within a team environment while maintaining a high degree of accuracy and attention to detail.

Proficient in the use of technology as required of the position, including working in a virtual environment with MAC OS operating systems experience preferred.

Experience working with MS Power BI or Canva is considered an asset.

Current (within three months) criminal reference check with vulnerable sector search.

What will help you succeed:  

Strong interpersonal and interviewing skills.

Demonstrated ability to apply relevant knowledge and training to the assessment and treatment of children and their families.

The ability to speak a second language is highly valued.

Strong verbal and written communication skills.

Our rewards ROCK, join our team and ENJOY:
🌴 Recharge: starting with paid time off, 2 weeks’ vacation and 2 additional ROCK holidays in addition to statutory holidays

🕒 Flexibility: Plan your schedule to balance with your personal life.

🏥100% employer paid premiums for extended health and dental benefits. (Contract >1 year; you need to be exclusively working with ROCK)

📖   Learning: Professional development assistance, investing in your growth

🍎 Wellness: Discounted Good life memberships and Health Benefits

ROCK is committed to fostering a positive and progressive workforce reflecting the community we serve and promoting diversity at all levels in a dynamic and inclusive environment. We provide equitable treatment and accommodation to ensure barrier-free employment in accordance with the Ontario Human Rights Code, Accessibility for Ontarians with Disabilities Act and ROCK’s Accommodation Policy.

If you are invited to participate in the interview process and require accommodation for the interview, we ask that you provide your accommodation request as soon as reasonably practicable. Please be advised that you may be requested to provide verifiable supporting information, such as medical or other documentation depending upon the type of Code-protected accommodation, to Human Resources to ensure that appropriate accommodation is provided to you throughout the hiring process. ROCK treats all accommodation requests confidentially.

Please note that ROCK positions are currently working in an on-site and virtual hybrid model.  Positions are located in the Halton Region and travel between sites may be required.