Data Engineering Advisor

Desjardins Technology Group; Montreal; Presencial; CAD 90.000 - 120.000; Tempo integral

Benefícios oferecidos por esta vaga

Competitive salary and annual bonus

4 weeks vacation starting in year one

Defined benefit pension plan

Group insurance including telemedicine

Health and telework expense reimburse.

Eligibility-based benefits

Resumo da vaga

Desjardins Group is seeking a Data Engineering Advisor in Montreal to design and run data pipelines, integrate data and scale analytics platforms. You will document mapping specs, build ingestion and transformation processes, and develop proofs of concept while aligning with business needs and IT design standards.

You will work with Azure Synapse/Data Factory/Azure DevOps, SQL/T-SQL, and dimensional databases, bringing strong analytic thinking, collaboration and a focus on inclusion and

Qualificações

• Bachelor's degree in a related field.
• A minimum of four years of relevant experience, including two years in data analytics.
• 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.
• Equity, Diversity, Inclusion and Accessibility.

Responsabilidades

• 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.

Conhecimentos

Data engineering

ELT tools

Azure Data Services

SQL

Stored procedures

French

Multidimensional DB

Action oriented

Business insight

Customer focus

Interpersonal skills

Learning agility

Diversity & Inclusion

Formação

Bachelor's degree in a related field

Ferramentas

Azure Data Services

Descrição da vaga

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

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!

Desjardins Group is the largest cooperative financial group in North America. We're the choice for over 52,000 employees and we're named one of Canada's top employers by Mediacorp and Forbes. We offer a full range of financial products and services and share our expertise in personal services, business services, wealth management, life and health insurance, and property and casualty insurance. Pursuing a career at Desjardins means being part of an organization that puts people first.