Senior Data Engineer

Axelon Services Voir toutes les offres

  • Montréal, QC
  • Permanent
  • Temps-plein
  • Il y a 1 mois
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.

Axelon Services