Senior Data Engineer

Logo of OTIP (Ontario Teachers Insurance Plan)

OTIP (Ontario Teachers Insurance Plan)

πŸ“Remote - Canada

Job highlights

Summary

Join us as we grow our way into a future that reimagines what it means to deliver meaningful benefits support and service.

Requirements

  • 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

Responsibilities

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

Benefits

  • 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

Share this job:

Disclaimer: Please check that the job is real before you apply. Applying might take you to another website that we don't own. Please be aware that any actions taken during the application process are solely your responsibility, and we bear no responsibility for any outcomes.
Please let OTIP (Ontario Teachers Insurance Plan) know you found this job on JobsCollider. Thanks! πŸ™