Senior Data Engineer

3 weeks ago


Waterloo, Canada Sun Life Full time

Job Description

:

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.

Working within a diverse and motivated team of analytics professionals, the Senior Data Engineer will lead the development of efficient data capture and transformation processes and complex data models that form the core of a new generation of analytics services and self-serve solutions for our customers in Canadian Operations.

What will you do?

Lead development of new batch/low-latency analytical solutions that leverages both traditional and emerging technologies Design, develop and implement highly scalable data capture and transformation processes Create effective ETLs/ELTs to move large volumes of data from various operational systems to dimensional data models for analytics consumption Act as principal designer and reviewer for new data models, make data architectural decision, and provide coaching on data modeling and process design Expand and grow data existing platform capabilities to solve new data problems and challenges Ensure all automated processes preserve data integrity by managing the alignment of data availability and integration processes Support quantitative analysts and data scientists with data discovery and rapid assembly of large data sets from disparate sources Identify opportunities for new data acquisition and new uses for existing data resources Research and make recommendations for new data management technologies and software engineering practices. Collaborate on decisions around the use of new tools and practices Perform quality assurance and testing according to risk assessment guidelines to minimize operational, reputation, and legal risk. Define data retention policy, establish data governance best practice, and create automated anomaly detection services Document and update business continuity and disaster recovery procedures. Engage in ongoing collaboration with data architects, modellers and other members to achieve common goals. Provide guidance to development teams regarding best practices and design patterns for analytics solutions. Coach and provide guidance to junior team members Produce and maintain support documentation for ongoing operations. Act as Tier-2/3 support to troubleshoot and resolve technical issues with production data models and services

What will you need to succeed?

University degree in Computer Science, Software Engineering, or equivalent. Experience with hybrid data environments that leverage both distributed and relational database technologies to support analytics services Solid understanding of data warehousing principles, architecture and its implementation in complex environments. Hands-on experience with development of ELT/ETL processes in traditional and distributed environments Experience as designer of complex Dimensional data models for analytics services Experience with development for Microsoft SQL Server Analysis Services or equivalent technologies Experience with various testing methodologies and user acceptance testing. Solid skills in SQL, Python, C++, Java and other languages used in data manipulation Experience with AWS Glue and Big Data technology Experience with processing large datasets from multiple sources. Ability to operate effectively and independently in a dynamic, fluid environment. Strong verbal and written communications skills with experience in relating complex concepts to non-technical users. Demonstrated ability to exchange ideas and convey complex information clearly and concisely Proven ability to lead and drive projects and assignments to completion Experience with optimization and tuning of large data extracts for Tableau Familiarity with Agile development practices. Understanding of ITIL processes Incident/Change/Release management methodologies. Knowledge of Insurance or Financial Services industry.

Unique Requirements

The candidate selected for this role is required to attain Canadian Reliability Security Clearance (administered by submitting fingerprints to the RCMP, who then conduct min. 5 year history checks)

To see if you are eligible for this clearance, please review the section 201 on the Federal Government site ()

What’s in it for you?

Great Place to Work® Certified in Canada and the US - 2022 Great Place to Work® award for Best Workplaces for #HybridWork 2022 Named “Best Places to Work” by Glassdoor - 2021 Canada Award for Excellence for Mental Health at Work  2021 Flexible hybrid work model including in-country work-from-home if you prefer.
  • Senior Data Engineer

    3 weeks ago


    Waterloo, Canada Sun Life Financial 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,...

  • Senior Data Engineer

    3 weeks ago


    Waterloo, Canada Sun Life Financial 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,...

  • Senior Data Engineer

    3 weeks ago


    Waterloo, Canada Sun Life Financial 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,...

  • Senior Data Engineer

    23 hours ago


    Waterloo, Canada Company 1 - The Manufacturers Life Insurance Company Full time

    Description We are seeking a dynamic and well versed Senior Data Engineer to orchestrate our Data Lake team, with a focus on data curation, report creation, and data feed management. The ideal candidate will possess the qualifications to champion the development and implementation of end-to-end data pipelines using advanced data engineering skills to...

  • Senior Data Engineer

    3 weeks ago


    Waterloo, ON, Canada Sun Life Financial 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,...

  • Senior Data Engineer

    3 weeks ago


    Waterloo, ON, Canada Sun Life Financial Full time

    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. Discover how you can make a difference in the lives of individuals, families and communities around the world. We are currently looking for a Senior Data...


  • Waterloo, Canada RPMGlobal Full time

    Transforming the Future with Convergence of Simulation and Data Software Engineer Senior Job Summary: Our client in Waterloo, ON is looking for a Software Engineer Senior. This is a contract position. What You Will Do: If you would like to work with a


  • Waterloo, ON, Canada Carta, Inc. Full time

    The Problems You'll Solve We welcome leaders who can lead diverse, thoughtful, and driven engineers while balancing technical direction, collaboration, and people development. As a Senior Engineering Manager, here are some of the exciting problems you'll solve: Lead: Mentor, grow, and empower your team. Own: Be responsible for the availability,...

  • Senior QA Engineer

    2 days ago


    Waterloo, Canada Targeted Talent Full time

    We are looking for an experienced Senior QA Engineer for our client. This is a permanent position that is completely remote! Our client is a fintech company based out of Vancouver.You'll have the opportunity to work on an amazing platform that combines Data Analytics, and complex integration in ERP systems to deliver cutting edge financial data that is...


  • Waterloo, Canada Geotab Full time

    Who you are: We are always looking for amazing talent who can contribute to our growth and deliver results! Geotab is seeking a Senior Support Engineer for our Embedded Engineering Support team who will provide stellar escalated engineering support and customer service to our network of Geotab Partners & internal stakeholders. If you love technology, and...


  • Waterloo, Canada Geotab Full time

    Who you are: We are always looking for amazing talent who can contribute to our growth and deliver results! Geotab is seeking a Senior Support Engineer for our Embedded Engineering Support team who will provide stellar escalated engineering support and customer service to our network of Geotab Partners & internal stakeholders. If you love technology, and are...


  • Waterloo, Canada McAfee Full time

    Role Overview:As the leader of McAfee’s Enterprise Data Analytics team, you will drive ownership of data insights at McAfee. You will manage McAfee’s data curation and governance function and lead a high-performing, cross-functional team of data Engineers and Technical Data Stewards to deliver data of high quality and reliability.This is a remote...

  • Data engineer

    20 hours ago


    Waterloo, Canada Société Financière Manuvie Full time

    Nous sommes un fournisseur de services financiers qui s’emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie en nous appuyant sur des valeurs, et ce, dans l’ensemble de nos...

  • Data engineer

    18 hours ago


    Waterloo, Canada Société Financière Manuvie Full time

    Nous sommes un fournisseur de services financiers qui s’emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie en nous appuyant sur des valeurs, et ce, dans l’ensemble de nos...

  • Data engineer

    18 hours ago


    Waterloo, Canada Société Financière Manuvie Full time

    Nous sommes un fournisseur de services financiers qui s’emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie en nous appuyant sur des valeurs, et ce, dans l’ensemble de nos...


  • Waterloo, Canada Equitable Life of Canada Full time

    Senior Technology Specialist, Data Developer Waterloo, ON, Canada Req #2203 Thursday, April 4, 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...

  • Co-op Engineer

    2 weeks ago


    Waterloo, Canada Huawei Technologies Canada Co., Ltd. Full time

    Our team has an immediate Co-op opening for an Engineer Responsibilities: Work closely with senior team members on one or more projects on data center network research.Will be working on technologies like RDMA stacks, Data Center Networking, and Cloud/Computing networks.What you’ll bring to the team: Bachelors/Masters student pursuing a degree in Computer...

  • Co-op Engineer

    2 weeks ago


    Waterloo, Canada Huawei Technologies Canada Co., Ltd. Full time

    Our team has an immediate Co-op opening for an Engineer Responsibilities: Work closely with senior team members on one or more projects on data center network research.Will be working on technologies like RDMA stacks, Data Center Networking, and Cloud/Computing networks.What you’ll bring to the team: Bachelors/Masters student pursuing a degree in Computer...

  • Co-op Engineer

    2 weeks ago


    Waterloo, Canada Huawei Technologies Canada Co., Ltd. Full time

    Our team has an immediate Co-op opening for an Engineer Responsibilities: Work closely with senior team members on one or more projects on data center network research.Will be working on technologies like RDMA stacks, Data Center Networking, and Cloud/Computing networks.What you’ll bring to the team: Bachelors/Masters student pursuing a degree in Computer...

  • Co-op Engineer

    3 weeks ago


    Waterloo, Canada Huawei Technologies Canada Co., Ltd. Full time

    Our team has an immediate Co-op opening for an EngineerResponsibilities:Work closely with senior team members on one or more projects on data center network research.Will be working on technologies like RDMA stacks, Data Center Networking, and Cloud/Computing networks.What you’ll bring to the team:Bachelors/Masters student pursuing a degree in Computer...