Senior Data Analyst

About this role

*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):

87,200 - 106,600

About the role

We are seeking a skilled and detail-oriented Data Engineer to join our Audit team, within the subset team of Data Analytics. This role is pivotal in transforming diverse and complex data sources into clean, validated, and structured datasets that auditors can rely on for deep analysis and insights. You will work closely with audit professionals to understand their data needs and build scalable data marts and models using Power BI and other tools.

## Key Responsibilities

Data Development and Engineering

• Design and implement ETL processes to consolidate and clean data from various sources including Snowflake, Databricks, SQL databases, Excel files, SharePoint lists, and unstructured data sources.
• Acquire business context through walkthroughs and stakeholder engagement to ensure audit-relevant data is appropriately understood and used.
• Ensure data models are optimized for performance and usability.

Validation & Quality Assurance

• Validate data outputs against busin...