SS
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