Position: Data Engineer<\/span><\/span>
<\/span><\/p>Location: Montreal, QC ( 3 days onsite is must)<\/span><\/span>
<\/span><\/p>Duration: 12+ Months<\/span><\/span>
<\/span><\/p> <\/span><\/span>
<\/span><\/p>Data Engineer<\/span><\/b><\/span>
<\/span><\/p> <\/span><\/span>
<\/span><\/p>KEY RESPONSIBILITIES:<\/span><\/b><\/span>
<\/span><\/p>- Designing, implementing, managing scalable data solutions using Snowflake environment for optimized data storage and processing.<\/span><\/span>
<\/span><\/li>- Migrate existing data domains/flows from relational data store to cloud data store (Snowflake).<\/span><\/span>
<\/span><\/li>- Identify and optimize new/existing data workflows.<\/span><\/span>
<\/span><\/li>- Identify and implement data integrity practices.<\/span><\/span>
<\/span><\/li>- Integrate data governance and data science tools with Snowflake ecosystem as per practice.<\/span><\/span>
<\/span><\/li>- Support the development of data models and ETL processes to ensure high quality data ingestion in cloud data store.<\/span><\/span>
<\/span><\/li>- Collaborate with team members to design and implement effective data workflows and transformations.<\/span><\/span>
<\/span><\/li>- Assist in the maintenance and optimization of Snowflake environments to improve performance and reduce costs.<\/span><\/span>
<\/span><\/li>- Contribute to proof of concept, documentation and best practices for data management and governance within the Snowflake ecosystem.<\/span><\/span>
<\/span><\/li>- Participate in code reviews and provide constructive feedback to improve team deliverables quality<\/span><\/span>
<\/span><\/li>- Design and develop data ingestion pipeline using Talend/Informatica using industry best practices.<\/span><\/span>
<\/span><\/li>- Writing efficient SQL and Python scripts for large dataset analysis and building end to end automation process on a set schedule.<\/span><\/span>
<\/span><\/li>- Design, implement data distribution layer using Snowflake REST API.<\/span><\/span>
<\/span><\/li><\/ul> <\/span><\/span>
<\/span><\/p>SKILLS / QUALIFICATIONS<\/span><\/b><\/span>
<\/span><\/p>- Bachelor\u2019s degree in computer science, Software Engineering, Information Technology, Management Information Systems or related field required (Master\u2019s degree preferred)<\/span><\/span>
<\/span><\/li>- 5 to 10 years\u2019 experience in data analysis, data objects development and modeling in Snowflake data store.<\/span><\/span>
<\/span><\/li>- Snowflake REST API experience is required<\/span><\/span>
<\/span><\/li>- Experience with building data pipelines from legacy to Snowflake for unstructured and semi structured datasets<\/span><\/span>
<\/span><\/li>- Informatica ETL and/or Talend ETL experience.<\/span><\/span>
<\/span><\/li>- Efficient SQL and PLSQL queries development and Python scripts development experience. <\/span><\/span>
<\/span><\/li>- Proven ability to work in distributed systems<\/span><\/span>
<\/span><\/li>- Proficiency with relational databases (such as DB2) querying and focus on data transformations.<\/span><\/span>
<\/span><\/li>- Excellent problem\-solving skills and team\-oriented mindset<\/span><\/span>
<\/span><\/li>- Strong data modelling concepts and schema design on relational data store and on cloud data store<\/span><\/span>
<\/span><\/li>- Strong communication skills both verbal and written. Capable of collaborating effectively across a variety of IT and Business groups, across regions and different roles.<\/span><\/span>
<\/span><\/li>- Familiarity with data visualization tools such as Tableau and PowerBI is a plus.<\/span><\/span>
<\/span><\/li>- Collaborating with data scientists/experts to integrate machine learning models into Snowflake<\/span><\/span>
<\/span><\/li>- Data Warehousing background is required<\/span><\/span>
<\/span><\/li><\/ul>
<\/span><\/div>\u200b<\/span><\/span>
<\/span><\/div>Send resume & documents to <\/span><\/span>recruiter@sereneaid.com<\/span><\/span><\/a> <\/span><\/span>
<\/span><\/p>Call: 647\-794\-8009<\/span><\/span>
<\/span><\/p>\u200b<\/span><\/span>
<\/span><\/div>
<\/div><\/span>
