Data Engineer - 2831/2832

Duration: Until 30 Sep 2026

Location: Markham office a minimum of three days per week.

We are looking for a collaborative and resourceful Data Engineer (Sr) for our IT Data Platform Engineering Delivery team. You are dedicated, naturally inquisitive and are comfortable in a fast-paced environment.

This role will be part of and a member of our Information Technology Enterprise Data Services Group. You will be responsible for leading the architecture, design, analysis, and implementation in a successful, and experienced team. You’ll be required to apply your depth of knowledge and expertise with both modern and legacy data platforms to develop data ecosystems that will meet business requirements and align with the enterprise architecture goals and standards. The client has embarked on an exciting journey to modernize, craft, and build a next generation data platform to support the growing data needs of the business and to enable the capabilities of AI to drive business value.

What you’ll do

• Design, build and operationalize large scale enterprise data solutions in Hadoop, Postgres, Oracle, and Snowflake.

• Design and Develop ETL Pipeline to ingest data into Oracle/Hadoop/Postgres from different data sources (Files, Mainframe, Relational Sources, NoSQL, Hadoop Etc.) using Informatica Power center and BDM

• Work will also encompass crafting & developing solution designs for data acquisition/ingestion of multifaceted data sets (internal/external), data integrations & data warehouse/marts.

• You are collaborative with business partners, product owners, partners, functional specialists, business analysts, IT architecture, and developers to develop solution designs adhering to architecture standards.

• Responsible for supervising and ensuring that solutions adhere to enterprise data governance & design standards.

• Act as a point of contact to resolve architectural, technical and solution related challenges from delivery teams for best efficiency.

• Advocate importance of data catalogs, data governance and data quality practices.

• Outstanding problem-solving skills.

• Work in an Agile delivery framework to evolve data models and solution designs to deliver value incrementally.

• You are a self-starter with experience working in a fast-paced agile development environment.

• Strong mentoring and coaching skills and ability to lead by example for junior team members.

What you’ll bring

• University degree in Computer Engineering or Computer Science.

• 8+ years of experience crafting solutions for data lakes, data integrations, data warehouses/marts.

• Solid grasp/experience with data technologies & tools (Snowflake, Hadoop, Oracle, PostgreSQL, Informatica BDM & Power center, etc.,)

• Excellent coding skills in SQL Scripts, Python and Java.

• Knowledge or experience in GW CC (Guidewire claim center) will be an additional nice to have.

• Outstanding knowledge and experience in ETL with Informatica product suite.

• Experience implementing Data Governance principles and efficiencies.

• Familiar with the Agile software development.

• Excellent verbal and written communication skills.

• Insurance knowledge an asset-Ability to foundationally understand complex business process driving technical systems.