Business Data Analyst

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.

Job Description:

Reporting to the Data Operations Manager, Enablement & Governance, The Business Support Developer will support the development of innovative analytics solutions including transformation processes and complex data models that form the core of a new generation of analytics services and self-serve solutions for our customers in Canadian Operations.

Our growing mandate to deliver Data Analytics and Data Solutions requires a Developer with support experience to accelerate the development of our strategic analytics projects in support of our business stakeholders.

What will you do?

• Provide SQL Support Development (Includes Performance Tuning Stored Procedures and providing best practice advice to other developers) (Key focus)
• Resolve defects and issues in a timely manner by investigating issues, identifying root cause, recommending, and implementing proactive solutions
• Maintain best practice standards for analysis and reporting at all levels including data governance, documentation, testing and visualization technique
• Work directly with data engineers, business data analysts, data scientists and business partners in Canadian Operations throughout the entire engagement life cycle including technical analysis, design, development, implementation, and consulting efforts
• Participate in group meetings of various sizes for solution design, decision making, problem-solving and solution implementation
• Grow your knowledge with SSIS & C# as well as some batch scripting

What will you need to succeed?

• Minimum undergraduate degree in Business Administration, Mathematics, Computer Science, Engineering or equivalent
• 1-2 years of experience in:
  • SQL and other languages used in data manipulation
  • Data warehousing principles and experience in design and/or development using dimensional modeling principles.
• Strong oral and written communication skills with experience in relating complex concepts to non-technical users, including presentation and storytelling with data.
• Solid understanding of how to consolidate and transform data to meaningful and actionable information
• Ability to draw out meaningful business insights by synthesizing information from multiple sources
• Demonstrated experience in development of analytics applications or data analysis, including insights development and communication to senior leadership

What will be nice to have?

• Experience in SSIS ETL and C# Development (nice to have)
• Experience with optimization and tuning of large data extracts
• Tableau Experience
• Experience with Agile or design-driven development of analytics applications
• Knowledge of Insurance or Financial Services industry

What’s in it for you?

• Competitive salary and bonus structure influenced by market range data
• 15 days’ vacation per year and an innovative sabbatical program
• A friendly, collaborative, and inclusive culture
• Being part of our analytics community, where we share best practices and broaden skillsets
• 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
• Fitness and wellness programs that help you balance work and life and enjoy a healthier lifestyle

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 [email protected].

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:

53,800/53 800 – 87,400/87 400

Job Category:

Advanced Analytics

Posting End Date:

19/02/2024