Data Engineer

What You’ll Do:

Reporting to the Senior Manager, Data Management, the Data Engineer designs, develops, and maintains scalable data pipelines and modern data platforms, primarily supporting a Python based data processing platform, focusing on Master Data Management (MDM) processing and MDM platform modernization. This role will play a critical part in enhancing existing MDM data processing, migrating existing Python-based pipelines to Snowflake, and implementing MDM solutions to deliver high-quality, trusted enterprise data.

The core parts of your role will be to:

• Design, develop, and enhance data pipelines to ingest and process data from multiple source systems and file formats.
• Apply data quality rules, validations, and thresholds within data pipelines to ensure reliable and accurate data is loaded to databases.
• Implement and manage CI/CD pipelines to enable automated deployment using Azure DevOps.
• Support the migration of existing Python-based solutions to Snowflake, and MDM platforms (e.g., Profisee), supporting platform modernization.
• Monitor and support data pipelines to ensure they meet expectations, maintain robustness, and adhere to security standards.
• Collaborate with Data Architecture and Data Governance for critical platform and portfolio initiatives in collaboration with business and technology stakeholders.
• Support the conversion of SSIS packages to ADF as part of Cloud migration.
• Collaborate effectively with cross-functional teams and external partners across the organization.
• Ensure compliance with data stewardship standards, governance policies, and data security procedures

Let’s Talk About You:

This is the unique blend of skills and experience we would love to see in an ideal candidate:

• Qualifications:

• Bachelor’s degree in computer science, engineering, or a related field (or equivalent practical experience).
• 3+ years of experience working as a Data Engineer using Python and SQL Server / Azure SQL.
• 2+ years of experience using Azure DevOps, including Repos and CI/CD pipelines.
• 3+ years of relational databases, preferably SQL Server and Azure SQL.
• 3+ years of experience with Azure Data Factory (ADF), SSIS, and SSMS, including pipeline orchestration.
• Solid understanding of ETL / ELT patterns and data modeling best practices.
• Knowledge of Medallion Architecture within enterprise data warehouse environments.
• Strong analytical and problem-solving skills with high attention to detail.
• Ability to manage multiple priorities and work independently with minimal supervision.
• Excellent verbal and written communication skills.
• Experience working in Agile/Scrum delivery environments.
• Knowledge or hands-on experience with Snowflake is an asset.
• Practical experience implementing Master Data Management (MDM) solutions or frameworks is an asset.
• Experience or familiarity with MDM tools such as Profisee or Informatica is an asset.

Salary Range:

This position offers a competitive salary within a range of $87,730 to $120,600, along with rewarding bonuses that recognize your dedication.

At the OTIP Group of Companies (OGC), we value transparency and take multiple factors into account when determining your starting salary, including your skills, experience, and alignment with the role as well as internal equity, while positioning you for continued growth and recognition over time.

Some of the Perks We Offer:

We offer best-in-class pension and benefits, total reward programs and comprehensive mental wellness support to set you up for every success in and outside of work. Here are just some of the reasons you’ll love working here:

• 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

Recruitment Process:

Please note that we do not currently use artificial intelligence (AI) in our recruitment process and this position is being posted to fill an existing vacancy.

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.

Let’s work together! If you are interested in this opportunity, please apply online.

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.