Data Analyst

Job Title: Data Analyst

Job Title: Data Analyst

Vacancies: This posting is for (1) new role

Location: Toronto, ON | Vancouver, BC | Ottawa, ON | Calgary, AB | Halifax, NS | St John's, NL | Kelowna, BC| Prince George, BC | Montreal, QC | Québec, QC (Detailed office location information can be found by visiting this link: https://cancer.ca/en/contact-us)

Work Model: Hybrid Work Model

Salary Band: 5 ($70,000 - $75,000 CAD)

HELP SHAPE THE FUTURE OF CANCER CARE IN CANADA

The Canadian Cancer Society works tirelessly to save lives, improve lives and drive collective action against cancer. Together with patients, volunteers, donors and communities across the country, we raise funds to invest in transformative cancer research, we provide a caring support system for everyone affected by cancer and we advocate to governments to create a healthier future for all. It takes a society to take on cancer - and the Canadian Cancer Society is leading the way

Join an exceptional team of Digital Strategy & Technology professionals helping to power the Canadian Cancer Society’s (CCS) operations and fuel our mission through innovative digital solutions. The Digital Strategy & Technology team is at the forefront of CCS’s digital transformation. Together, they are harnessing digital tools, data and technology to boost fundraising capabilities and enhance the experience of everyone who interacts with us online.

With a passion for continuous improvement and a commitment to making an impact, the team ensures CCS’s digital presence is strategic and engaging, helping us inspire and empower more Canadians who care about cancer every day.

MAKING AN IMPACT

• Leverage SQL, scripting, and modern analytics platforms to extract, transform, and analyze complex datasets, delivering actionable insights and recommendations that align with business goals
• Partner with business and technical teams to translate business requirements into scalable, reliable, and well-governed analytics solutions
• Support a culture of data-driven decision-making by applying automation, engineering best practices, and modern design patterns to improve how data is analyzed, visualized, and utilized across the organization

What You’ll Be Doing

• Analytics & Reporting Development

Report & Dashboard Development

• Design, develop, and maintain reports and dashboards using Salesforce CRM Analytics, Salesforce Reporting, and Power BI to support organization teams
• Build and optimize semantic models and datasets to support business reporting and analytics needs
• Optimize reporting and dashboard assets for usability, performance and accessibility

Analytics & Insights

• Perform exploratory data analysis to identify trends, patterns, and opportunities across business functions
• Translate complex data into clear, actionable insights and recommendations for business teams
• Use predictive models and statistical analyses to support donor segmentation, campaign targeting, and fundraising forecasting
• Leverage advanced analytics techniques including propensity scoring, trend analysis, and cohort modeling to inform business strategy

Collaboration & Engagement

• Partner with cross-functional teams including business partners, data engineers, and digital teams
• Provide guidance and support to business users on reporting and analytics tools
• Data Development & Transformation

Data Preparation & Processing

• Extract, transform, and prepare analytical datasets using SQL, Python and scripting languages
• Build and maintain reporting datasets, dataflows, and curated data assets incorporating key metrics and business data
• Utilize enterprise data platforms (e.g., Microsoft Fabric) as supporting data sources where required

Data Modeling & Documentation

• Contribute to the design and optimization of data models that support reporting and analytics platforms
• Develop and maintain documentation for datasets, data definitions, and analytical processes
• Operational Excellence

Automation

• Automate repetitive reporting, data preparation, and analytics workflows using Python and scripting

DevOps

• Utilize version control practices for analytics assets, reports, and code
• Contribute to CI/CD processes for analytics solution deployment using Azure DevOps

Quality

• Develop and maintain automated testing for reports, datasets, and analytics solutions
• Support monitoring and validation of analytics pipelines and reporting processes
• Apply development best practices including code quality, documentation, and peer review
• Data Governance & Standards

Governance & Compliance

• Apply data governance, compliance, and data quality standards when developing analytics solutions
• Ensure data accuracy, integrity, and consistency across reporting outputs
• Adhere to data privacy, security and compliance requirements (PII, PHI etc.)

Data Standards

• Support adherence to established data policies, standards, and best practices
• Other
• Contribute to our culture of diversity, inclusion, belonging and equity (DIBE) by ensuring that all staff feel represented, valued, and heard across all aspects of their identity, including gender, age, religion, ethnicity, nationality, race, and sexuality.
• Other duties as assigned

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Analytics or a related discipline
• More than 3 years, up to and including 5 years - similar or related general experience in progressively more important positions

Technical Skills

• Strong proficiency in SQL for data querying, transformation, and analytical dataset development
• Proficiency in Python and/or scripting languages for data analysis and automation
• Experience designing and developing reports, dashboards, and visualizations using Salesforce Reporting, Salesforce CRM Analytics and Power BI
• Experience building and optimizing semantic models and analytical datasets
• Experience working with Fabric to build and manage data pipelines, dataflows, automated workflows, and analytics solutions.
• Understanding of data modeling concepts and relational database design
• Others may apply

Operational Excellence

• Experience with DevOps practices including version control, CI/CD pipelines, and automation frameworks
• Experience automating reporting, data preparation, and analytics workflows
• Knowledge of Agile development practices including code quality, testing, documentation, and peer review
• Experience developing and maintaining automated testing for analytics solutions and reports

Analytical Skills

• Ability to translate complex business requirements into clear, scalable analytics solutions
• Strong exploratory data analysis, troubleshooting, and problem-solving skills
• Ability to identify trends, patterns, and insights from large and complex datasets
• Experience with predictive modeling, statistical analysis, or data-driven segmentation techniques

Communication Skills

• Strong verbal and written communication skills
• Ability to present complex data findings clearly to technical and non-technical stakeholders
• Experience collaborating across business functions to support data-driven decision-making
• Bilingualism (French/English) is highly preferred , with French being an asset due to the organization’s nationwide operations and the need for effective communication across various regions

What You Can Expect From Us

CCS provides impactful opportunities to transform the lives of Canadians affected by cancer. We are devoted to creating an inclusive workplace that celebrates diverse experiences and skills, encouraging all qualified candidates to join us. Our inspiring culture is rooted in our core values and commitment to meaningful change:

COURAGEOUS UNITED CARING RIGOROUS

We offer a competitive salary, excellent benefits, including paid parental leave, family sick time, and health insurance- and a fulfilling work environment where your efforts make a meaningful impact daily.

COME AS YOU ARE

At CCS, we celebrate individuality and the strength of diversity. We are committed to fostering an inclusive and equitable workplace that empowers everyone. We encourage applications from all qualified candidates, including those from equity-des

#J-18808-Ljbffr