Remote Data analyst Jobs in Waterloo, ON

Job Description

:

Senior Data Engineer

We are currently looking for a Senior Data Engineer - with a passion for turning disparate streams of data into organized and actionable analytics services and insights. As a Data Engineer on the Data Engineering and Operations team, you will be joining a group of hardworking and savvy innovators who has made it their mission to find new ways to glean value out of rapidly increasing volumes of operational data in Canadian Operations.

Role Summary:

Working within a diverse and motivated team of analytics professionals, the Senior Data Engineer will be instrumental in designing, implementing, and maintaining data pipelines and infrastructure to support our organization's data-driven decision-making processes, while also guiding and mentoring other Data Engineers.

Main Accountabilities:

• Design, develop, and maintain scalable data pipelines using AWS Glue, Kafka, and Step Functions.
• Implement and optimize ETL processes using tools like SSIS, Informatica, or Talend.
• Guide and mentor Data Engineers on best practices for ETL development and data sourcing.
• Create and maintain data models to support business intelligence and analytics initiatives.
• Collaborate with cross-functional teams to understand data requirements and deliver solutions.
• Ensure data quality, security, and compliance with industry standards and regulations.
• Troubleshoot data-related issues and implement solutions.
• Stay current with emerging technologies and best practices in data engineering.

Competencies:

• Bachelor’s degree in computer science, Information Technology, or related field.
• 5-10 years of experience in ETL design, modeling, and development.
• Strong proficiency in SQL and Python programming.
• Experience with AWS services, particularly Glue, Step Functions, and other data-related services.
• Expertise in data warehousing concepts and methodologies.
• Proficiency in ETL tools (e.g., Informatica, Talend, SSIS).
• Experience with various database systems and data formats.
• Familiarity with Kafka and stream processing concepts.
• Excellent problem-solving and analytical skills.
• Strong communication and leadership abilities.

Advantages:

• Experience with big data technologies such as Hadoop, Spark, or Hive.
• Knowledge of data visualization tools (e.g., Tableau, Power BI).
• Familiarity with agile development methodologies.
• AWS certifications (e.g., AWS Certified Data Analytics - Specialty).

What We Offer:

• Comprehensive benefits package and participation in various incentive plans.
• Opportunities for professional growth and development.
• Flexible work arrangements and work-life balance
• Chance to work on impactful projects that drive business success.
• We are proud to be recognized as:-
• 2022, 2023, and 2024 Best Workplaces in Canada by Great Place to Work® Canada.
• Best Workplaces for Hybrid Work 2022.
• Best Workplaces for Professional Development in Canada 2022.
• "Best Places to Work" by Glassdoor, 2021 and 2023.

Unique Requirements:

This role requires Reliability Status Clearance. In addition to a law enforcement inquiry and a credit check, as part of your application, the Government of Canada will ask if you lived or travelled outside of Canada for 6-consecutive months during the last 5 years, and you must account for all activities during this time.

Important: Obtaining Reliability Status Clearance within a reasonable amount of time is a condition required to start employment for this role at Sun Life.

Also, As this position is posted in several locations, we specify that bilingualism (French, English, both oral and written) is required for Quebec only for the frequent interactions with English and French-speaking colleagues or internal partners across Canada or worldwide.