Senior Data Engineering Advisor

Desjardins; Montreal West; On-site; CAD 110,000 - 150,000; Full time

Benefits offered by this job

Competitive salary and annual bonus

4 weeks of flexible vacation starting

Defined benefit pension plan

Group insurance including telemedicine

Health/wellness expenses reimbursement

Telework equipment

Job summary

Desjardins is seeking a Senior Data Engineering Advisor to lead the design and implementation of scalable data solutions. You will work on data ingestion pipelines, transformations, and data modeling to meet analytics needs across client groups.

Requires six+ years of relevant experience, including data analytics, and strong knowledge of ELT tools, Azure Synapse, Data Factory, DevOps, and SQL/T-SQL. French language skills are required and you will contribute to a secure, compliant data

Qualifications

• Bachelor's degree required; six+ years of relevant experience, including two in data analytics
• Experience with ELT tools and Azure data platforms
• Proficiency in SQL/T-SQL and data modeling
• Knowledge of French is required
• Knowledge of Continuous Delivery framework and data security practices
• Experience with Azure MLOps and advanced analytics

Responsibilities

• Understand analytical needs to design well-structured data models
• Produce and document data mapping specifications
• Implement, monitor, maintain and improve data systems
• Design and build data ingestion pipelines and data transformations
• Develop algorithms, prototypes and proofs of concept
• Identify opportunities to improve systems and recommend updates
• Carry out complex data engineering tasks and support team members

Skills

Interpersonal Savvy

Strategic mindset

ELT tools

Multidimensional databases

SQL

T-SQL

Stored procedures/functions

French language

Continuous Delivery

Data security

Azure MLOps and advanced analytics

Education

Bachelor's degree in a related field

Tools

Azure Synapse

Azure Data Factory

Azure DevOps

Job description

Required

The Personal Services Analytics and Data Solutions Department is responsible for supporting the various sectors to help them meet their analytics needs. As a senior data engineering advisor, you help develop solutions for collecting, integrating, consolidating, cleaning, sorting and seamlessly using data. You support a dedicated client group on various initiatives to develop scalable data solutions, including designing platforms tailored to business needs. More specifically, you will be required to :

• Understand and analyze users’ analytical needs to design and enhance consistent, well-structured data models that meet their needs
• 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 methods and document technical solutions
• Carry out complex data engineering mandates on your own and provide support to your team members

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 six years of relevant experience, including two years of experience in data analytics
• Please note that other combinations of qualifications and relevant experience may be considered
• Experience with ELT tools
• Experience with multidimensional databases
• Experience with Azure (Synapse, Data Factory, Azure DevOps)
• Experience with languages: SQL, T-SQL, stored procedures/functions
• Knowledge of French is required
• Knowledge of the Continuous Delivery framework
• Knowledge of data security (for example, access model, data protection)
• Knowledge of Azure MLOps and advanced analytics

Interpersonal Savvy, Strategic mindset

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!