Junior SSIS / SSAS Developer

Junior SSIS / SSAS Developer page is loaded## Junior SSIS / SSAS Developerlocations : Toronto, Ontario : Waterloo, Ontariotime type : Full timeposted on : Posted Yesterdayjob requisition id : JR00120233You 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 :
• The successful candidate will implement and manage Global Data Mining projects and support reporting functions requiring technical skills with latitude in approach and analysis. This person would participate in defining the objectives, scope, and requirements of assigned activities, analyze issues and problems and determine the best approach and methodology to address them.The main objective of the job is to translate client (internal / external) requirements into ETL data flows from source to target. Other major activities may include, but are not limited to, support marketing research, statistical analysis, ad-hoc reporting and the implementation of necessary system and operational controls, to ensure data integrity and compliance with industry legislation and / or internal company policies.
• Location :
• Hybrid, with training and occasional days at One York Street, Toronto
• 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
• 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
• Assets
• Understanding of Life Insurance and / or Segmented Funds
• Knowledge of projects and systems development methodologies
• Experience with SSRS and Tableau
• Unique Requirements
• As a condition of the role, the successful candidate must obtain a Government of Canada Reliability Status security clearance through Sun Life in advance of the start date
• What's
• 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
• The opportunity to move along a variety of career paths with amazing networking potential
• 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
• We’re honoured to be recognized as a 2025 Best Workplaces in Ontario by Great Place to Work Canada#LI-HybridThe 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! Several work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.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 :
• 65,000 / 65 000 - 105,000 / 105 000
• Job Category :
• IT - Application Development
• Posting End Date :
• 12 / 02 / 2026
• Shine together
• At Sun Life, you can be your most brilliant self. Our supportive, flexible, and inclusive work environment is one where you – and your career – can thrive. Whatever your aspirations, collaborative leaders and colleagues are ready to help you learn, grow, and succeed.
• Make life brighter
• We’re a global company with a passion for people. Our purpose is to help Clients achieve lifetime financial security and live healthier lives. As a team of 30,000 across 26 countries, our impact is far-reaching, and locally relevant There’s power in numbers. As part of Sun Life’s growing team, you have an impact on people in your community and around the world.
• Shape the future
• With an optimistic eye on a brighter future, we drive to innovate. Be part of leading change, push boundaries and try new ways of working. Use data to drive bold actions. Be agile and pivot as we test and learn. At Sun Life, we’re driving transformation, sustainability and innovation for our Clients, employees, partners, and communities. Join us. Together, we can make the future brighter.Join a top employer for a brighter future. Visit

#J-18808-Ljbffr