Program Manager Data Analytics Jobs in Ontario (NOW HIRING)

You are as unique as your background, experience and point of view. Here, you'll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do.

At Sun Life, we're driven by our Purpose: helping our Clients achieve lifetime financial security and live healthier lives. Our values shape how we work: caring, authentic, bold, inspiring, and impactful.

When you join Sun Life, you'll work with passionate colleagues and empowering leaders who support your growth and celebrate your contributions, so you can make a meaningful difference in our Clients' lives.

Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description:

Reporting to the Manager, Data Analytics, the Senior Data Analyst will lead the development, delivery, and continuous improvement of AI-enabled analytical products and Tableau solutions that support Prospr's digital journey, growth, and sales.

This role partners with business and technology stakeholders to turn ambiguous questions and complex data into trusted metrics, actionable insights, and scalable reporting. The Senior Data Analyst is expected to use SQL, dbt, AWS, Tableau, GitHub Copilot, approved AI tools, and multiple specialized AI agents to improve delivery speed and efficiency while maintaining a high standard of accuracy, data quality, and business accountability.

What will you do?

• Partner with stakeholders to frame business questions, define KPIs, clarify requirements, and recommend actions from analytical findings.
• Use GitHub Copilot, approved AI tools, and multiple specialized AI agents to accelerate research, SQL development, dbt transformations, Tableau development, documentation, testing, issue triage, and analysis while validating all outputs.
• Lead end-to-end Tableau development, including data connections, semantic design, calculated fields, LOD expressions, parameters, actions, interactive dashboards, workbook architecture, performance optimization, publishing, and governance.
• Lead complex ad hoc investigations, data reconciliations, and root-cause analyses across the sales funnel
• Build, enhance, and document reliable analytical data models using SQL and dbt, including clear metric definitions, reusable transformations, tests, lineage, and code review.
• Use AWS services such as Athena, S3, Glue, and Step Functions to automate data preparation, model workflows, extracts, quality checks, and operational reporting.
• Apply rigorous accuracy controls through source-to-target checks, data tests, trend analysis, exception analysis, reconciliations, and business validation before publishing insights and Tableau dashboards.
• Manage and prioritize multiple workstreams at the same time, using AI agents to organize research and accelerate delivery while maintaining clear ownership, status communication, and quality gates.

What do you need to succeed?

• A degree in mathematics, statistics, engineering, computer science, economics, or a related discipline, or equivalent practical experience.
• 4+ years of experience in data analytics, business intelligence, or a related field, delivering trusted insights and reporting in a complex, stakeholder-driven environment.
• Demonstrated ability to use modern AI-assisted ways of working responsibly to improve efficiency, learn quickly, and accelerate delivery without compromising accuracy, confidentiality, or professional judgment.
• Strong analytical judgment and the ability to turn ambiguous business questions into clear recommendations, measurable outcomes, and practical actions.
• Ability to own work from discovery through delivery, manage concurrent priorities, communicate risks clearly, and maintain quality under time pressure.
• Strong written and verbal communication skills, with the ability to explain complex analysis clearly to both technical and non-technical audiences and build trusted stakeholder relationships.

Technical Skills:

• Expert Tableau development using Tableau Desktop and Tableau Server or Cloud,
• Advanced SQL for large datasets and analytical data modeling, including experience with Athena/Trino, relational platforms such as SQL Server or PostgreSQL, and dbt
• GitHub Copilot, approved AI tools, and multi-agent workflows
• AWS cloud data services including S3, Glue, Athena, and Step Functions,
• Strong Excel skills for analysis, validation, and stakeholder-ready outputs

What's in it for you?

• We're proud to be a Best Workplace for Hybrid Work by Great Place to Work Canada
• Be part of our continuous improvement journey in developing the next greatest digital enterprise experience that is united by our Purpose: to help Clients and Employees achieve lifetime financial security and live healthier lives.
• Flexible Benefits from the day you join to meet the needs of you and your family.
• Pension, stock and savings programs to help build and enhance your future financial security.

The Base Pay range is for the primary location for which the job is posted. It may vary depending on the work location of the successful candidate or other factors. In addition to Base Pay, eligible Sun Life employees participate in various incentive plans, payment under which is discretionary and subject to individual and company performance. Certain sales focused roles have sales incentive plans based on individual or group sales results.

Diversity and inclusion have always been at the core of our values at Sun Life. A diverse workforce with wide perspectives and creative ideas benefits our Clients, the communities where we operate and all of us as colleagues. We welcome applications from qualified individuals from all backgrounds.

Persons with disabilities who need accommodation in the application process, or those needing job postings in an alternative format, may e-mail a request to thebrightside@sunlife.com.

We are proud to be a hybrid organization that offers our employees the choice and flexibility to work from both the office and virtually based on the needs of the business, our Clients and you.

We may use artificial intelligence to support candidate sourcing, screening, interview scheduling.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

Salary Range:

Job Category:

Posting End Date: