Summary:
- Duration: 12 Months Contract
- Work Mode: Hybrid (3x week onsite)
- Location: Montreal
Responsibilities:
- Design, implement, and manage scalable data solutions using Snowflake for optimized data storage and processing.
- Migrate existing data domains/flows from relational data store to cloud data store (Snowflake).
- Identify and optimize new/existing data workflows.
- Implement data integrity practices and integrate data governance tools with Snowflake.
- Support development of data models and ETL processes for high-quality data ingestion.
- Collaborate with team members to design and implement effective data workflows and transformations.
- Assist in maintenance and optimization of Snowflake environments to improve performance and reduce costs.
- Contribute to proof of concept, documentation, and best practices for data management and governance.
- Participate in code reviews and provide constructive feedback to improve team deliverables quality.
- Design and develop data ingestion pipeline using Talend/Informatica.
- Write efficient SQL and Python scripts for large dataset analysis and automation processes.
- Design and implement data distribution layer using Snowflake REST API.
Requirements:
- Bachelor’s degree in Computer Science, Software Engineering, Information Technology, Management Information Systems or related field (Master’s degree preferred).
- 7-10 years’ experience in data analysis, data objects development, and modeling in Snowflake data store.
- Experience with Snowflake REST API.
- Experience with Informatica ETL and Talend ETL.
- Proficiency in developing efficient SQL queries and Python scripts.
- 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 communication skills both verbal and written, capable of collaborating effectively across various IT and Business groups.
Preferred Skills:
- Familiarity with data visualization tools such as Tableau and PowerBI.
- Experience in collaborating with data scientists to integrate machine learning models into Snowflake.
- Development of Semantic Model in PowerBI.