Hybrid Junior SSIS/SSAS Developer

Posted 2 minutes ago

Apply now

About the role

  • Junior Developer implementing ETL solutions and supporting data integrity for financial reporting at Sun Life. Analyzing operational problems and collaborating on complex projects with diverse teams.

Responsibilities

  • Assist in defining requirements, plans, and implement projects which are complex, analytical, and very technical in nature
  • Analyze operational and system problems and suggest solutions on how to address them
  • Design, implement, and maintain system applications to support Actuarial Studies, Financial Reporting, Marketing Research, and Management Information reporting
  • Implement system and operational controls to ensure data integrity of reports and analyses produced in the department

Requirements

  • University degree in Science, Mathematics, or Statistics or College diploma in Information Technology or Computer Programming
  • 3 years experience in designing ETL solutions and packages in SSIS (or similar constructs in other leading ETL applications like Informatica PowerCenter)
  • 3 years experience with Visual Basic or C#
  • 3 years experience with SSMS and SQL queries
  • 3 years experience with SSAS
  • 3 years experience in data analysis, and project management techniques
  • Experience deploying SSIS solutions with environment variables and scheduling using SQL Server Agent
  • Experience deploying SSAS solutions
  • Experience with SSRS, R or Tableau
  • Good knowledge of MS Excel and MS Access including VBA
  • Understanding of Life Insurance and/or Segmented Funds
  • Knowledge of projects and systems development methodologies

Benefits

  • Time off giving you the flexibility to focus on the moments that matter, including 15 days of vacation per year
  • Flexible Benefits from the day you join to meet the needs of you and your family
  • Pension Plan participation starts immediately, and you are automatically enrolled.
  • We help you save more with Sun Life automatic and matching contributions and by including both your salary and bonus when making contributions
  • Flexible hybrid work model
  • Work and professional development that is united by our Purpose: to help Clients and Employees achieve lifetime financial security and live healthier lives
  • A friendly, collaborative, and inclusive culture

Job title

Junior SSIS/SSAS Developer

Job type

Experience level

Junior

Salary

CA$65,000 - CA$105,000 per year

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job