Data Engineering Advisor

Relevance

Montreal

On-site

CAD 90,000 - 130,000

Full time

8 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Competitive salary and annual bonus
4 weeks of flexible vacation starting
Defined benefit pension plan
Group insurance including telemedicine
Reimbursement of health and wellness

Job summary

Desjardins is seeking a data engineering advisor to design and optimize data pipelines, mappings, and analytics platforms supporting multiple business sectors in Montreal. You will implement scalable ELT processes, collaborate with IT design, and help solve complex data management challenges.

You will work with Azure Synapse, Data Factory, and DevOps tools, using SQL/T-SQL to build robust data transformations, while ensuring documentation and best practices are followed.

Qualifications

  • Bachelor's degree in a related field.
  • Minimum four years of relevant experience, including two years in data analytics.
  • Experience in data engineering and ELT.
  • Knowledge of Azure tools (Synapse, Data Factory, Azure DevOps).
  • Proficiency with SQL/T-SQL and stored procedures.

Responsibilities

  • Identify analytics needs based on user feedback.
  • Produce and document data mapping specifications.
  • Implement, monitor, and improve data systems to meet business needs.
  • Design and build data ingestion pipelines and transformation processes.
  • Develop algorithms, prototypes, and proofs of concept for projects.
  • Identify opportunities to improve systems based on trends and usage.

Skills

Data engineering
ELT tools
SQL
T-SQL
Stored procedures/functions
French language
Multidimensional databases

Education

Bachelor's degree in a related field

Tools

Azure Synapse
Azure Data Factory
Azure DevOps

Job description

The Personal Services Analytics Solutions Department is responsible for supporting the various sectors to help them meet their analytics needs. As a data engineering advisor, you help develop solutions for collecting, integrating, consolidating, cleaning, storing and seamlessly using data. You help develop, maintain, support and run computer applications and data pipelines, while ensuring the functional analysis, IT design, coding, fine-tuning and documentation of programs. You assist clients on development initiatives that involve scaling data mining solutions and designing platforms that are adapted to business needs. Your projects and initiatives require extensive knowledge of your line of work. You help solve complex business problems related to data collection and storage platform scalability using your analytical skills and detailed knowledge of your line of business. You analyze client and partner needs and help develop execution strategies and action plans taking into account the specifics of IT design for data management systems. You serve as a data management system resource person for practitioners. You interact with collaborators working in other fields to understand needs and harmonize solutions with business objectives. More specifically, you will be required to:

  • Identify the analytics needs based on feedback from users
  • Produce and document data mapping specifications
  • Implement, monitor, maintain and improve a wide range of systems that meet business needs
  • Design and build data ingestion pipelines and data transformation processes
  • Develop algorithms, prototypes and proofs of concept within projects
  • Identify opportunities to improve systems based on trends and behaviours 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 that provides predictable, stable income throughout retirement
  • Group insurance including telemedicine
  • Reimbursement of health and wellness expenses and telework equipment

* Benefits apply based on eligibility criteria.

What you bring to the table
  • Bachelor's degree in a related field
  • A minimum of four years of relevant experience, including two years in data analytics
  • Please note that other combinations of qualifications and relevant experience may be considered
  • Experience in data engineering
  • Experience with ELT tools
  • Experience with Azure (Synapse, Data Factory, Azure DevOps)
  • Experience with languages: SQL, T-SQL, stored procedures/functions
  • Knowledge of French is required
  • Knowledge of multidimensional databases

Action oriented, Business insight, Customer Focus, Differences, Interpersonal Savvy, Nimble learning

Equity, Diversity, Inclusion and Accessibility

At Desjardins, we believe in equity, diversity and inclusion. We're committed to welcoming, respecting and valuing people for who they are as individuals, learning from their differences, embracing their uniqueness, and providing a positive workplace for all. At Desjardins, we have zero tolerance for discrimination of any kind. We believe our teams should reflect the diversity of the members, clients and communities we serve.

If there's something we can do to help make the recruitment process or the job you're applying for more accessible, let us know. We can provide accommodations at any stage in the recruitment process. Just ask!

Trade Union (If applicable)
Job Family

Data (FG)

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineering Advisor
Data Engineering Advisor

Desjardins • Lévis

On-site
CAD 85,000 - 120,000
Competitive salary
Annual bonus
4 weeks of flexible vacation
+4
Data Engineering Advisor
Data Engineering Advisor

Desjardins • Montreal West

On-site
CAD 90,000 - 120,000
Competitive salary and annual bonus
4 weeks of flexible vacation starting
Defined benefit pension plan
+3
Senior Data Engineering Advisor
Senior Data Engineering Advisor

Relevance • Montreal

Hybrid
CAD 110,000 - 145,000
Competitive salary
4 weeks vacation starting in firstyear
Defined benefit pension
+2
Data Engineering Advisor
Data Engineering Advisor

Desjardins Technology Group • Montreal

On-site
CAD 90,000 - 120,000
Competitive salary and annual bonus
4 weeks vacation starting in year one
Defined benefit pension plan
+3
Senior Data Engineering Advisor
Senior Data Engineering Advisor

Desjardins • Montreal West

On-site
CAD 110,000 - 150,000
Competitive salary and annual bonus
4 weeks of flexible vacation starting
Defined benefit pension plan
+3
Senior Advisor, Data engineering
Senior Advisor, Data engineering

Desjardins • Montreal

Hybrid
CAD 110,000 - 140,000
Competitive salary
Annual bonus
4 weeks vacation
+4
Senior Data Engineering Advisor
Senior Data Engineering Advisor

Desjardins Technology Group • Montreal

Hybrid
CAD 110,000 - 150,000
Competitive salary
Annual bonus
4 weeks vacation starting in firstyear
+4
Analyst, Data valorization
Analyst, Data valorization

Desjardins • Montreal West

On-site
CAD 80,000 - 110,000
Competitive salary and annual bonus
4 weeks vacation
Defined benefit pension plan
+3
Senior Data Valorization Advisor
Senior Data Valorization Advisor

Relevance • Montreal

Hybrid
CAD 110,000 - 140,000
Competitive salary and annual bonus
4 weeks of flexible vacation starting
Defined benefit pension plan
+2
Data scientist
Data scientist

Desjardins • Montreal

Hybrid
CAD 90,000 - 120,000