Senior Advisor, Guidewire Business Intelligence and Data Modelling

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.

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

#LI-Hybrid, #ON10-

• 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,…