Data Developer

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.

About the role

We are looking for a skilled and detail-oriented Data Developer to join our Audit team.

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. 

What you’ll do here:

• Data Integration & Preparation:

  • Ingest and transform data from various sources including SQL databases, Excel files, SharePoint lists, and unstructured data sources. 

  • Design and implement ETL processes to consolidate and clean data for audit use. 

• Data Modeling & Development:

  • Build and maintain Power BI data marts and semantic models tailored to audit requirements. 

  • Ensure data models are optimized for performance and usability. 

• Validation & Quality Assurance:

  • Validate data outputs against business reports and known benchmarks to ensure accuracy and completeness. 

  • Implement data quality checks and reconciliation processes. 

• Collaboration & Support: 

  • Work closely with auditors to understand data requirements and provide technical support. 

  • Document data flows, transformations, and business logic for transparency and auditability. 

• Continuous Improvement: 

  • Identify opportunities to automate and streamline data preparation processes. 

  • Stay current with best practices in data engineering and analytics. 

What you bring to the table:  

• 2-5 years of experience in data analysis.

• Proven experience in data development, data engineering, or BI development. 

• Strong SQL skills and experience working with relational databases. 

• Expert-level proficiency in Power BI, including data modeling, DAX, and Power Query. 

• Experience working with SharePoint, semi-structured, and unstructured data sources. 

• Understanding of data governance, validation, and reconciliation techniques. 

• Excellent problem-solving skills and attention to detail. 

• Strong communication skills and ability to work collaboratively with non-technical stakeholders. 

• Experience in an audit, finance, or compliance environment is a plus.

• Knowledge of Python, Power Automate, or other automation tools is a plus. 

• 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 Canadian work experience required, but must have authorization to work in Canada.

#LI-Hybrid

What we offer
 

Our hybrid work model provides the balance between working from home and enjoying meaningful in-person interactions.

Working here means you'll be empowered to be and do your best every day. Here is some of what you can expect as a permanent member of our team:

• A financial rewards program that recognizes your success

• An industry leading Employee Share Purchase Plan; we match 50% of net shares purchased

• An extensive flex pension and benefits package, with access to virtual healthcare

• Flexible work arrangements

• Possibility to purchase up to 5 extra days off per year

• An annual wellness account that promotes an active and healthy lifestyle

• Access to tools and resources to support physical and mental health, embracing change and connecting with colleagues

• A dynamic workplace learning ecosystem complete with learning journeys, interactive online content, and inspiring programs

• Inclusive employee-led networks to educate, inspire, amplify voices, build relationships and provide development opportunities

• Inspiring leaders and colleagues who will lift you up and help you grow

• A Community Impact program, because what you care about is a part of what makes you different. And how you contribute to your community should be just as unique.

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.

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