Senior Data Analyst

At Heartland Mutual Insurance, we're more than just a company — we're a community.

Proudly rooted in Ontario and Nova Scotia, we're driven by a bold vision: to be the Best Mutual. Our team of passionate professionals doesn't just follow the norm — we challenge it. We think differently, aim high, and deliver on our promise with a personal touch.

Here, you'll be part of a culture that values authenticity, embraces change, and empowers you to make a meaningful impact every day. Together, we bring our purpose to life by living our values and putting people first.

Senior Data Analyst - Waterloo, Ontario

What you will do...

• Data Engineering and Infrastructure

o Design, develop, and maintain ETL programs to our Analytics databases.

o Create and manage robust, scalable data marts including transactional, in force, new business, quote, claims, billing, and experience datasets.

o Collaborate with IT and Actuarial colleagues to ensure alignment on data architecture and sourcing.

• Data Quality and Governance

o Develop processes and standards to ensure data integrity, quality, and availability across all Actuarial databases.

o Conduct regular audits, monitoring, and issue resolution for data anomalies.

o Document data definitions, lineage, and transformation logic to support transparency and repeatability.

• Business Analysis and Ad Hoc Data Delivery

o Investigation and execution of complex, time-sensitive ad hoc data requests from Actuarial, Finance, Underwriting, and Executive teams.

o Translate business questions into analytical tasks and provide meaningful, actionable insights.

o Present findings clearly, using appropriate data visualization and narrative storytelling techniques.

• System Testing and Actuarial Support

o Support system testing related to rate changes, ensuring data accuracy and alignment with actuarial models and assumptions.

o Collaborate with Actuarial team members to validate test cases and outcomes, and provide insights to improve system changes.

o Assist with model input/output processes and ensure integration with actuarial tools

o Recommend and implement improvements to existing data workflows, tools, and systems.

o Mentor junior analysts or team members as needed and contribute to a culture of data excellence.

What you will bring...

• University degree (Computer Science, Data Science or a related discipline).
• A minimum of 2 years experience in a data analysis role, preferably with P&C insurance exposure or a significant educational background in a related discipline.
• Proficiency with SAS, SQL and Database Design concepts.
• Knowledge of Guidewire and P&C insurance is highly preferred.
• Demonstrated strength in oral and written communication skills.
• Proven ability to work independently and as part of a team.

The salary range for this role is $78,000 - $114,000. The salary for the successful candidate will be determined by various factors including but not limited to an individual's relevant experience, knowledge, skills, along with internal equity, and market considerations.

What's in it for You:

• A Supportive Team: We're not just a workplace, we're a community. We are small but mighty, we believe in the power of connection, purpose, and belonging.
• Comprehensive Total Rewards: Enjoy a competitive compensation package made up of base salary and bonus, health and wellness benefits, pension plan, paid time off, and so much more.
• Inclusive Culture: Work in an environment that embraces diversity, equity, inclusion and belonging.
• Career Growth & Development: Take advantage of continuous learning opportunities and stretch assignments.
• Make an Impact: Play a key role in helping customers navigate challenging situations with empathy and expertise.

This job posting is for an existing vacancy within Heartland.

Accommodation is available on request for candidates taking part in all aspects of the selection process.

We do not use artificial intelligence or automated decision-making tools in any part of our hiring process. All applications are reviewed by our Talent Acquisition team to ensure fairness and transparency.

At Heartland Mutual Insurance, you're empowered to thrive. Whether it's your career, your well-being, or your future, we've got you covered.