Search jobs > Waterloo, ON > Senior data engineer

Senior Data Engineer

Ontario Teachers Insurance Plan (OTIP)
Waterloo, Ontario, Canada
$95 an hour (estimated)
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

4 days ago
Related jobs
Promoted
expert pick
Canada

Numberly is looking for a Senior Data Engineer to join its dedicated Data team. As a Senior Expert Data Engineer you will:. Numberly leverages the latest advances in data processing, analysis, and media activation in a virtuous cycle of business competitiveness, enhanced privacy, and data protection...

Promoted
Columbus Zoo and Aquarium
Canada

Senior Data Scientist / ML Engineer - Sports Betting Startup. We are hiring a Senior Machine Learning Engineer to be involved in designing and building real-time odds machine learning models and data systems focused on live time betting. Kero focuses on building proprietary algorithms that ingest re...

Promoted
Stackitrecruitment
Canada

Demonstrated hands-on experience with a data build tool (DBT) for data transformations and Snowflake (or similar cloud data platforms) for managing large-scale data pipelines. Data Engineer with a track record of successfully delivering data solutions in production environments. Familiarity with bes...

Promoted
Partium
Canada

We are seeking an experienced Senior Data Engineer (f/m/x) who is not only driven by the quality of his/her/their work, but is also eager to learn and share knowledge within our team. Drive the transition of Partium's data efforts from traditional models to a big-data-centric approach, fostering a m...

Aritzia
Canada, Canada

As the Senior Data Visualization Engineer, you will combine your deep understanding of our digital experience, with your passion for data visualization and user experience to streamline, optimize, and innovate analytical interfaces that are easily absorbed, heavily adopted and drive high quality dec...

Doximity
Remote, Canada
Remote

Collaborate with product managers, data analysts, and machine learning engineers to develop pipelines and ETL tasks in order to facilitate the extraction of insights. You have developed maintainable data pipelines with them. You are experienced in creating automated testing, applying design patterns...

Yelp
Canada
Remote

Develop and maintain the content and structure within data storage solutions including data lakes and data warehouses, ensuring data is accurately organized, enriched, and ready for analysis. In this role, you'll design and build robust data pipelines to manage large volumes of data, ensuring seamle...

Aritzia
Canada, Canada

As the Senior Data Platform Engineer, you will leverage modern software development and operational practices while following an "automation first" approach to support the acquisition, ingestion, transformation, and management of our data. As the Senior Data Platform Engineer, you will:. The Senior ...

Ontario Teachers Insurance Plan (OTIP)
Waterloo, Ontario

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

Cloudbeds
Canada
Remote

Proven experience as a big data engineer or a similar role, with a deep understanding of big data technologies, frameworks, and best practices. Building and maintaining data infrastructure, including data lakes, data warehouses, and real-time streaming platforms. Developing and optimizing data pipel...