Data Engineer (Open To Relocate)

Job Title: Senior Data Engineer Contract:1-year Location: Montreal (Day 1 onsite onboarding; hybrid model with 3 days/week in office) Open To Relocate 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.