Data Analyst

About Us

RATES.CA GROUP LTD. is one of Canada’s fastest-growing technology companies. We help Canadians make informed financial decisions through product comparisons, original content, and user-friendly financial tools. We partner with leading insurers, banks, credit unions, and brokers to give consumers more choice and access to better financial products.

We are looking for a self-motivated Data Analyst to join our Insurance Marketplace team. Reporting to the Chief Underwriting Officer, this position should appeal to candidates who enjoy turning large, complex datasets into insights that shape decisions, and who prefer the informal environment of a successful digital company.

The Data Analyst is a key member of the Insurance Marketplace team, working directly with the Chief Underwriting Officer to analyze large datasets, optimize complex spreadsheets, and present clear insights and recommendations to leadership. The role supports underwriting, pricing, and marketplace performance across home and auto insurance. The successful candidate combines advanced Excel and PowerPoint skills with fluency in AI tools such as Claude and collaborates effectively with colleagues across the organization.

Key Responsibilities

• Analyze and optimize large datasets and complex Excel workbooks to improve performance, accuracy, and usability.
• Turn data into clear, actionable insights that support underwriting, pricing, and marketplace decisions.
• Build and deliver polished PowerPoint presentations and reports for the Chief Underwriting Officer, senior leadership, and cross-functional teams.
• Support ratemaking and pricing analysis for home and auto insurance, including rate change impact, competitive positioning, and portfolio monitoring.
• Track and report on key Insurance Marketplace performance metrics, identifying trends, anomalies, and opportunities.
• Use AI tools such as Claude to automate analysis, accelerate reporting, and improve the quality of insights.
• Develop and maintain reusable models, templates, dashboards, and documentation.
• Validate data and results to ensure accuracy, consistency, and integrity.
• Collaborate with underwriting, product, technology, marketing, and insurer partner teams to understand business needs and deliver solutions.
• Perform other duties and responsibilities as assigned or required by management.

Qualifications – Required

• Relevant university degree (e.g., Actuarial Science, Statistics, Mathematics, Economics, Finance, Data Science, or a related field)
• Highly proficient in Microsoft Excel, including advanced formulas, pivot tables, Power Query, Macros and working with very large files
• Highly proficient in Microsoft PowerPoint, with the ability to build clear, compelling executive presentations
• Proficient in the use of AI tools such as Claude to analyze data, automate tasks, and improve productivity
• Proven ability to optimize large datasets and spreadsheets for speed, structure, and reliability
• Ability to turn complex data into clear insights and practical recommendations
• Solid understanding of data analysis and statistical concepts
• Strong attention to detail and commitment to data accuracy
• Experience with Microsoft 365 tools such as Teams, OneDrive, Outlook, and SharePoint

Assets:

• Knowledge of home and auto insurance and ratemaking (a significant asset)
• Actuarial knowledge or progress toward an actuarial designation
• Experience with SQL, Python, R, Power BI, or other data analysis and visualization tools
• Familiarity with the Canadian property and casualty insurance market

Soft Skills

• Strong analytical, critical thinking, and problem-solving capabilities
• Excellent verbal and written communication skills, including the ability to explain complex findings to non-technical audiences
• Collaborative approach, with the ability to work well with others across teams
• Strong organizational skills and the ability to prioritize competing requests
• Reliability with the ability to work independently and collaboratively in a hybrid environment
• Curiosity, adaptability, and willingness to learn new tools and applications, including emerging AI tools
• Discretion and professionalism in handling confidential and sensitive data

If you are looking for the opportunity for your career to take off, you’ve come to the right place!

Our perks ...

• You get your Birthday off.
• This role requires three in-office days per week.
• Full employer-paid benefits.
• Wealthsimple RRSP Match.
• Annual holiday festivities, free lunches and so much more.
• Helping you help others with our paid volunteer programs.
• Employee satisfaction survey for you to voice your opinion on working at Rates.ca Group Ltd.
• Free access to LinkedIn Learning.
• Lounge and games room: ping-pong, pool, foosball and more.

The compensation package consists of a competitive salary, benefits, and an incentive bonus.

Find out what it is like working at Rates.ca here: https://corporate.rates.ca/

Check out the primary brands that we work on here: https://corporate.rates.ca/#brand-snippet-ratesdotca

Rates.ca Group Ltd. and its subsidiaries are committed to being an Equal Opportunity Employer. We provide equal opportunity to all qualified individuals regardless of race, color, religion, age, gender, gender expression, national origin, veteran status, disability or any other legally protected categories such as sexual orientation. We believe that diversity, equity and inclusion are critical to our mission - creating a foundation for a creative workplace that leads to innovation and growth. We value diversity and strive to create an inclusive, accessible workplace where all individuals feel valued, respected, and heard.

We are committed to working with and providing accommodations to candidates and employees with physical or mental disabilities. If you require accommodation in order to search for a job opening or to complete any part of the application or hiring process, please send an email to [email protected].