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

22 days ago
Related jobs
Promoted
Bitstrapped
Ontario, Canada

Implement data engineering technologies, primarily stream and batch processing systems with Apache Beam/Dataflow, Data Warehouses including BigQuery, queuing and message systems with Pub/Sub, Data Lakes with BigLake and Cloud Storage, application databases including SQL and Postgres, Redis, and Comp...

Promoted
RI-MUHC | Research Institute of the MUHC | #rimuhc,
Canada

The data engineer is responsible for architecting, implementing, and maintaining compute frameworks, analysis tooling, and/or model implementations used or created by the Data Science team to support the management and analysis of clinical and administrative data at the McGill University Health Cent...

Aritzia
Canada, Canada

As the Senior Data Visualization Engineer, you will:. The Senior Data Visualization Engineer has proven skills, education, and/or experience with:. The mission of the Data & Analytics Department is to provide the business with actionable and accurate information to enable data-informed decision-maki...

Zonda
Canada Remote
Remote

As a Senior Data Engineer, you will play a crucial role in designing, implementing, and optimizing our data infrastructure. Zonda is looking for a passionate Senior Data Engineer to evolve and expand our team. Work closely with data engineering to design and implement data models that align with bus...

Rackspace
Remote, Canada
Remote

We are seeking a highly skilled and experienced Senior Big Data Engineer to join our dynamic team. This role involves working in Java, and working on Machine Learning pipelines for data collection or batch inference. Leverage GCP for scalable big data processing and storage solutions. Proven experie...

Great Canadian Gaming Corp.
Canada, Canada

Senior Data Analyst / Engineer Consultant - Edmonton, AB. Experience with real-time data ingestion and processing using tools like Azure Stream Analytics, especially for pushing data into the data lake in near-real-time. Knowledge of using Azure Databricks or Synapse for data processing, transformat...

Insight Global
Guelph, Ontario

Insight Global is on the lookout for a seasoned Senior Data Engineer to join the data organization of one of Canadas largest insurance companies. Senior/Lead Data Engineer with a focus on Azure and Databricks. This pivotal role involves providing hands-on engineering leadership, focusing on the desi...

Lime
Canada

The Data Engineering team at Lime is responsible for ingesting, transforming and making available timely, high-quality data that powers analytics, bookkeeping and visibility for a wide range of customers. Implement data governance policies and ensure data security and compliance. You have a strong d...

Faire
Canada

Our experienced data scientists and machine learning engineers are developing solutions related to discovery, ranking, search, recommendations, ads, logistics, underwriting, and more - all with the goal of helping local retail thrive. Our team already includes experienced Data Scientists and Machine...

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