Junior SSIS/SSAS Developer implementing and managing Global Data Mining projects for Sun Life. Collaborating on technical reporting functions requiring ETL data flow expertise.
Responsibilities
Implement and manage Global Data Mining projects and support reporting functions requiring technical skills with latitude in approach and analysis
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
Translate client (internal/external) requirements into ETL data flows from source to target
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
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
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
Programmer Analyst contributing to IT efficiency and quality at Desjardins. Involved in software development, documentation, and technical support for IT operations.
Senior Developer transforming data into actionable insights for Labelink in a hybrid role. Collaborating to build a modern data ecosystem that supports operations and decision - making.
Programmer analyst improving IT efficiency and quality by developing and maintaining software products at Desjardins Group in a hybrid work environment.
Engineering Manager leading a team in secure build infrastructure development at Docker. Overseeing high - stakes projects and fostering team growth in a remote - first environment.
Firmware Developer collaborating with engineers to optimize and develop firmware for safety devices at Blackline Safety. Ensuring the full lifecycle of product development from design to deployment.
Chargé de projets pour le Groupe ABS inc., supervisant la qualité des travaux et assurant la planification des chantiers. Collaboration avec des équipes pour garantir la réussite des projets d'ingénierie des matériaux.
Study Manager overseeing engineering studies for mining and mineral processing projects across North America. Leading teams and managing client relationships while ensuring project delivery and quality standards.
Transportation Engineering Intern supporting design projects and quality assurance processes using AutoCAD and Microstation. Collaborating within a global mobility team in Canada.
T - SQL Developer programming data transformations for TELUS Health’s Central Data Repository. Responsible for validating and adapting programming based on client feedback within deadlines.