Data and Analytics Specialist

Options Consulting Solutions; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Benefits offered by this job

Competitive salary and annual bonus

Strong focus on professional development

Inclusive and collaborative culture

Hybrid work model

TTC accessible office

Job summary

A national professional organization in Toronto is seeking a Data & Analytics Specialist to support their digital transformation and AI initiatives. In this strategic role, you will design modern data infrastructure, develop reporting and dashboards while ensuring data governance. The ideal candidate has 3-5+ years of experience in data analytics, is proficient in SQL and Python, and has experience with cloud platforms like AWS, Azure, and GCP. This role offers hybrid work and emphasizes professional development and collaboration.

Qualifications

• 3-5+ years in data analytics, data engineering, or BI roles.
• Hands-on experience with cloud-based data warehouses.
• Strong SQL (intermediate+) and Python skills for data transformation.
• Familiarity with data governance and compliance standards.

Responsibilities

• Design and build modern data infrastructure.
• Develop enterprise reporting and dashboards.
• Implement data governance frameworks.
• Support the organization's data and analytics adoption.

Skills

Data analytics

SQL

Python

Data governance

BI tools

Cloud-based data architecture

Communication skills

Tools

AWS

Azure

GCP

Power BI

Job description

Our client, a national professional organization with a highly engaged membership, is seeking a Data & Analytics Specialist for a newly created, strategic role that is central to their digital transformation and AI initiatives.

This position sits at the intersection of data engineering, analytics, and governance, responsible for turning organizational data into a trusted, actionable asset that drives smarter decisions across all teams.

Company Perks and Rewards

• Competitive salary and annual bonus
• Strong focus on professional development and education support
• Inclusive and collaborative culture
• Hybrid work model (3 days in office weekly)
• TTC accessible office

The Job

Reporting into a highly collaborative technology function, the Specialist will design and build modern data infrastructure, develop enterprise reporting and dashboards, and implement data governance frameworks that support ethical, secure, and compliant data use. The role plays a central part in activating the Institute’s AI strategy by ensuring data is well‑structured, accessible, and ready to support advanced analytics and innovation.

This is a hands‑on role with strategic influence where priorities may shift based on organizational needs. You will work closely with IT, developers, business stakeholders, and leadership, acting as a trusted partner who translates business questions into scalable data solutions.

Key focus areas include:

• Designing and maintaining a modern data warehouse and cloud‑based data architecture
• Integrating data from multiple enterprise systems (CRM, LMS, finance, marketing, and other platforms)
• Building and automating dashboards and reports used by teams across the organization
• Establishing and operationalizing data governance, cataloging, and standards
• Supporting organization‑wide adoption of data and analytics
• Contributing to AI, analytics, and innovation initiatives as the Institute evolves

This is an opportunity for someone who enjoys building foundational data capabilities, working with minimal hand‑holding, and having visible impact in a mission‑driven, member‑focused organization.

What You Bring to the Job

You bring a blend of technical depth, practical analytics experience, and strong communication skills, along with the confidence to operate independently in a collaborative, expert‑driven environment.

• 3–5+ years in data analytics, data engineering, or BI roles
• Hands‑on experience designing/building cloud‑based data warehouses or lakes (AWS, Azure, GCP)
• Strong SQL (intermediate+) and Python skills for data transformation, integration, and automation
• Experience with data pipelines, system integrations, APIs, and BI tools (Power BI or similar)
• Knowledge of multiple enterprise systems (CRM/AMS, LMS, finance, marketing)
• Practical experience with data governance, standards, access controls, and catalogs
• Understanding of privacy, security, and compliance (PIPEDA, CASL, GDPR, PCI)
• Ability to structure, document, and scale data for analytics and AI initiatives
• Strong communicator, able to translate data insights for non‑technical audiences
• Proven cross‑functional collaboration with IT, analysts, and business stakeholders
• Self‑motivated, organized, and comfortable in shared ownership environments with minimal supervision
• Curious, growth‑oriented, and interested in emerging analytics, data engineering, and AI
• Experience in professional associations, membership‑based organizations, education, or non‑profits is an asset

We really look forward to hearing from you, but please understand that I will only be contacting those that are applicable for the role!

Options Consulting Solutions is an equal opportunity employer and welcomes applications from all individuals. Applicants selected for an in‑person interview will be asked whether specific accommodations are needed to support a personal disability.