
Data Engineer
Role summary
We are seeking a Senior Data Engineer for a Fixed-Term Contract role in Montreal, QC. This hybrid position requires 3 days/week in-office and involves leading the modernization of tooling enablement. The role focuses on designing, modeling, and managing data warehouse objects in Snowflake, building robust data pipelines using Talend, Informatica, and APIs, and migrating data from traditional stores to Snowflake. Responsibilities include SQL and Python scripting, API integration, performance optimization, and collaboration with data scientists and business groups. The ideal candidate has 7-10 years of experience in data warehousing, ETL/ELT tools, and advanced SQL/Python.
Senior Data Engineer | Corporate Workspace Technology
Location:
Montreal, QC (Hybrid: 3 days/week in-office; Onsite onboarding required)
Experience Level:
Level 4 (Advanced): 7–10 Years
Job Type:
Fixed-Term Contract (FTC)
The Opportunity
We are seeking a highly skilled
Senior Data Engineer
to join our Corporate Workspace Technology team. In this role, you will lead the modernization of our tooling enablement function, focusing on the design, modeling, and management of data warehouse objects within
Snowflake
.
The ideal candidate is a self-driven, strategic thinker who excels at building robust data pipelines using Talend, Informatica, and APIs while collaborating effectively in a team-centric environment.
Key Responsibilities
- Architect & Implement:
Design and manage scalable data solutions within the Snowflake ecosystem to optimize storage and processing performance.
- Cloud Migration:
Lead the migration of existing data domains and flows from traditional relational data stores to Snowflake.
- Pipeline Development:
Build and maintain end-to-end data ingestion pipelines using
Talend
and
Informatica
, adhering to industry best practices.
- Automation & Scripting:
Write high-performance SQL and Python scripts for large-scale dataset analysis and scheduled process automation.
- Data Strategy:
Identify and implement data integrity practices, governance frameworks, and integration tools within the Snowflake ecosystem.
- API Integration:
Design and develop the data distribution layer utilizing
Snowflake REST APIs
.
- Optimization:
Continuously monitor and tune Snowflake environments to enhance performance and reduce operational costs.
- Collaboration:
Work closely with data scientists to integrate machine learning models and partner with IT and Business groups to align technical solutions with corporate goals.
Skills & Qualifications
Technical Expertise
- Data Warehousing:
7–10 years of deep experience in data analysis, modeling, and object development specifically within
Snowflake
.
- ETL/ELT Tools:
Proven proficiency with
Informatica
and
Talend
.
- Languages:
Expert-level
SQL
query development and
Python
scripting.
- Database Systems:
Strong background in relational databases (e.g.,
DB2
) and complex data transformations.
- Connectivity:
Practical experience working with
Snowflake REST APIs
.
- Modeling:
Advanced understanding of schema design for both relational and cloud-based data stores.
Education & Soft Skills
- Education:
Bachelor’s degree in Computer Science, Software Engineering, or a related field (Master’s degree preferred).
- Communication:
Exceptional verbal and written communication skills; ability to bridge the gap between technical teams and business stakeholders.
- Mindset:
A problem-solver with a team-oriented approach and the ability to work effectively in distributed systems.
Preferred Assets
- Visualization:
Familiarity with
Tableau
or
Power BI
.
- Semantic Layer:
Experience developing Semantic Models in Snowflake or Power BI.
- AI/ML:
Experience collaborating with data scientists to deploy machine learning models.
Similar roles
- Senior Data EngineerExperion Technologies · Plano, Texas, United States · Hybrid
- Lead Data EngineerSmart IT Frame LLC · Los Angeles, California, United States · Hybrid
Principal Data EngineerRS21: A Data Science and Visualization Company · United States · Remote
Senior Data EngineerRaag Solutions · Bellevue, Washington, United States · Onsite- Lead Data EngineerRetail Insight Ltd · Illinois, United States · Hybrid