Data Analyst

**About Chartered Professional Accountants of Canada**

Chartered Professional Accountants of Canada (CPA Canada) is one of the most influential accounting organizations in the world. Working with the provincial, territorial and Bermudian regulatory bodies, CPA Canada supports the profession and represents Canadian CPAs at the national and international levels.

Nationally, CPA Canada acts in the public interest to promote transparency in financial markets, prepare CPAs for a rapidly evolving business environment through extensive guidance and programming, and contributes to standard setting and policy making. Globally, CPA Canada works together with international bodies to build a stronger accounting profession worldwide.

**This hybrid role is national in scope and can be aligned to any of our CPA Canada offices.**

**The targeted annual salary range for this position is $72,100 to $84,100 and is commensurate with experience.**

**About the opportunity**

The Data Analyst plays a vital role in turning customer data into actionable insights that drive better experiences for CPA Canada’s customers, students, and stakeholders. This role supports the Customer Experience team by sourcing and integrating data across platforms, ensuring pipelines, tracking, and integrations function reliably, and maintaining clean, connected datasets that enable the team to build visualizations and derive insights with confidence.

**What you'll do**

**Maintenance Tasks**
- Dashboards: QA and periodic checks and updates
- Tickets: follow up on technical tickets & requirements (e.g. Tracking codes implementation & other technical issues that require following up with other departments/vendors like IT & agencies)
- Tracking: make sure tracking is up and always running by periodically checking data from GA4 and different data sources and making sure GTM setup is clean and free of errors.
- Data management: ensure data pipelines, and integrations function reliably, keeping datasets accurate, complete, and up to date

**Dashboards & Reporting**
- Build, maintain, and evolve interactive dashboards and regular reports using tools like **Power BI**, **Excel**, and **HubSpot**.
- Provide performance tracking on key business initiatives Support business units with ad-hoc reports and deep-dive analysis to guide decision-making.
- Segment and profile customers to support personalized communications, journeys, and service strategies.

**Cross-functional Collaboration**
- Partner with Marketing, Member Services, Education, and IT to provide analytical support for projects involving member and student experience.
- Contribute insights to journey mapping and service design initiatives led by the Customer Experience team.

**What we're looking for**
- Education: Bachelor's degree in Business, Statistics, Marketing, Data Science, or a related field.
- Experience: 2+ years in a data analysis role, ideally in a membership-based, non-profit, or professional services organization.
- Ability to read & understand basic code like HTML to diagnose website issues.
- Strong analytical and problem-solving skills with a passion for data storytelling.
- Proficient in data visualization tools (e.g., Power BI, Looker).
- Experience with CRM platforms (preferably HubSpot) covering Marketing & Sales automation functionalities
- Experience with SQL, DAX & M languages.
- Knowledge of other programming languages (e.g. Python, or R) is an asset.
- Experience with Microsoft Azure environment (e.g. Data Factory, Blob Storage) is a strong asset.
- Advanced Excel skills and comfort working with large datasets.
- Excellent communication skills; ability to translate complex findings into clear business recommendations.
- Bilingualism (French and English) is an asset.

**Key Competencies**
- Technical acumen: natural ability to quickly learn new platforms and systems.
- Result-oriented: open for feedback to grow, ability to admit when making a mistake, learn from it and improve (fail fast, move fast). Focus on the outcome, eyes on the prize mindset.
- Analytical Curiosity: You love digging into data and asking “why.”
- Attention to Detail: You ensure data accuracy and precision in everything you do.
- Customer Focus: You put the member and student perspective at the center of every analysis.
- Collaboration: You work effectively across teams and value shared success.
- Agility: You thrive in a fast-paced environment and pivot quickly when priorities shift.

**What it's like to work here**

At CPA Canada, we’re proud to foster a welcoming and inclusive workplace that celebrates diversity and promotes health and wellness for all employees. We believe in offering a flexible and balanced work environment, where staff can thrive both professionally and personally. Our headquarters are located in downtown Toronto, with regional offices in Vancouver, Ottawa, and Montreal. As part of the CPA Canada team, you’ll enjoy competitive salary, comprehensive benefits from Day One, a robus