Data Engineer - Lachine

Randstad Canada; Montreal; Hybrid; CAD 83,000 - 124,000; Full time

Benefits offered by this job

Hybrid work model

6-month contract with extension

Job summary

Randstad Canada is seeking a talented Data Engineer for a Montreal-based contract opportunity. You will design scalable data models, build robust cloud data pipelines, and transform enterprise data into high-value analytical assets to support BI enablement.

The role bridges transactional systems with cloud analytics, using Snowflake, Matillion, and AWS, while modeling SAP data into dimensional structures. Expect hybrid work; 3 days onsite, 2 days remote, for a 6-month contract with potential

Qualifications

• Minimum 3+ years of full-time professional experience in Data Engineering, Business Intelligence, or Analytics Engineering.
• Advanced SQL & Data Modeling: expert-level SQL querying and design of dimensional star and snowflake data models.
• Cloud Data Warehousing: hands-on experience with Snowflake data warehouses.
• ETL/ELT Tools: experience building and optimizing data transformation pipelines using Matillion.
• AWS Cloud Services: proficiency with core AWS services (storage, compute, SQS, SNS, Lambda).
• SAP Data Structures: experience modeling transactional data from SAP ECC and SAP S/4HANA.
• Data Visualization: ability to develop reports and dashboards in Tableau and Power BI.
• Application Development: experience with ASP.NET or similar web app development supporting data integration.

Responsibilities

• Design dimensional and analytical data models using star and snowflake schemas to enable scalable architectures.
• Build, schedule, and optimize enterprise ETL/ELT data pipelines using Matillion.
• Develop, tune, and maintain advanced SQL queries, views, and stored procedures in Snowflake.
• Utilize AWS services (S3, compute, SQS, SNS, Lambda) to support data ingestion and processing workflows.
• Model and transform SAP ECC/S/4HANA data into standardized analytical structures for business users.
• Create and maintain interactive dashboards and operational reports in Tableau and Power BI.
• Collaborate with stakeholders to elicit reporting requirements, define KPIs, and deliver scalable data-driven solutions.
• Support applications and data integration workflows using ASP.NET.
• Contribute to ongoing rebranding, system transitions, and reporting updates.
• Use Jira and Confluence to manage Agile sprint planning and documentation.

Job description

We are seeking a talented and proactive Data Engineer for an enterprise-level contract opportunity based in Montreal, Canada. In this role, you will take on a vital data engineering, cloud analytics, and business intelligence enablement capacity, specializing in designing scalable data models, building robust cloud data pipelines, and transforming enterprise data into high-value analytical assets.

Operating within a hybrid model in Montreal, you will bridge the gap between transactional enterprise systems and modern cloud analytics platforms. You will engineer and optimize data pipelines using Snowflake, Matillion, and AWS cloud services, while modeling complex enterprise data structures including SAP data into clean, dimensional models. Additionally, you will support cross-functional reporting across Tableau and Power BI and maintain data integration applications. This position demands an experienced data engineering practitioner with advanced SQL capabilities, solid cloud data warehousing expertise, and strong problem-solving skills to deliver reliable, production-grade data solutions.

Location: Montreal, Canada

Assignment Type: Hybrid (3 days onsite, 2 days remote per week)

Contract Duration: 6-month contract (with extension potential)

Avantages

• Modern Cloud Stack: Build and manage data pipelines using Snowflake, Matillion, and AWS cloud services.
• Enterprise Data Integration: Model and transform complex transactional data from SAP ECC and S/4HANA systems.
• Balanced Hybrid Model: Enjoy flexibility with a structured schedule of 3 days onsite and 2 days remote.
• End-to-End Ownership: Work across the full lifecycle from data modeling and ETL engineering to BI dashboard enablement.

Responsabilités

• Design dimensional and analytical data models utilizing star and snowflake schemas to establish scalable, high-performance data architectures.
• Build, schedule, and optimize enterprise ETL and ELT data pipelines utilizing Matillion.
• Develop, tune, and maintain advanced SQL queries, views, stored procedures, and analytical data transformations in Snowflake.
• Utilize AWS cloud services—including S3 data storage, compute instances, SQS message queues, SNS notifications, and Lambda functions—to support data ingestion and processing workflows.
• Model and transform complex transactional data from enterprise systems like SAP ECC and S/4HANA into standardized, business-friendly analytical structures.
• Create, optimize, and maintain interactive visual dashboards and operational reports in Tableau and Microsoft Power BI to deliver actionable insights.
• Collaborate closely with business stakeholders to elicit reporting requirements, define key performance indicators (KPIs), and deliver scalable data-driven solutions.
• Develop, enhance, and support applications using ASP.NET to facilitate reporting needs and custom data integration workflows.
• Support ongoing organizational rebranding initiatives, system transitions, and reporting updates.
• Utilize Jira and Confluence to manage Agile sprint planning, backlog refinement, task execution, and technical documentation.
• Conduct data validation, reconciliation checks, and quality assurance testing across data pipelines and reporting outputs.

Qualifications

Core Technical & Data Engineering Requirements

• Professional Experience: Minimum 3+ years of full-time professional experience in Data Engineering, Business Intelligence, or Analytics Engineering.
• Advanced SQL & Data Modeling: Expert-level SQL querying and query optimization skills, with proven experience designing dimensional star and snowflake data models.
• Cloud Data Warehousing: Solid hands-on experience developing and managing data models within the Snowflake data warehouse platform.
• ETL/ELT Tools: Proven practical experience building and optimizing data transformation pipelines using Matillion.
• AWS Cloud Services: Practical proficiency utilizing core AWS cloud services, including storage, compute, SQS, SNS, and AWS Lambda.
• SAP Data Structures: Hands-on experience analyzing and modeling transactional data from SAP ECC or SAP S/4HANA systems.
• Data Visualization: Familiarity with developing reports and interactive dashboards in Tableau and Microsoft Power BI.
• Application Development: Practical experience with ASP.NET or general web application development supporting data integration.

Preferred Technical Assets & Methodologies

• Certifications: Snowflake certification or AWS analytics certifications are considered an asset.
• Advanced Analytics & Scripting: Experience with DAX modeling in Power BI, Python scripting for data automation, or Git version control workflows.
• Emerging Technologies: Foundational knowledge of Machine Learning concepts and Large Language Models (LLMs) is considered a plus for long-term initiatives.
• Industry Background: Prior experience working within manufacturing or energy industry sectors.

Soft Skills & Delivery Attributes

• Agile Collaboration: Demonstrated experience working effectively within Agile/Scrum delivery teams and sprint cadences.
• Analytical Problem Solving: Strong critical thinking skills to analyze complex source systems, troubleshoot pipeline bottlenecks, and resolve data discrepancies.
• Communication & Stakeholder Management: Excellent written and verbal communication skills with the ability to translate business needs into technical specifications and collaborate across cross-functional groups.

Randstad Canada s'engage à favoriser une main-d'œuvre représentative de toutes les populations du Canada. Nous nous engageons en conséquence à développer et à mettre en œuvre des stratégies pour promouvoir l'équité, la diversité et l'inclusion dans toutes nos sphères d'activité en examinant nos politiques, pratiques et systèmes internes tout au long du cycle de vie de notre main-d'œuvre, y compris au niveau du recrutement, de la rétention et de l'avancement pour tout individu. En plus de notre profond engagement sur le respect des principes des droits de la personne, nous nous engageons à prendre toute mesure positive pour influer sur les changements à mettre en place en vue de garantir la participation de tout individu dans le monde du travail et ce, sans obstacle, systémique ou autre, en particulier pour les groupes en quête d'équité généralement sous-représentés dans la main-d'œuvre au Canada, y compris les personnes qui s'identifient comme femmes ou personnes non-binaires/non conformes au genre, les Peuples et communautés autochtones, les personnes en situation de handicap (visible ou invisible), les personnes faisant partie des minorités visibles, les personnes racisées et des communautés LGBTQ2+.

Randstad Canada s'engage à créer et à maintenir un milieu de travail inclusif et accessible pour toutes les personnes candidates et employés en soutenant leurs besoins d'accessibilité et d'accommodation tout au long du cycle de vie de l'emploi. Nous demandons à toutes les personnes demandeuses d'emploi de bien vouloir identifier leurs besoins en matière d'accommodation en envoyant un courriel à [e-mail] pour s'assurer de leur capacité à participer pleinement au processus d'entrevue.