Application Analyst- Etl, Python

2 weeks ago

Waterloo, 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.

Do you want to build and maintain mission critical data processing and transformation systems that will help run one of Canada’s biggest financial institutions? Do you enjoy being part of a tight-knit, empowered team? Do you have experience writing data manipulation code in a cloud using Python and/or Pyspark? If so, we’d like to hear from you

We are looking for an Extract, Transform, and Load (ETL) Developer with a strong technical background and cloud experience to join the Corporate Application Solutions (CAS) team.

This is an exciting opportunity to be part of the IT organization dedicated to excellent customer service through digital transformation, supporting continuous learning, career growth and diversity.

**What will you do?**
- Provide ongoing support and maintenance of AWS Glue ETL and related integration components, including on-call support on a rotation basis, problem analysis, resolution, and escalation.
- Contribute to defining timetables, project plans and product roadmaps.
- Configure and install software products, patches, vendor releases in multiple environments.
- Enhance and support the Glue, Lambda, and ETL jobs.
- Provide recommendations and alternatives for system enhancements.
- Take complete ownership of work assignments and ensure the successful completion of assigned tasks.
- Create and maintain technical documentation for supported systems.
- Ensure Sun Life Information Security Policies and GCC are adhered to in any solution.
- Maintain effective communication with management, team members and the business.

**What you need to succeed**:

- Bachelor’s degree in computer science, computer engineering, or equivalent experience.
- 5+ years of experience working with complex technical environments involving multiple IT platforms. We use Windows, Unix, Linux, Cloud, and ETL technologies.
- 3+ years of experience creating ETL jobs using cloud technologies (e.g., Glue, Data Bricks).
- Experience in creating Python scripts using data libraries.
- Skill with Spark, PySpark, or Scala.
- Experience with Relational SQL (Oracle, PostgreSQL, SQL Server) databases.
- Strong knowledge of SQL query language - able to perform all CRUD operations.
- Experience in any object-oriented/object function scripting language, such as Python.
- Experience with Windows/Linux/Unix scripting languages.
- Proficient with the ITIL framework and processes such as Change, Incident, Problem and Configuration Management.

**Preferred Skills**:

- Experience with SFTP and TCP network protocols.
- Experience with integrating vendor packages into an established Production environment consisting of various technologies and platforms.
- Knowledge of Active Directory, Single Sign-On and Web Hosting concepts.
- Good understanding / hands-on experience with AWS data services - like Glue, Step function, Lambda, AWS Workflows, S3, Redshift, ODS.
- Experience in working with AWS SDK and integration with various AWS services.
- Hands-on experience with DevOps tools (e.g., Git, Jenkins, SourceTree, Ansible).
- Strong analytical and problem-solving skills with ability to analyze situations/problems systematically and deliver effective right-sized solutions in a timely manner.
- Strong organizational and planning skills.
- Excellent verbal and written communications skills.
- Experience with managing and coordinating team activities in a multi-site environment.

**Nice to have**:

- Experience with ETL development tools (PowerCenter, Informatica and/or SSIS).
- Experience with PowerShell scripting.
- Experience with Job schedulers (Control-M).
- Experience with Tableau reporting system.
- Experience with PostgreSQL.

**Notes/Unique requirements**:

- Occasional weekend and after-hours work.
- On-call support as part of a rotation.
- Occasional travel between Sun Life locations may be required depending on work assignments.
- 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).

LI- Remote

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 positi

  • Data Analyst

    3 days ago

    Waterloo, 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...

  • Data Analyst

    5 days ago

    Waterloo, Canada ThinkLP Full time

    **About ThinkLP** ThinkLP imagines a world where there is zero retail crime and all companies operate safely and effectively, ensuring all employees return home at the end of the day. At ThinkLP, we are helping to drive a loss prevention industry transformation with awesome loss prevention software. The innovative ThinkLP software platform has become an...

  • Google Cloud Platform Sme

    2 days ago

    Waterloo, Canada AstraNorth Full time

    **Skills and Responsibilities**: - GCP and GCP functionalities like running DAGs, troubleshooting when there is a failure, console, and all other features present in GCP tool. - Complex query writing, procedures, routines in Big Query. - Bigdata testing and tools. - Any automation experience on tables-to-tables comparison, files to table and file layout...

  • Data Analyst

    3 days ago

    Waterloo, Canada University of Waterloo Full time

    Overview: The Data Analyst will advance the School’s use of data to inform strategic, operational, and curriculum decision-making by School leadership. The Data Analyst is responsible for sourcing, understanding, consolidating, and analyzing student and other data about the School; for effectively communicating analyses and findings; and for making related...

  • Open Source Compliance Analyst

    3 days ago

    Waterloo, Canada BlackBerry Full time

    Worker Sub-Type: Regular **Job Description**: The BlackBerry Open Source Program Office is seeking talented individuals with an eye for details, and a passion for software quality. In this role, focusing on the development cycle, you will have the unique opportunity to work at the intersection of our product teams and supporting stakeholders to contribute...

  • IT Technical Data Analyst

    2 weeks ago

    Waterloo, Canada Descartes Full time

    **Descartes Unites the People and Technology that Move the World** The need for efficient, secure, and agile supply chains and logistics operations has become ever more critical and complex. By combining innovative technology, powerful trade intelligence and the reach of our network, Descartes helps get goods, information, transportation assets, and people...

  • Senior Test Automation Developer

    Found in: Jooble CA O C2 - 1 week ago

    Waterloo, ON, Canada The Bartech Group, Inc. Full time

    Contract CA$65 - CA$75 per hour Bartech Staffing is a leading engineering, technical and professional staffing firm, and our clients include some of the nation's biggest companies. Our client has engaged us to assist them in hiring a contract Automation Developer(Phone Connectivity) - Senior. Hourly pay range $ 64.Our client is looking for a dynamic...

  • Senior Test Automation Developer

    Found in: Jooble CA O C2 - 3 days ago

    Waterloo, ON, Canada Bartechstaffing Full time

    Bartech Staffing is a leading engineering, technical and professional staffing firm, and our clients include some of the nation's biggest companies. Our client has engaged us to assist them in hiring a contract Automation Developer(Phone Connectivity) - Senior. Hourly pay range $ 64.Our client is looking for a dynamic individual with automation development...

  • Architecte logiciel Python/Test

    Found in: Jooble CA O C2 - 1 day ago

    Waterloo, ON, Canada Onsemi Full time

    At onsemi, we help improve lives through silicon and software solutions every day. Our intelligent power and sensing technologies solve the world’s most complex challenges and lead the way in creating a safer, cleaner, and smarter world. We're developing leading-edge wireless-enabled MCUs, DSPs and software that sense and connect the world or help manage...

  • Junior Financial Analyst

    Found in: Talent CA 2 C2 - 2 weeks ago

    Waterloo, Canada CB Canada Full time

    Junior Financial Analyst - PROCOM KW is currently searching for a Junior Financial Analyst with experience in general accounting procedures and corporate finance principles.Junior Financial Analyst ResponsibilitiesDeveloping revenue estimates, operating plans / forecasts / reviews, OP (operatingplan/budget) and/or corporate reportingProviding...

  • 790465 - Early-career Environmental Data Technician

    2 weeks ago

    Waterloo, Canada Geosyntec Consultants Full time

    If you re looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you! We are seeking an **Early-Career Environmental Data Technician** to work with our team of consulting scientists and engineers in...

  • Data Specialist

    6 days ago

    Waterloo, Canada Karis Disability Services Full time

    **Permanent, Full Time** **Data Specialist** **40 hours/week** **Waterloo Office** The Data Specialist is responsible for creating and supporting data and analytics products by enabling data integrity across data sources at Karis Disability Services. This includes maintaining, transforming, and presenting data. Data maintenance includes documenting the...

  • Intermediate Testing Consultant

    Found in: Talent CA 2 C2 - 2 weeks ago

    Waterloo, Canada CB Canada Full time

    Intermediate Testing ConsultantOn behalf of our client in the Financial Services Sector, PROCOM is looking for an Intermediate Testing ConsultantIntermediate Testing Consultant – Job DescriptionWe are looking for a Testing Consultant with 3-5 years of experience and strong data testing skills. You will have a role in planning and executing testing for...

  • Application Risk and Compliance Analyst

    3 days ago

    Waterloo, 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...

  • CRM Analyst

    4 days ago

    Waterloo, Canada Wilfrid Laurier University Full time

    **Date**:May 31, 2023 **Location**: Waterloo, CA **Company**:Wilfrid Laurier University **Department**: Enrolment Services **Job Type**: Continuing **Full-time/Part-time**: Full Time (>=1249 hrs/year) **Campus**: Waterloo **Reports to**:Associate Registrar, Recruitment & Admissions **Employee Group**: WLUSA **Application Deadline**:June 6...

  • CRM Analyst

    3 days ago

    Waterloo, Canada Wilfrid Laurier University Full time

    **Date**:Feb 8, 2023 **Location**: Waterloo, CA **Company**:Wilfrid Laurier University **Department**: Enrolment Services **Job Type**: Continuing **Full-time/Part-time**: Full Time (>=1249 hrs/year) **Campus**: Waterloo **Reports to**:Associate Registrar, Recruitment & Admissions **Employee Group**: WLUSA **Application Deadline**:February 15,...

  • Business Analyst

    7 days ago

    Waterloo, Canada Serenia Life Financial Full time

    Are you looking for a supportive, collaborative workplace with great teams and inspiring leaders? You’ve come to the right place. We’re looking for ambitious people who share our values and want to make every day better for people around the world. If this sounds like you, and the opportunity below sounds exciting, we’d like to hear from you. **About...

  • Variable Compensation Analyst

    5 days ago

    Waterloo, Canada Open Text Corporation Full time

    **Variable Compensation Analyst**: - Req id: 39835- Waterloo, ON, CA**OPENTEXT** OpenText is a global leader in information management, where innovation, creativity, and collaboration are the key components of our corporate culture. As a member of our team, you will have the opportunity to partner with the most highly regarded companies in the world, tackle...

  • Financial Analyst Co-op

    6 days ago

    Waterloo, Canada Sun Life Full time

    Our student and new graduate programs offer a chance to explore Sun Life from the inside. You’ll make a difference in the lives of our customers and communities, while building the skills and experience that allow you to grow in a meaningful and rewarding way. **Length of term**:4 months (Summer 2023) **Hybrid/Remote**: This co-op opportunity is...

  • Actuarial Analyst

    Found in: Talent CA C2 - 2 weeks ago

    Waterloo, Canada Equitable Life of Canada Full time

    Actuarial Analyst Waterloo, ON, Canada Req #2234 Tuesday, April 23, 2024 At Equitable, we realize that your work life is not just about performing a job; it's about being part of a workplace that helps you grow and reach your full potential. Within our friendly and collaborative work environment, we recognize that the key to our growth and success is a...