Senior Data Engineer

Ontario Teachers Insurance Plan; Waterloo; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading company is seeking a Senior Data Engineer to enhance Azure data pipelines and lead data migration projects. The role involves designing data models, implementing CI/CD pipelines, and mentoring junior engineers. Join a supportive environment that values your contributions and offers excellent benefits.

Benefits

Rewarding salary and bonuses

100% premium coverage for group benefits

Defined benefit pension plan

100% coverage of continuing education fees

Access to LinkedIn Learning

Flexible work-from-home options

Opportunities for advancement

Qualifications

• 5+ years of experience as Data Engineer in Azure data platform.
• Hands-on experience in developing and orchestrating pipelines using ADF.
• Must have completed at least 1 data migration from on-prem to cloud.

Responsibilities

• Build and maintain Azure data pipelines for analytical and operational use cases.
• Lead data migration and data warehousing solutions in Azure cloud.
• Mentor junior staff and collaborate with various teams.

Skills

Analytical Skills

Problem Solving

Communication

Education

Bachelor's Degree in Computer Science

Tools

SQL

Python

Spark

Power BI

SSIS

SSRS

SSAS

Azure DevOps

Azure Databricks

Job description

With every job, there’s always the question of “why”. Why join a company? Why be part of their mission? Here, the why is easy. It’s because at some point, we’ve all needed someone there for us.

At the OTIP Group of Companies (OGC), we believe that something special happens when employees feel valued for the work they do, supported as the people they are, and included in the very fabric of the organization : they bring their best to work every day. And that's why we mean it when we say we put our people at the centre of everything we do. Join us as we grow our way into a future that reimagines what it means to deliver meaningful benefits support and service.

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 :

• Design data models for operational and analytical reporting
• Implement CI / CD pipelines that enable automated code deployment
• Convert existing SSIS packages to ADF and craft cloud native solutions for existing and new data warehouse
• 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
• Hands-on 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

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.

J-18808-Ljbffr

Create a job alert for this search

Senior Data Engineer • Waterloo, Region of Waterloo, Canada