Skip to content
mimi

Senior Data Engineer

Soho Square Solutions

Montreal · Hybrid Contract Senior 1w ago

About the role

Overview

We are seeking a highly skilled Senior Data Engineer to support the modernization of enterprise data and tooling capabilities. This role involves designing, developing, and managing scalable data solutions within a cloud-based data ecosystem, with a strong focus on Snowflake.

The ideal candidate is a motivated, self-driven professional with strong technical expertise and a strategic mindset who thrives in a collaborative team environment.

Key Responsibilities

  • Design, implement, and manage scalable data solutions using Snowflake for optimized storage and processing.
  • Migrate existing data domains and workflows from relational databases to cloud-based platforms.
  • Analyze, identify, and optimize new and existing data pipelines and workflows.
  • Implement and enforce data integrity and quality practices across data systems.
  • Integrate data governance and data science tools within the Snowflake ecosystem.
  • Develop and maintain robust ETL/ELT processes to support high-quality data ingestion.
  • Collaborate with cross-functional teams to design efficient data workflows and transformations.
  • Optimize Snowflake environments for performance, scalability, and cost efficiency.
  • Contribute to proofs of concept (POCs), technical documentation, and best practices for data management.
  • Participate in code reviews and ensure high standards of code quality.
  • Design and develop data ingestion pipelines using Talend and/or Informatica.
  • Write efficient SQL queries and Python scripts for large-scale data processing and automation.
  • Build and implement data distribution layers using Snowflake REST APIs.
  • Develop semantic models in Snowflake; experience with visualization tools is an advantage.

Required Skills & Qualifications

  • Bachelor’s degree in Computer Science, Information Technology, Software Engineering, or a related field (Master’s degree preferred).
  • 7–10+ years of experience in data engineering, data modeling, and data warehouse development.
  • Strong expertise with Snowflake, including architecture, optimization, and data modeling.
  • Experience with Snowflake REST APIs.
  • Hands-on experience with ETL tools such as Informatica and Talend.
  • Strong proficiency in SQL and Python programming.
  • Experience working with distributed data systems.
  • Solid understanding of relational databases (e.g., DB2) and data transformation techniques.
  • Strong knowledge of data modeling concepts (dimensional modeling, schema design).
  • Excellent problem-solving skills and attention to detail.
  • Strong communication and collaboration skills across technical and business teams.
  • Familiarity with data visualization tools (e.g., Tableau, Power BI) is a plus.
  • Experience collaborating with data scientists and integrating machine learning models into data platforms is an advantage.

Preferred Skills

  • Experience with semantic modeling and reporting layers.
  • Exposure to cloud data governance frameworks.
  • Understanding of performance tuning and cost optimization in Snowflake.

Skills

DB2InformaticaPythonSQLTalendTableauSnowflakePower BI

Don't send a generic resume

Paste this job description into Mimi and get a resume tailored to exactly what the hiring team is looking for.

Get started free