Data Engineer

Wireframe Solutions-IT Consulting Company; Montreal (administrative region); On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading IT consulting firm based in Montreal seeks an experienced data analyst with a Bachelor's degree in Computer Science or related field. The role requires 5 to 10 years of experience in Snowflake data modeling, building data pipelines, and proficiency in SQL and Python. The ability to collaborate across IT and Business groups is essential. Familiarity with ETL tools and data visualization is a plus.

Qualifications

• 5 to 10 years’ experience in data analysis and modeling in Snowflake.
• Experience with building data pipelines for unstructured datasets.
• Proficiency with relational databases and data transformations.

Skills

Data analysis

Snowflake data store

SQL

Python scripting

Data modeling

Education

Bachelor's degree in relevant field

Master's degree in relevant field

Tools

Informatica ETL

Talend ETL

Tableau

PowerBI

Job description

Requirements

• Bachelor’s degree in computer science, Software Engineering, Information Technology, Management Information Systems or related field required (Master’s degree preferred)
• 5 to 10 years’ experience in data analysis, data objects development and modeling in Snowflake data store.
• Snowflake REST API experience is required
• Experiencewith building data pipelines from legacy to Snowflake for unstructured and semi structured datasets
• Informatica ETL and/or Talend ETL experience.
• Efficient SQL and PLSQL 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.
• 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