Data Engineer

OGC

23h•Hybrid

About The Position

The OTIP Group of Companies (OGC) is seeking a Data Engineer to design, develop, and maintain scalable data pipelines and modern data platforms. This role primarily supports a Python-based data processing platform, focusing on Master Data Management (MDM) processing and MDM platform modernization. The Data Engineer will be instrumental in enhancing existing MDM data processing, migrating Python-based pipelines to Snowflake, and implementing MDM solutions to deliver high-quality, trusted enterprise data. The company emphasizes putting its people at the center of everything they do, fostering an environment where employees feel valued, supported, and included.

Requirements

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.

Nice To Haves

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.

Responsibilities

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.

Benefits

Competitive salary within a range of $87,730 to $120,600
Rewarding bonuses
Best-in-class pension and benefits
Total reward programs
Comprehensive mental wellness support
Defined benefit pension plan
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
Opportunities for advancement