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 (3 days in office weekly)

TTC accessible office

Job summary

A national professional organization is seeking a Data & Analytics Specialist to support their digital transformation and AI initiatives. This role involves designing modern data infrastructure, integrating data across enterprise systems, and ensuring data governance. Ideal candidates will have 3–5 years of experience in data analytics or engineering, strong SQL and Python skills, and a passion for building foundational data capabilities. The company offers a hybrid work model and a focus on professional development.

Qualifications

• 3–5+ years in data analytics, data engineering, or BI roles.
• Hands-on experience designing/building cloud-based data warehouses or lakes.
• Practical experience with data governance, standards, access controls, and catalogs.

Responsibilities

• Design and maintain a modern data warehouse and cloud-based data architecture.
• Integrate data from multiple enterprise systems.
• Build and automate dashboards and reports used by teams.

Skills

Data analytics

Data engineering

Strong SQL

Python

Data governance

Cross-functional collaboration

Tools

Power BI

AWS

Azure

GCP

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

• 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

Note: We look forward to hearing from you, and will contact only applicants 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.

You can also find more jobs that may be suited to you on the Options Consulting Solutions Indeed and LinkedIn pages. Follow us on Instagram and Facebook for job searching tips and other updates.