Junior Ssis/ssas Develope

2 weeks ago

Toronto, Canada Sun Life Full time

You 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.

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, Toronto

**What Will You Do?**
- 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
- Implement system and operational controls to ensure data integrity of reports and analyses produced in the department

**What Do You Need To Succeed?**
- University degree in Computer Science, Mathematics, or Statistics or College diploma in Information Technology or Computer Programming
- 3+ years experience in designing ETL solutions and packages in SSIS
- 3+ years experience with Visual Basic or C#
- 3+ years experience with SSAS, SSMS and SQL queries
- Expertise in data analysis
- Strong knowledge of MS Excel and MS Access including Visual Basic for Applications (VBA)

**Assets**
- Understanding of Life Insurance and/or Segmented Funds
- Knowledge of projects and systems development methodologies
- Experience with SSRS and Tableau

**Unique Requirements**
- Must be able to obtain Reliability Status through the Government of Canada before a start date can be confirmed (includes a background check with fingerprinting by the RCMP)

**What's In It For You?**
- Time off giving you the flexibility to focus on the moments that matter. 15 days' 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 2023 Best Workplaces in Ontario by Great Place to Work® Canada
- Sun Life ranked one of the 2023 Global 100 Most Sustainable Corporations in the World on the Corporate Knights’ 2023

At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

**Salary Range**:
61,000/61 000 - 101,000/101 000

**Job Category**:
IT - Application Development

**Posting End Date**:
15/11/2023

  • SSIS & SQL Developer

    Found in: Appcast CA A2 P - 2 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    About TCS TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed...

  • SSIS & SQL Developer

    Found in: Appcast CA C2 Glassdoor - 2 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    About TCS TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed...

  • SSIS & SQL Developer

    Found in: Whatjobs CA C2 - 2 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    About TCS TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and...

  • Specialized IT Consultant

    15 hours ago

    Toronto, Canada AMISEQ Full time

    Specialized IT Consultant Toronto, ON 12 Months MUST HAVES: Demonstrated deep Microsoft stack experience (10 Years) with at least past 4 years of Microsoft Azure Data Factory experience. Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools. Experience with migration from...

  • Specialized IT Consultant

    2 days ago

    Toronto, Canada AMISEQ Full time

    Specialized IT Consultant Toronto, ON 12 MonthsMUST HAVES: Demonstrated deep Microsoft stack experience (10 Years) with at least past 4 years of Microsoft Azure Data Factory experience. Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools. Experience with migration from Cognos/Informatica...

  • Specialized IT Consultant

    3 days ago

    Toronto, Canada AMISEQ Full time

    Specialized IT Consultant Toronto, ON 12 Months MUST HAVES: Demonstrated deep Microsoft stack experience (10 Years) with at least past 4 years of Microsoft Azure Data Factory experience. Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools. Experience with migration from...

  • Specialized IT Consultant

    16 hours ago

    Toronto, Canada AMISEQ Full time

    Specialized IT Consultant Toronto, ON 12 Months MUST HAVES: Demonstrated deep Microsoft stack experience (10 Years) with at least past 4 years of Microsoft Azure Data Factory experience. Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools. Experience with migration from...

  • Specialized I&IT Consultant

    Found in: Talent CA C2 - 1 week ago

    Toronto, Canada Global Pharma Tek Full time

    Title Specialized IT Consultant - Intermediate Location: Toronto, ON (Hybrid) Duration: Business Days + Possible extension Job Description: Design, develop, and maintain data pipelines using Azure Data Factory Services for data ingestion, transformation, and integration. Develop ETL processes using SQL Server Integration Services...

  • Stage Consultant Technique IT H/F

    Found in: Jooble CA O C2 - 3 days ago

    Toronto, ON, Canada AMISEQ Full time

    Specialized IT Consultant Toronto, ON 12 Months MUST HAVES: Demonstrated deep Microsoft stack experience (10 Years) with at least past 4 years of Microsoft Azure Data Factory experience. Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools. Experience with migration from...

  • Specialized IT Consultant

    Found in: Appcast CA A2 P - 3 days ago

    Toronto, Canada AMISEQ Full time

    Specialized IT Consultant Toronto, ON12 MonthsMUST HAVES:Demonstrated deep Microsoft stack experience (10 Years) with at least past 4 years of Microsoft Azure Data Factory experience. Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools.Experience with migration from Cognos/Informatica to...

  • Specialized IT Consultant

    Found in: Appcast CA C2 Glassdoor - 18 hours ago

    Toronto, Canada AMISEQ Full time

    Specialized IT Consultant Toronto, ON12 MonthsMUST HAVES:Demonstrated deep Microsoft stack experience (10 Years) with at least past 4 years of Microsoft Azure Data Factory experience. Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools.Experience with migration from Cognos/Informatica to...

  • Specialized IT Consultant

    Found in: Whatjobs CA C2 - 18 hours ago

    Toronto, Canada AMISEQ Full time

    Specialized IT Consultant Toronto, ON 12 Months MUST HAVES: Demonstrated deep Microsoft stack experience (10 Years) with at least past 4 years of Microsoft Azure Data Factory experience. Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools. Experience with migration from...

  • Data Analyst

    Found in: Jooble CA O C2 - 3 days ago

    Toronto, ON, Canada Knewin Full time

    Data Specialist Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, and works to improve the structure and efficiency of an organization's I&IT systems. The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information...

  • Specialized IT Consultant

    Found in: Jooble CA O C2 - 3 days ago

    Toronto, ON, Canada AMISEQ Full time

    Specialized IT Consultant Toronto, ON 12 Months MUST HAVES: Demonstrated deep Microsoft stack experience (10 Years) with at least past 4 years of Microsoft Azure Data Factory experience. Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools. Experience with migration from...

  • Data Specialist

    Found in: Talent CA C2 - 1 week ago

    Toronto, Canada GTT, LLC Full time

    Data Specialist Job Responsibilities: Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, and works to improve the structure and efficiency of an organization's I&IT systems. The I&IT Consultant may be used to provide strategic guidance to organizations with regard...

  • Data Specialist

    Found in: Jooble CA O C2 - 3 days ago

    Toronto, ON, Canada Knewin Full time

    Data Specialist Job Responsibilities: Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, and works to improve the structure and efficiency of an organization's I&IT systems. The I&IT Consultant may be used to provide strategic guidance to organizations...

  • Data Specialist

    16 hours ago

    Old Toronto, Canada Knewin Full time

    Data Specialist Job Responsibilities: Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, and works to improve the structure and efficiency of an organization's I&IT systems. The I&IT Consultant may be used to provide strategic guidance to organizations with regard to...

  • Data Specialist

    17 hours ago

    Old Toronto, Canada Knewin Full time

    Data Specialist Job Responsibilities: Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, and works to improve the structure and efficiency of an organization's I&IT systems. The I&IT Consultant may be used to provide strategic guidance to organizations with regard to...

  • RQ06212 - Specialized IT Consultant - Intermediate

    Found in: Talent CA C2 - 1 week ago

    Toronto, Canada Maarut Inc Full time

    Responsibilities:Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, works to improve structure and efficiency of an organization’s I&IT systems.The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information Management & IT...

  • RQ06212 - Specialized IT Consultant - Intermediate

    Found in: Talent CA C2 - 1 week ago

    Toronto, Canada Maarut Inc Full time

    Job DescriptionResponsibilities:Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, works to improve structure and efficiency of an organization’s I&IT systems.The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information...