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
Senior Mainframe Developer building next - gen Payment Processing Platforms at TD Securities. Overseeing application development, support, and technical solution creation.
Lead Software Developer contractor role at RBC Bedford Innovation Hub. Requires expertise in C#, C++, .NET, and JavaScript for senior/lead development work.
Senior Developer contributing to data processing applications with an Agile team at Triton Digital. Join a remote and innovative environment focused on Big Data technologies and continuous improvement.
Software Developer working with the Federation of Quebec Municipalities on .NET applications. Engaging in design, programming, and improving systems while mentoring team members.
Developers at Ingeno design cloud applications incorporating AI for diverse industries. Work in a stimulating and collaborative environment with cutting - edge technologies.
Developer maintaining and improving JetBrains IDE plugin for Hyperskill's educational platform. Remote role focusing on bug fixes and feature implementation for enhanced learner experience.
Senior Developer integrating and developing web - based solutions for CBC/Radio - Canada's Corporate Services team. Collaborating with cross - functional teams on software application development and architecture.
Engineering Project Lead creating detailed designs and overseeing implementation for CBC/Radio - Canada's technology projects. Leading projects and managing end - to - end implementations with innovative solutions.