Senior Advisor, Guidewire Business Intelligence and Data Modelling

Desjardins; Aurora; On-site; CAD 88,000 - 129,000; Full time

Benefits offered by this job

Annual bonus

Pension plan

Group insurance

Telework equipment reimbursement

Flexible vacation

Downtown Toronto salary

Job summary

Desjardins in Toronto (Downtown) invites a senior advisor to lead data modelling, integration and data valorization within the Guidewire Data Studio ecosystem. You will design data models, optimize ETL/ELT processes and ensure data quality for business users.

In this advisory role, you will mentor colleagues, translate business needs into scalable data solutions and support adoption of Guidewire Data Studio. Fluency in English and French is valued for Quebec roles.

Qualifications

• Bachelor's degree in a related field.
• A minimum of six years of relevant experience in business intelligence, data model design or data engineering.
• Experience in data modelling and information architecture design.
• Demonstrated advisory experience with business teams and data users.
• Experience with Guidewire Data Studio and Guidewire Explore, or strong interest to develop expertise.

Responsibilities

• Design, develop and maintain data models and structures in Data Studio to meet business and analytical needs.
• Develop and optimize data integration, transformation and loading (ETL/ELT) processes.
• Improve performance and scalability of data models, processes and queries.
• Ensure quality, integrity, consistency, traceability and reliability of data.
• Support administration, adoption and continuous improvement of the Guidewire Data Studio platform.
• Translate business needs into effective, scalable and reusable data solutions.
• Provide users with reliable, well-documented datasets.
• Advise on best practices for data modelling, architecture and valorization.
• Serve as an expert advisor and mentor to enhance the team’s practices.
• Contribute to strategic initiatives to modernize data platforms.

Skills

Data modelling

Data integration

Data quality

Guidewire Data Studio

Guidewire Explore

SAS

Python

SQL

Data governance

Analytics architecture

Education

Bachelor's degree in a related field

Tools

Guidewire Data Studio

Guidewire Explore

Cloud data platforms

Job description

Required

As part of the implementation of the Guidewire platform, our team is looking for an experienced professional to act as a senior advisor for data modelling, business intelligence and data valorization. In this position, you will play a key role in modernizing our information systems and advancing our data management practices. You will be responsible for designing, structuring and making data assets accessible to enable business teams to take full advantage of the available information. Your expertise will be primarily used in the areas of data modelling, integration, data quality and making data available in Data Studio, rather than in developing reports and dashboards. You will actively participate in implementing and further developing Guidewire Data Studio, Guidewire ecosystem’s data platform. In this role, you will serve as a point of reference for data consumers, ensuring that information is well-structured, accessible and adapted to business needs, while contributing to the development of the platform. Through your leadership and technical expertise, you will also contribute to establishing best practices, innovation, and skills development among your colleagues. More specifically, you will be required to:

• Design, develop and maintain data models and structures in Data Studio to meet business and analytical needs.
• Develop and optimize data integration, transformation and loading (ETL/ELT) processes.
• Improve the performance and scalability of data models, processes, and queries.
• Ensure the quality, integrity, consistency, traceability and reliability of organizational data.
• Support the administration, adoption and continuous improvement of the Guidewire Data Studio platform.
• Translate business needs into effective, scalable and reusable data solutions.
• Provide users with reliable, well-documented and easy-to-use datasets.
• Advise interested parties on best practices for data modelling, architecture and valorization.
• Serve as an expert advisor and mentor to enhance the team’s practices in data modelling, quality and mining.
• Contribute to strategic initiatives aimed at modernizing data platforms and information systems.

What we offer*

• Competitive salary and annual bonus
• Salary range : $88 008 to $129 080per year (Downtown Toronto)
• 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.

, #ON10-

What You Bring To The Table

• Bachelor's degree in a related field
• A minimum of six years of relevant experience in business intelligence, data model design or data engineering
• Please note that other combinations of qualifications and relevant experience may be considered
• Experience in data modelling and information architecture design
• Demonstrated experience in an advisory role with business teams and data users
• Experience with Guidewire Data Studio and Guidewire Explore, or a strong interest in developing expertise in these platforms
• Experience with SAS and/or Python as part of data integration, transformation or quality initiatives
• Experience with modern data warehouses, cloud data platforms or enterprise data management environments
• Knowledge of French is required for positions in Quebec
• Advanced proficiency of English due to the nature of the duties or work tools or because the position involves interactions with English-speaking partners, members and/or clients
• Proficiency in SQL
• Proficiency in data modelling methodologies and designing analytical data structures
• Knowledge of the principles of data governance, quality and security

Action oriented, Business insight, Complexity, Customer Focus, Differences, 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!

Job Family

Data (FG)

Unposting Date

2026-11-4

This position is actually vacant.

Desjardins uses tools that incorporate artificial intelligence functionalities to screen or assess applicants as part of the recruitment process for this position.