Staff

Senior Data Engineer

Technology Enablement location_on Waterloo, ON

Job title

OTIP.Careers.TableCategory location_on

Company description


Who We Are

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: 

  • 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

    Need help?
    x
    How can we help?
    Enrolling in your benefits plan Frequently Asked Questions (FAQs)
    We may already have the answer. Check out our FAQs.
    My benefits booklet My home/auto policy More questions?
    Send an email for all other inquiries