Senior Data Engineer

3 months ago


Waterloo, Canada Ontario Teachers Insurance Plan (OTIP) Full time
Job Description

What You’ll Do:

Reporting to the Senior Manager – Data Management, you’ll be accountable for building, maintaining and enhancing Azure data pipelines for various analytical and operational use cases, The Senior Data engineer is also responsible for leading the delivery of Data migration, Data warehousing and Master data management solutions in Azure cloud. Additionally, the Senior Data Engineer is also responsible for coaching and mentoring junior staff and team members. 

The core parts of your role will be to: 

  • Develop Data pipelines using Azure Data platform stack (Azure data factory, Databricks, Azure logic apps, ADLS Gen2)
  • Design Data Models for Operational and Analytical reporting 
  • Implement CI/CD pipelines that enables automated code deployment
  • Convert Existing SSIS Packages to ADF and craft cloud native solutions for existing and new Datawarehouse 
  • Monitor Data Pipelines, making sure pipelines run within SLA ensuring robustness and security  
  • Support the delivery of data architecture and solutions for critical platform portfolio projects in collaboration with business and Technology stakeholders
  • Lead Data Migration from On-Prem to Cloud ensuring solutions adhere to OTIP Architecture    
  • Lead and mentor Data Engineers 
  • Effectively Collaborate with various teams and partners within the Organization 
  • Support compliance with data stewardship standards and data security procedures
     

Qualifications

Let’s Talk About You: 

This is the unique blend of skills and experience we would love to see in an ideal candidate:

  • A bachelor's degree, preferably in Computer Science, Information Systems Management, Engineering or similar discipline; supported by experience in a similar technical environment.
  • 5+ years of experience working as Data Engineer in Azure data platform
  • Hands on experience in developing and orchestrating pipelines using ADF
  • Must have successfully completed at least 1 Data migration from On-Prem to any Public Cloud
  • Solid understanding of relational databases, best practices around data manipulation, data storage and data modelling
  • Understanding of any Business Intelligence Reporting tool, preferably Power BI
  • Handson Experience in Microsoft Data Technologies like SSIS, SSRS, SSAS
  • Strong technical skills in SQL, Python, Spark
  • Knowledge or Experience in Azure DevOps, ADO and Azure Databricks is an asset
  • Highly analytical individual with advanced problem-solving skills and strong attention to detail.
  • Capable of delivering on multiple competing priorities with little supervision.
  • Excellent verbal and written communication skills
  • Experience working in Scrum/Agile delivery methodologies is an asset
  • Azure Certifications

We also consider your potential. If you know you have what it takes to do the job, but your experience doesn’t exactly match the qualifications above, we encourage you to apply and provide us with more details about why you think you would be a great fit.



Additional Information

Some of the Perks We Offer:

We offer best-in-class pension and benefits, total reward programs and comprehensive mental wellness supports to set you up for every success in and outside of work. Here are just some of the reasons you’ll love working here:

  • Rewarding salary and bonuses that truly value your dedication
  • Industry-leading group benefits with 100% premium coverage (excluding LTD) that start on your first day
  • Defined benefit pension plan for a financially confident retirement
  • 100% coverage of approved continuing education and licensing fees (including RIBO courses in Ontario)
  • Access to a wealth of learning resources, including LinkedIn Learning for professional development
  • Flexible work-from-home and hybrid options
  • Unlock your potential with opportunities for advancement

Let’s work together If you are interested in this opportunity, please apply online.

OTIP and its group of companies strive to create an accessible and inclusive work environment where everyone is treated with respect and dignity. Upon individual request, we will endeavor to remove any barrier to the recruitment and selection processes and provide accommodations for persons with disabilities.

As a business, we protect what matters most to our members. As an employer, we value what matters most in our workplace. Together, this includes fostering a diverse, equitable and inclusive environment for all. We are committed to learning and evolving so we can continue to celebrate what makes us special. You are who you are, and our differences are what make us unique.

We are an equal opportunity employer and encourage applications from all qualified individuals. We thank all applicants for their interest; however, only candidates selected for an interview will be contacted.

#LI-Remote, #LI-Hybrid


  • Senior Data Engineer

    4 weeks ago


    Waterloo, Ontario, Canada Sun Life Full time

    About the Role:We are seeking a highly skilled Senior Data Engineer to join our team at Sun Life. As a Senior Data Engineer, you will play a key role in designing and implementing data models that represent our key business entities, ensuring high levels of data quality and integrity, and collaborating with stakeholders to deliver data products that meet...

  • Senior Data Engineer

    1 month ago


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

    About the RoleWe are seeking a highly skilled Senior Data Engineer to lead our Data Lake team in designing and implementing end-to-end data pipelines using advanced data engineering skills. The ideal candidate will possess expertise in big data and cloud computing to ensure solutions are scalable, efficient, and effective.Key ResponsibilitiesLead the...


  • Waterloo, Canada Manulife Financial Corporation Full time

    The OpportunityAs a Senior Data Science Engineer, you will take a leading role in designing and delivering AI/Advanced Analytics solution in cloud-based production environments to business; be accountable for delivering business value with data by focusing on key corporate objectives, including port


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

    About the RoleWe are seeking an accomplished Senior Data Engineer Lead to spearhead our Data Engineering team, focusing 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 ensure...

  • Senior Data Engineer

    1 month ago


    Waterloo, Ontario, Canada Ontario Teachers Insurance Plan (OTIP) Full time

    Job Title: Senior Data EngineerWe are seeking a highly skilled Senior Data Engineer to join our team at Ontario Teachers Insurance Plan (OTIP). As a key member of our data engineering team, you will be responsible for designing, building, and maintaining large-scale data pipelines using Azure data platform stack.Key Responsibilities:Develop and implement...


  • Waterloo, Ontario, Canada Manulife Insurance Malaysia Full time

    Senior Data Science Engineer (Salesforce)The OpportunityAs a Senior Data Science Engineer, you will play a key role in designing and delivering AI/Advanced Analytics solutions in cloud-based production environments to drive business value. Your focus will be on key corporate objectives, including portfolio optimization, expense efficiency, growth...

  • Senior Data Engineer

    6 months 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

    4 weeks ago


    Waterloo, Ontario, Canada Sun Life Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our team at Sun Life. As a Data Engineer, you will play a key role in designing, building, and maintaining our data infrastructure. Your primary responsibility will be to ensure the accuracy, reliability, and performance of our data systems.Key Responsibilities:Design and implement data...


  • Waterloo, Ontario, Canada McAfee, LLC Full time

    We are seeking a seasoned analytical leader to join our Enterprise Data Platform team as a Senior Data Architect, reporting to the Capability Lead – Data Architecture. As a member of McAfee's enterprise data architecture team, you will manage data platform architecture on the Databricks platform.Job DescriptionData lakehouse modeling and designDimensional...


  • Waterloo, Ontario, Canada Altair Engineering Full time

    Job Title: Senior Software Development EngineerWe are seeking a skilled Senior Software Development Engineer to join our team at Altair Engineering in Waterloo, ON. This is a contract position.The successful candidate will be responsible for developing and managing various pieces of software that run on multiple components in vehicles to capture, aggregate,...


  • Waterloo, Canada Manulife Insurance Malaysia Full time

    Senior Data Science Engineer (Salesforce)The OpportunityAs a Senior Data Science Engineer, you will take a leading role in designing and delivering AI/Advanced Analytics solutions in cloud-based production environments to business; be accountable for delivering business value with data by focusing on key corporate objectives, including portfolio...


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

    p>The OpportunityAs a Senior Data Science Engineer, you will take a leading role in designing and delivering AI/Advanced Analytics solution in cloud-based production environments to business; be accountable for delivering business value with data by focusing on key corporate objectives, including portfolio optimization, expense efficiency, growth...

  • Senior Data Architect

    3 weeks ago


    Waterloo, Canada McAfee, LLC Full time

    Role Overview: We are seeking a seasoned analytical leader to join our Enterprise Data Platform team as a Senior Data Architect, reporting to the Capability Lead – Data Architecture. As a member of McAfee’s enterprise data architecture team, you will manage data platform architecture on the Databricks platform. This role requires a deep understanding...

  • Senior Data Scientist

    2 weeks ago


    Waterloo, Ontario, Canada CARTA Full time

    About the RoleCarta is seeking a talented Senior Machine Learning Engineer to join its team. As a key member of our data science team, you will play a crucial role in developing and implementing cutting-edge machine learning models to power our products. Your expertise in machine learning and data analysis will help drive business growth and improve...

  • Data Engineer

    5 months ago


    Waterloo, Canada Epitec Inc Full time

    JOB SUMMARY FOR Data Engineer: The Fully Networked Vehicle Analytics Data team is looking for a passionate team member to join the organization. Our mission is to provide the best possible user experience for our customers, by providing invaluable wisdom from data to engineering, sales, and executive decision makers. POSTION IS HYBRID ...


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

    Our team has an immediate Co-op opening for a Software Engineer.Responsibilities:C++ software development for POC projects.Supports senior researchers on a variety of research-oriented projects.What you’ll bring to the team:Strong C/C++ programming abilities and software engineering skills.C++ development experience in a Linux environment.Excellent...


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

    Job OverviewHuawei Technologies Canada Co., Ltd. is seeking a highly skilled Data Science Engineer to join our team.About the RoleWe are looking for an experienced Data Science Engineer to design, implement, and benchmark AI models and algorithms for proof-of-concept development.In this role, you will work closely with senior researchers on various...


  • Waterloo, Ontario, Canada Mcafee Full time

    Senior Data Architect - Remote Position in CanadaWe are seeking an analytical leader to join our Enterprise Data Platform team as a Senior Data Architect. As a key member of the team, you will be responsible for managing data platform architecture on the Databricks platform.This role requires a deep understanding of data lakehouse modeling and design,...


  • Waterloo, Canada Manulife Insurance Malaysia Full time

    Senior Data Science Engineer (Salesforce)The OpportunityAs a Senior Data Science Engineer, you will take a leading role in designing and delivering AI/Advanced Analytics solutions in cloud-based production environments to business; be accountable for delivering business value with data by focusing on key corporate objectives, including portfolio...


  • Waterloo, Ontario, Canada CARTA Full time

    Unlock the Power of Equity OwnershipCarta is a platform that helps people manage equity, build businesses, and invest in the companies of tomorrow. Our mission is to unlock the power of equity ownership for more people in more places.We are looking for a Senior Machine Learning Engineer to join our team. As a key member of our data science team, you will...