Certinia Developer owning Softchoice’s customized PSA platform and Salesforce components. Designing SAP, SAP Concur, and MuleSoft integrations for this IT solutions provider.
About the role
- 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
- A friendly, collaborative, and inclusive culture
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Hotfix Developer resolving urgent production issues for Paystone, a North American payments and software company. Investigating transactional data, coding fixes, and deploying reliable client solutions.
LP
Banking Associate-EFTR
LinkedIn Recruiter Post
Execute and support EFTR regulatory reporting activities, including data remediation and compliance. Ideal for professionals with AML reporting experience and strong data skills.
LP
Senior Software Engineer – AI & Full Stack
LinkedIn Recruiter Post
Senior Software Engineer role at Fable, focusing on AI and full - stack development. Build AI - first products for accessibility, owning problems end - to - end.
LP
ETL Tester
LinkedIn Recruiter Post
Seeking a skilled ETL Tester to independently lead testing efforts for a banking client, managing functional and automation testing in an Agile environment.
Integration Developer building Apache Camel, Kafka, and OpenShift solutions for PLATO, Canada’s Indigenous - owned software testing and technology services company. Delivering secure enterprise integrations, APIs, and automated data exchange.
Director of Engineering co - leading Lazer’s AI - powered forward - deployed engineering team. Guiding architecture, talent, client engagements, AI standards, and technical delivery at a digital product studio.
z/OS Connect Systems Programmer supporting TD’s mainframe banking infrastructure. Maintaining, testing, and deploying z/OS Connect and IMS systems with rotating on - call support.
LP
HR Transformation Lead
LinkedIn Recruiter Post
Lead HR transformation and Workday readiness at Lifemark Health Group, standardizing processes and exploring AI opportunities.
LP
HR Executive Administrative Assistant
LinkedIn Recruiter Post
Provide senior administrative and operational support to HR Branch, including executive support, budget coordination, event planning, and program coordination for a provincial government agency in Toronto.