Senior Data Engineer

Summary:

• Experience Level: Level 4 (advanced): 7-10 years
• Location: Montreal (Day 1 onboarding onsite / in office presence 3x week)

Responsibilities:

• Designing, implementing, and managing scalable data solutions using Snowflake for optimized data storage and processing.
• Migrating existing data domains/flows from relational data store to cloud data store (Snowflake).
• Identifying and optimizing new/existing data workflows.
• Implementing data integrity practices.
• Integrating data governance and data science tools with Snowflake ecosystem as per practice.
• Supporting the development of data models and ETL processes to ensure high-quality data ingestion in cloud data store.
• Collaborating with team members to design and implement effective data workflows and transformations.
• Maintaining and optimizing Snowflake environments to improve performance and reduce costs.
• Contributing to proof of concept, documentation, and best practices for data management and governance within the Snowflake ecosystem.
• Participating in code reviews and providing constructive feedback to improve team deliverables quality.
• Designing and developing data ingestion pipeline using Talend/Informatica using industry best practices.
• Writing efficient SQL and Python scripts for large dataset analysis and building end-to-end automation process on a set schedule.
• Designing and implementing data distribution layer using Snowflake REST API.
• Development of Semantic Model in Snowflake and PowerBI is a plus.

Requirements:

• Bachelor’s degree in Computer Science, Software Engineering, Information Technology, Management Information Systems or related field required (Master’s degree preferred).
• 7-10 years’ experience in data analysis, data objects development, and modeling in Snowflake data store.

Required Skills:

• Snowflake REST API experience.
• Informatica ETL and Talend ETL experience.
• Efficient SQL queries development and Python scripts development experience.
• Proven ability to work in distributed systems.
• Proficiency with relational databases (such as DB2) querying and focus on data transformations.
• Excellent problem-solving skills and team-oriented mindset.
• Strong data modelling concepts and schema design on relational data store and on cloud data store.
• Strong communication skills both verbal and written. Capable of collaborating effectively across a variety of IT and Business groups, across regions and different roles.

Preferred Skills:

• Familiarity with data visualization tools such as Tableau and PowerBI is a plus.
• Collaborating with data scientists/experts to integrate machine learning models into Snowflake.