Data Engineering Advisor

Desjardins; Montreal West; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading company is seeking a Data Engineering Advisor to develop data solutions and assist clients with analytics needs. The role involves designing data ingestion pipelines, producing data mapping specifications, and implementing improvements based on user feedback. The ideal candidate will have a Bachelor's degree, relevant experience, and proficiency in SQL and Azure tools. Competitive salary, flexible vacation, and comprehensive benefits are offered.

Benefits

Competitive salary and annual bonus

4 weeks of flexible vacation

Defined benefit pension plan

Group insurance including telemedicine

Reimbursement of health and wellness expenses

Qualifications

• Minimum of four years of relevant experience, including 2 in data analytics.
• Experience with data transformation tools like dbt.

Responsibilities

• Develop solutions for data collection, integration, cleaning, sorting, and mining.
• Design and build data ingestion pipelines and transformation processes.

Skills

Data Analytics

Agile Methodologies

SQL

French

Education

Bachelor's degree in a related field

Tools

Azure

ELT tools

dbt

Job description

Join to apply for the Data Engineering Advisor role at Desjardins

Required

• The Personal Services Analytics and Data Solutions Department supports various sectors to meet their analytics needs. As a data engineering advisor, you will develop solutions for data collection, integration, cleaning, sorting, and mining. You will assist clients with scaling data mining solutions and designing platforms tailored to business needs. Specifically, you will:
• Identify analytics needs based on user feedback.
• Produce and document data mapping specifications.
• Implement, monitor, maintain, and improve systems to meet business needs.
• Design and build data ingestion pipelines and transformation processes.
• Develop algorithms, prototypes, and proofs of concept.
• Identify opportunities for system improvements based on trends and behaviors, and recommend updates.
• Help develop procedures and document technical solutions.

What we offer

• Competitive salary and annual bonus
• 4 weeks of flexible vacation starting in the first year
• Defined benefit pension plan
• Group insurance including telemedicine
• Reimbursement of health and wellness expenses and telework equipment
• Benefits based on eligibility

What You Bring To The Table

• Bachelor's degree in a related field
• Minimum of four years of relevant experience, including 2 in data analytics
• Experience with agile methodologies like Scrum and Kanban
• Experience with ELT tools
• Knowledge of French is required
• Knowledge of Azure (Synapse, Data Factory, Azure DevOps)
• Proficiency in SQL, T-SQL, stored procedures/functions
• Understanding of continuous delivery frameworks
• Knowledge of multidimensional databases and data security
• Experience with data transformation tools like dbt
• Knowledge of Azure MLOps and advanced analytics

Desjardins values equity, diversity, and inclusion. We welcome, respect, and value individuals for who they are, learning from differences and embracing uniqueness. We are committed to providing accessible recruitment processes and job accommodations upon request.