Senior Data Engineer

Focus on WD; Toronto; Híbrido; CAD 110.000 - 165.000; Jornada completa

Descripción de la vacante

Focus on WD is seeking a Senior Data Engineer to lead a major enterprise migration project. You will design and implement robust data pipelines using Snowflake, NiFi Openflow, and Python/SQL to migrate HR data from UKG into Workday.

This role emphasizes data quality, governance, and secure handling of confidential employee information. The position involves ownership of end-to-end pipeline delivery, validation, and reconciliation across enterprise systems, with a fully remote setup based in

Formación

• Strong hands-on Snowflake engineering experience.
• Experience designing data pipelines with Apache NiFi / Snowflake Openflow.
• Advanced SQL and Python development skills.
• Experience with HR/HCM platforms such as Workday, UKG, SAP, Oracle, or PeopleSoft.
• Knowledge of data migration, metadata mapping, and data transformation.
• Understanding of data quality, reconciliation, governance, and security.

Responsabilidades

• Design, develop, and optimize automated data ingestion pipelines using Snowflake Openflow / NiFi.
• Build Snowflake-native transformations using SQL, streams, tasks, and MERGE operations.
• Develop Python and SQL solutions for data transformation, automation, and reconciliation.
• Support migration of enterprise documents and metadata from UKG ECM into Workday EDM.
• Implement data validation, deduplication, quality checks, and reconciliation processes.
• Ensure secure handling of confidential employee information.

Conocimientos

Snowflake

NiFi

Python

SQL

Workday

HR systems

Data quality

Data governance

Security

Herramientas

Snowflake Openflow

Apache NiFi

Descripción del empleo

Location: Fully Remote – Canada

Tech Stack: Snowflake | Apache NiFi | Python | SQL | Workday

Ready to Build Something That Makes an Impact?

Our client is seeking an experienced Senior Data Engineer to play a key role in delivering a major enterprise data migration project.

This is an exciting opportunity to work on a complex transformation initiative, migrating employee documents and metadata from UKG into Workday, using Snowflake and Snowflake Openflow (Apache NiFi) as the core engineering technologies.

We're looking for a hands-on engineer who enjoys solving complex technical challenges, building reliable data pipelines, and taking ownership of critical engineering deliverables.

What You'll Be Doing

• Design, develop, and optimize automated data ingestion pipelines using Snowflake Openflow / Apache NiFi.
• Build Snowflake-native transformations using SQL, streams, tasks, and MERGE operations.
• Develop Python and SQL solutions for data transformation, automation, and reconciliation.
• Support the migration of enterprise documents and metadata from UKG ECM into Workday EDM.
• Implement data validation, deduplication, quality checks, and reconciliation processes.
• Ensure secure and compliant handling of confidential employee information.
• Prepare document packages and metadata for successful Workday loading.
• Take ownership of pipeline reliability, auditability, and technical delivery.

What We're Looking For

We're interested in speaking with experienced Data Engineers who bring:

• Strong, hands-on Snowflake engineering experience.
• Experience designing and developing data pipelines using Apache NiFi / Snowflake Openflow.
• Advanced SQL and Python development skills.
• Experience working with HR/HCM platforms such as Workday, UKG, SAP, Oracle, or PeopleSoft.
• Knowledge of document migration, metadata mapping, and data transformation.
• Strong understanding of data quality, reconciliation, governance, and security.
• Experience handling confidential or regulated enterprise data.

Nice to Have

Experience with any of the following would be a plus:

• Unstructured data and document processing

Why Consider This Opportunity?

• Gain hands-on experience with Snowflake Openflow and modern data engineering technologies.
• Take ownership of critical migration pipelines and technical deliverables.
• Work with modern technologies, including Snowflake, Apache NiFi, Python, and SQL.
• Enjoy a fully remote opportunity, based in Toronto or Western Canada.

If you're an experienced Snowflake Data Engineer with strong pipeline development and enterprise migration experience, we'd love to connect!