Data Engineer Lead

Intelcom; Montreal; On-site; CAD 80,000 - 120,000; Full time

Job summary

Intelcom is seeking a skilled Data Engineer to lead data integration, develop technical documentation, and manage analytics environments. Candidates are expected to possess advanced knowledge in Snowflake, SQL, and cloud platforms like AWS and Azure. A Bachelor's degree in a relevant field and 5-7 years of experience are required. The ideal candidate will contribute to building a data governance model and supervise a team, promoting professional growth and adopting Agile methodologies. Join Intelcom, a leader in e-commerce logistics, to shape the future of data-driven decision-making.

Qualifications

• Minimum 5-7 years of experience as a developer on analytic projects.
• Strong interest in cloud computing technologies and modern platforms.
• Bilingual in French and English.
• Motivated individual, adaptable to a fast-paced environment.

Responsibilities

• Define specifications and requirements for mandates in collaboration with the necessary stakeholders across the organization.
• Design data integration flows using available platforms such as Snowflake, AWS, and Azure.
• Improve the organization of data to better support all the different loading frequencies.
• Participate in the development of the data Dev Ops practice, notably with the implementation of automated deployments.
• Feed the different analytical environments (OPS datamarts, Finance, Sales & Marketing, HR, etc.).
• Create automated data validation requests.
• Investigate data quality and ETL issues and work to resolve them.
• Contribute to the technical documentation of data flows.
• Establish and maintain data repositories.
• Always be on the lookout for possible improvements to the platform and methodology.
• Responsible for the different analytical platform from a security standpoint.
• Build a data governance model for the company.
• Prioritize mandates in collaboration with the stakeholders.
• Define career path for each member of the data engineering team.
• Supervise and mentor the data engineering team.
• Evaluate the performance of the data engineering team while promoting career retention, training and growth.
• Promote and implement an Agile methodology among the data engineering team.

Skills

Snowflake Data Cloud

SQL

Apache Airflow

AWS

Azure

DBT

Data modeling (Kimball)

Python

R

Education

Bachelor’s degree in Information Technology, Data Engineering, or related field

Job description

• Define specifications and requirements for mandates in collaboration with the necessary stakeholders across the organization;
• Design data integration flows using available platforms such as Snowflake (SQL, Tasks, Stream, Pipe), AWS (Lambda, Kinesis firehose, S3, etc.) and Azure (Data Factory, Azure SQL DB, etc.), and tools such as DBT;
• Improve the organization of data to better support all the different loading frequencies;
• Participate in the development of the data Dev Ops practice, notably with the implementation of automated deployments;
• Feed the different analytical environments (OPS datamarts, Finance, Sales & Marketing, HR, etc.);
• Create automated data validation requests;
• Investigate data quality and ETL issues and work to resolve them;
• Contribute to the technical documentation of data flows;
• Establish and maintain data repositories;
• Always be on the lookout for possible improvements to the platform and methodology;
• Responsible for the different analytical platform from a security (i.e. accesses) stand point;
• Build a data governance model for the company, with the help of the Data Architect.
• Prioritize mandates in collaboration with the stakeholders across the organization to guarantee the fulfillment of the business objectives.
• Define career path for each member of the data engineering team and support their growth within the organization.
• Supervise and mentor the data engineering team in the fulfillment of its mission and mandates.
• Evaluate the performance of the data engineering team while promoting career retention, training and growth.
• Promote and implement an Agile methodology among the data engineering team.

Qualification :

• Advanced skills in Snowflake Data Cloud;
• Advanced skills in SQL language, Window functions and recursive queries
• Proficiency in Apache Airflow or equivalent
• Proficiency in cloud computing platforms (AWS, Azure, GCP)
• Knowledge of DBT (analytics engineering)
• Knowledge of data modeling (Kimball);
• Understands the architecture of Power BI services in order to offer relevant solutions (workspace concepts, dashboards versus reports, Apps, etc.);
• Applicable knowledge of languages like Python / R to present more complete visuals would be an asset;
• Sufficient knowledge of the Python language to apply it in a data integration context.
• Minimum 5-7 years of experience as a developer on analytic projects;
• Bachelor’s degree or higher in a relevant field (Information Technology, Data Eng., Masters in BI, mathematics, etc.);
• Strong interest in cloud computing technologies and modern platforms;
• Bilingual , French and English;
• Motivated individual, adaptable to a fast-paced environment;

Intelcom is a leading last-mile carrier in the e-commerce sector. Our teams across Canada as well as our network of independent contractors contribute to Intelcom’s daily operations.

Our goal is simple : in a constantly evolving business sector, we don't just follow, we get ahead. In addition to standing out through innovative services and delivery methods, Intelcom is also undergoing a technological transformation where the integration of customer experience and logistics technologies are at the heart of its evolution.

At Intelcom, we know experience comes in many forms and are committed to building a culture where difference is valued. We are always looking for talented and diverse individuals to join our teams. With over 60 delivery centers across Canada, we may have the right opportunity for you.

Apply Now.

Create a job alert for this search