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
Staff Developer leading Azure data platform integration, operations, and governance for AtkinsRéalis’ engineering and nuclear services. Driving Orb platform delivery, releases, incident resolution, and technical coaching.
Senior Java developer building scalable, real - time routing engines for Miratech’s enterprise contact - center platforms. Designing distributed services, APIs, and integrations across CX technologies.
Senior developer building scalable Java routing engines for Miratech’s enterprise contact - center clients. Designing real - time interaction routing across distributed, cloud - native CX platforms.
Senior developer building scalable Java routing engines for Miratech’s enterprise contact - center platforms. Designing real - time interaction routing, distributed services, APIs, and CX integrations.
Senior developer building scalable Java routing engines for Miratech’s enterprise contact - center platforms. Designing real - time interaction distribution across voice, digital channels, queues, skills, and agents.
Senior Java developer building scalable real - time routing engines for Miratech’s enterprise contact - center platforms. Designing distributed services, APIs, and integrations for voice and digital interaction delivery.
Senior Routing Engine Developer building scalable Java and Spring Boot routing engines for Miratech’s enterprise contact center platforms. Designing real - time interaction distribution across channels, queues, skills, and agents.
Senior project engineer leading aerospace research and technology initiatives at SOGECLAIR. Managing aircraft development projects, schedules, budgets, risks, and change governance.