Ratemaking SAS Data Analyst

Desjardins; Lévis; On-site; CAD 90,000 - 120,000; Full time

Benefits offered by this job

Competitive salary

Annual bonus

Pension plan

Group insurance

Telework equipment reimbursement

Flexible vacation

Job summary

Desjardins in Lévis, Canada is seeking a data analyst to drive ratemaking initiatives. You will prepare and analyze data, automate processes, and collaborate with actuaries, BI teams and partners to improve profitability and client experience.

The role requires a strong background in data analysis, SQL, SAS, Python or R, and knowledge of data governance and insurance concepts. Fluency in French and strong English are important for cross-functional work.

Qualifications

• Bachelor's degree in actuarial science, statistics, mathematics, computer science, business intelligence or related field.
• Minimum of six years of relevant data analysis and preparation experience.
• Other combinations of qualifications and relevant experience may be considered.
• Experience handling large data volumes and automating processes.
• French language required.
• Proficient in English (intermediate advanced).
• Proficiency in SQL.
• Knowledge of SAS, Python or R.
• Knowledge of data quality, governance and architecture concepts.
• Knowledge of property and casualty insurance.

Responsibilities

• Prepare, integrate, validate and analyze data from multiple sources to support ratemaking and modelling projects.
• Develop, automate and optimize data preparation processes for recurring activities, budgeting and strategic analyses.
• Help implement innovative data solutions in modern data environments and ratemaking transformation initiatives.
• Design and maintain queries, scripts and data flows to improve analysis efficiency and quality.
• Support data governance by applying data quality, documentation and security standards.
• Create and maintain data documentation, variable dictionaries and data preparation processes.
• Monitor data quality, identify anomalies and recommend corrective actions.
• Collaborate with actuaries, analysts, BI teams and partners to meet business needs.
• Identify opportunities to improve data-related processes and implement scalable solutions.
• Act as go-to person for data-related questions and share best practices.

Skills

Data analysis

SQL

French language

English language

Problem solving

Education

Bachelor's degree in actuarial science, statistics, mathematics, computer science, business intelligence or related field

Tools

SAS

Python

R

SQL

Job description

Required

If you’re passionate about data, analytics and problem-solving, this position allows you to play a key role in the development of property and casualty insurance ratemaking. You contribute to strategic projects that directly impact profitability, growth and the client experience. Working with the ratemaking, business intelligence and data governance teams, you use your expertise to turn data into insights that support decision-making. In this role, you work on complex assignments related to ratemaking and improving our data management processes. More specifically, you will be required to:

• Prepare, integrate, validate and analyze data from multiple sources to support ratemaking and modelling projects
• Develop, automate and optimize data preparation processes for recurring activities, budgeting and strategic analyses
• Help implement innovative data solutions, particularly in modern data environments and ratemaking transformation initiatives
• Design and maintain queries, scripts and data flows to improve the efficiency and quality of analyses
• Support data governance by applying data quality, documentation and security standards
• Create and maintain data documentation, variable dictionaries and data preparation processes
• Monitor data quality, identify anomalies and recommend corrective actions
• Collaborate with actuaries, analysts, BI teams and other partners to meet business needs and improve decision-making
• Identify opportunities to improve data-related processes and implement sustainable, scalable solutions
• Act as a go-to person for data-related questions and share best practices in data valorization and use.

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 actuarial science, statistics, mathematics, computer science, business intelligence or a related field
• A minimum of six years of relevant experience in data analysis and preparation
• Please note that other combinations of qualifications and relevant experience may be considered
• Experience handling large volumes of data and automating processes
• Knowledge of French is required
• Intermediate 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
• Knowledge of SAS, Python or R
• Knowledge of data quality, governance and architecture concepts
• Knowledge of property and casualty insurance

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)