Data Analyst, Rewards

3 weeks ago


Waterloo, Canada Sun Life Full time

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. Discover how you can make a difference in the lives of individuals, families and communities around the world.

The Data Analyst, Recognition provides data analytics support for multiple annual recognition programs and campaigns available to approximately 1,800 Sun Life Advisors.

**Preferred skills**
- Minimum 5 years' experience in data analytics and business intelligence, including predictive analytics and data modeling.
- Degree in business administration, finance, economics, computer science, statistics, mathematics, engineering, or equivalent is required.
- Experience building and maintaining Excel Macros and VBA programs.
- Experience using data analysis tools such as Microsoft SQL server or similar.

**Qualifications**
- Expert knowledge in the Microsoft suite of products (Excel, Word etc.) with proven experience with VBA, as well as advanced Excel functions
- Highly motivated individual who can execute independently with mínimal direction
- Proficient in data investigation and compilation with multiple data sources
- Technical aptitude: ability to learn new tools and software quickly and understand technical concepts
- Strong analysis, investigative and problem-solving skills
- Innovative thinker; able to identify and champion proposals for approval
- Builds context by pushing beyond "how things are done" to understand "why" and uncover the underlying principles shaping the business
- Ability to extract, manipulate and simplify data through a variety of tools and techniques
- Process improvement skills with a demonstrated ability to produce meaningful results from data
- Strong communication and interpersonal skills; ability to explain business concepts to IT partners, and technical concepts to business partners
- Attention to detail and in-depth planning, organizational and time management skills
- Positive attitude to thrive in a dynamic, fast-paced environment, and quickly find alternative solutions to challenges
- Flexibility: Ability to accept change, and adapt well to ambiguous situations

**Responsibilities**
- Lead incentive program modelling efforts by extracting data, analyzing, and drafting insights from previous programs; present proposals for future programs to the Recognition team and senior leadership for approval.
- Generate reports, develop, and maintain databases by acquiring data from various sources, build scripts that will make data evaluation process more flexible or scalable across data sets.
- Analyze and model data to showcase rich interactive visualizations to extract insights, to drive for strategic business decisions to drive performance.
- Adjust Excel VBA macros to include new requirements for annual programs, quarterly campaigns, and ad hoc incentives; ensuring data quality and timely delivery of the report.
- Work with the internal programming team to implement and test changes to automate Recognition program reporting.
- Support data and insights requests after each incentive program period to deliver the performance analysis and present them to the team and leadership.
- Support data warehousing in identifying and revising reporting requirements.
- Support ad hoc data and performance requests from leadership.
- Complete monthly, quarterly, annual program status reporting.
- Attend regular Recognition team meetings and provide data and insights in these meetings as required.
- Build new reports in Excel or Tableau as required to support the continuous improvement efforts of Recognition team.
- Ensure that business and technical requirements are captured in proper documentation and maintained.

At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

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

**Salary Range**:
51,100/51 100 - 82,800/82 800

**Job Category**:
Advanced Analytics

**Posting End Date**:
12/01/2023



  • Waterloo, Canada University of Waterloo Full time

    Overview: The Total Rewards Specialist supports the Director, Total Rewards with the design, communication, and maintenance of the University’s compensation, benefits (including pension), and other policies and programs, ensuring that the administration of arrangements by vendors and other internal partners are in alignment with vendor contracts,...


  • Waterloo, Canada University of Waterloo Full time

    Overview: The Analyst provides consultative support to CEE in the form of business analysis, process design, continuous process improvement, project management, process and technical documentation and software Quality assurance (SQA). The Analyst will support one of the following areas: Data Analytics, Reporting & Research; Portfolio & Process; or Technology...

  • Data Analyst

    4 days ago


    Waterloo, Canada TextNow Full time

    We believe communication belongs to everyone. We exist to democratize phone service. TextNow is evolving the way the world connects and that's because we're made up of people with curious minds who bring an optimistic, yet critical lens into the work we do. We're the largest provider of free phone service in the nation. And we're just getting started. Join...

  • Business Data Analyst

    1 month ago


    Waterloo, Canada RideCo Full time

    This is an opportunity in the exciting and fast-growing transportation technology industry. Public transit is being transformed from a system of static, scheduled fixed-routes, to a dynamic on-demand network, and you’ll be one of the pioneers shaping this transformation. You’ll join a robust and rapidly growing client success team. As a Business Data...

  • Business Data Analyst

    1 month ago


    Waterloo, Canada RideCo Full time

    This is an opportunity in the exciting and fast-growing transportation technology industry. Public transit is being transformed from a system of static, scheduled fixed-routes, to a dynamic on-demand network, and you’ll be one of the pioneers shaping this transformation. You’ll join a robust and rapidly growing client success team. As a Business Data...

  • Laboratory Analyst

    20 hours ago


    Waterloo, Canada ALS Full time

    Laboratory Analyst Waterloo, ON, Canada Req #3378 Wednesday, May 22, 2024 Imagine your future with us! At ALS, we encourage you to dream big.  When you join ALS, you join a purpose and values-driven team that empowers you to innovate, create, and thrive. Our global team turns up each day with passion and commitment to do amazing things,...


  • Waterloo, Canada Descartes Systems Group Full time

    Descartes Unites the People and Technology that Move the World The need for efficient, secure, and agile supply chains and logistics operations has become ever more critical and complex. By combining innovative technology, powerful trade intelligence and the reach of our network, Descartes helps get goods, information, transportation assets, and people...


  • Waterloo, Canada eSentire Full time

    About eSentire Founded in 2001, the company’s mission is to hunt, investigate and stop cyber threats before they become business-disrupting events. Combining cutting-edge machine learning XDR technology, 24/7 Threat Hunting, and proven security operations leadership, eSentire mitigates business risk and enables security at scale. The Team eSentire...


  • Waterloo, ON, Canada Sun Life Financial Full time

    Student, Software Delivery Analyst (Fall 2024 & Winter 2025) page is loaded Student, Software Delivery Analyst (Fall 2024 & Winter 2025) Apply locations Waterloo, Ontario time type Full time posted on Posted 3 Days Ago job requisition id JR00095512 Our student and new graduate programs offer a chance to explore Sun Life from the inside. You’ll make a...


  • Waterloo, Canada Sun Life Full time

    Our student and new graduate programs offer a chance to explore Sun Life from the inside. You’ll make a difference in the lives of our customers and communities, while building the skills and experience that allow you to grow in a meaningful and rewarding way. **Length of term**: 8 months (September 2023 - April 2024) **Hybrid/Remote**:This co-op...


  • Waterloo, Canada Definity Financial Corporation Full time

    Job ID : 7421 Category : Claims Brand : Definity Regular/Temporary : Temporary Fulltime/Parttime : Full Time Location : Waterloo, Canada Posting Range : $42,400 - $78,100 Definity is the parent company to some of Canada’s most long-standing and innovative insurance brands, including Economical Insurance, Sonnet Insurance, Family Insurance Solutions, and...


  • Waterloo, Canada CB Canada Full time

    Junior Financial Analyst - PROCOM KW is currently searching for a Junior Financial Analyst with experience in general accounting procedures and corporate finance principles.Junior Financial Analyst ResponsibilitiesDeveloping revenue estimates, operating plans / forecasts / reviews, OP (operatingplan/budget) and/or corporate reportingProviding...


  • Waterloo, Canada Equitable CA Full time

    At Equitable, we realize that your work life is not just about performing a job; it's about being part of a workplace that helps you grow and reach your full potential. Within our friendly and collaborative work environment, we recognize that the key to our growth and success is a dedicated, motivated and client-responsive staff. Join Equitable...

  • Clinical Analyst.

    21 hours ago


    Waterloo, Canada Agfa Full time

    From product development to implementation, our unified Enterprise Imaging Platform is purpose-built to reduce complexity, improve productivity and deliver clinical value. We use our proven track record as an innovator, our in-depth medical knowledge and our strategic guidance to help healthcare providers achieve their clinical, operational and business...


  • Waterloo, Canada Tangam Systems Full time

    **Role Summary**: Advances in data analytics and visualization are revolutionizing the way businesses operate. Tangam Systems is a leader in driving that transformation in the gaming industry. As the newest member of our Casino Analytics team, you will master the Tangam analytics and visualization software and independently construct customer-facing...

  • Data Analyst

    1 month ago


    Waterloo, Canada Manulife Full time

    **_Are you looking for a supportive, collaborative workplace with great teams and inspiring leaders? You’ve come to the right place. We’re looking for ambitious people who share our values and want to make every day better for people around the world. If this sounds like you, and the career below sounds exciting, we’d like to hear from you....


  • Waterloo, Canada Equitable CA Full time

    At Equitable, we realize that your work life is not just about performing a job; it's about being part of a workplace that helps you grow and reach your full potential. Within our friendly and collaborative work environment, we recognize that the key to our growth and success is a dedicated, motivated and client-responsive staff. Join Equitable...

  • Institutional Analyst

    4 weeks ago


    Waterloo, Canada University of Waterloo Full time

    Overview: Under the direction and guidance of IAP leadership, the Institutional Analyst (IA) is responsible for the development of databases, models, analyses, and reporting as well as communicating the results of analyses internal and external to IAP. The IA will proactively contribute to IAP’s mandate of providing data, advice, analytical and planning...

  • Senior Data Analyst

    18 hours ago


    Waterloo, Canada Heartland Farm Mutual Inc. Full time

    Located in Ontario and Nova Scotia, Heartland Mutual Insurance strives to be the Best Mutual. Our team of talented and dedicated professionals challenge the norm and strive to be extraordinary. It’s all about fulfilling our promise with a personal approach. With our team, you’ll bring this purpose to life every day by living our values, being open to...

  • Senior Data Analyst

    20 hours ago


    Waterloo, Canada Heartland Farm Mutual Inc. Full time

    Located in Ontario and Nova Scotia, Heartland Mutual Insurance strives to be the Best Mutual. Our team of talented and dedicated professionals challenge the norm and strive to be extraordinary. It’s all about fulfilling our promise with a personal approach. With our team, you’ll bring this purpose to life every day by living our values, being open to...