Data Analyst II, Legal Claims & Casualty (LCC) (12month contract)

Our employees are at the heart of everything we do. Together, we help people, businesses, and society prosper in good times and be resilient in bad times.

Our employee promise represents Intact's commitment to you in exchange for living our Values, striving to do your best work, being open to change and investing in your career. In return, we promise to provide support, opportunities and performance-led financial rewards at a workplace where you can shape the future, win as a team and grow with us.

Salary for the candidate will be determined taking into consideration a number of factors including: experience, skills, qualifications, anticipated contribution to role, internal equity, etc. The salary range presented below is based on a 35-hour workweek and would represent a majority of different candidate profiles. However, we encourage candidates who may fall outside of this range to apply as well.

Salary range (but not limited to):

69,200 - 84,600

About the role

We are looking for a Data Analyst II for a 12-month temporary position. If you are passionate about data, innovation, automation, and solving complex problems, this opportunity will allow you to have a tangible impact on the analytical future of LCC.

The Projects and Data team within the Civil Liability and Legal Services for Compensation (LCC) division transforms data into visual narratives that bring information to life. Through strategy, analytics, governance, and national project management, we convert complex data into actionable insights that directly influence business decisions, strategic initiatives, and operational performance.

We are currently at the forefront of a major transformation of our analytics ecosystem with the adoption of Databricks. Over the coming months, our priority will be to lay the groundwork for this new platform, working closely with the Claims Actuarial (CDAT) and Claims Finance teams, as well as LCC's business partners. Together, we are modernizing our reporting, automating our analytical solutions, and pushing the boundaries of what we can achieve with data.

In this role, you will transform raw data into high-quality analytical datasets, develop and maintain reports in Databricks, and collaborate closely with LCC business analysts, business partners, and the CDAT and Finance teams.

What You'll Accomplish with Us

• Develop, optimize, and maintain reports, dashboards, and analytical solutions for the Liability and Claims Legal (LCC) department, primarily in the Databricks environment.
• Design, produce, and publish reports for various stakeholders across the organization.
• Monitor, identify, and analyze performance trends; explain observed variances; and make recommendations to drive results and productivity.
• Consolidate data from multiple sources while ensuring its quality, integrity, and reliability.
• Create and maintain a data inventory, and support the tracking of key performance indicators (KPIs).
• Proactively identify new data sources and data elements to enrich the analysis of performance and business trends.
• Analyze, synthesize, and present information in a clear, concise manner tailored to various audiences within the LCC.
• Produce and maintain high-quality documentation to support training, the implementation of best practices, and process standardization.
• Collaborate with claims and LCC project teams to develop new Power BI reports and dashboards.
• Respond to ad hoc analysis and reporting needs as they arise.
• Work closely with key data teams, including Actuarial, CDAT, and LCC project managers.
• Actively contribute to the evolution, modernization, and adoption of Databricks within the organization.

What You'll Bring to the Table

• A bachelor's degree in computer science, mathematics, data science, actuarial science, or an equivalent combination of education and experience-required.
• Proficiency in Python and SQL-required.
• Experience with data visualization and business intelligence tools, including Power BI and DAX-required.
• Experience with artificial intelligence agents and tools such as ChatGPT, Cortex Code (Snowflake), Rovo (Confluence), or comparable solutions-required.
• Experience with GitHub and code management and control practices-required.
• A solid understanding of data governance, privacy, and security principles.
• Experience with Confluence or other knowledge management platforms.
• Experience in data modeling, transformation, and integration.
• Experience with cloud-based data warehouses, including Snowflake and Databricks.
• Strong knowledge of data quality, validation, and documentation practices.
• Excellent analytical, organizational, and problem-solving skills.
• Ability to communicate effectively with both technical and non-technical stakeholders.
• Frequent interactions with colleagues across the country.
• Bilingualism (English/French) - For candidates located in Quebec, bilingualism is required considering the necessity to interact on a regular basis with English-speaking colleagues across the country.
• No work experience in Canada is required, but you must be eligible to work in Canada.

Assets

• Experience with data pipelines and process orchestration.
• Experience in the fields of actuarial science, insurance, or claims.
• Knowledge of modern analytics environments and data automation solutions.

Il s'agit d'un nouveau rôle au sein de notre équipe en pleine croissance This role is a new member of our growing team.

We are an equal opportunity employer

At Intact, our Value of respect is founded on seeing diversity as a strength. We strive to create an accessible workplace where employees feel valued, included and encouraged to share their unique perspectives.

We encourage applications from individuals who are members of equity-deserving groups, including but not limited to women, Indigenous peoples, persons with disabilities, Black people, and members of the 2SLGBTQI+ community.

As part of Intact's commitment to reconciliation, we acknowledge that we work, meet and travel across the land currently called Canada, originally inhabited by First Nations, Metis and Inuit people. This history extends through many centuries and continues to evolve today.

We have policies to ensure equal access and participation for people with disabilities, including providing workplace adjustments (accommodations). A copy of applicable policies is available on request.

If we can provide a specific adjustment to make the recruitment process more accessible for you, please let us know when we reach out about a job opportunity. We'll work with you to meet your needs.

Learn more about our recruitment process and your candidate journey here.

Please note that Intact does not provide sponsorship or other support for immigration-related matters including but not limited to employer-specific closed work permits. Candidates must be eligible to work in Canada from the anticipated start date and throughout their employment and are solely responsible for maintaining their work eligibility.

If you are an employee of Intact or belairdirect, please apply for this role on Internal Career Site.