Data Analyst - PowerBI developer

Toronto, 700 University Avenue, Canada

Intact

Intact is the largest provider of property and casualty insurance in Canada through its subsidiaries Intact Insurance, belairdirect and Brokerlink.

View all jobs at Intact

Apply now Apply later

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

Who needs insurance? Everybody. That keeps us busy. Very busy.

At the Intact Lab, we use machine learning, data science, software engineering, AI, agility, UX and design thinking to transform the customer experience for millions of Canadians. 

Simplifying insurance takes creativity, empathy and hard work. We explore, take risks, make mistakes, and learn all day, every day.

Here, innovation is everyone's job. Ready to make your mark? 

We are looking for a Data Analyst, PowerBI developer to join the Lab team and work closely with the different squads (analytics, product&design) of our various brands. The ideal candidate demonstrates curiosity and proactivity using their expertise to contribute to the Lab’s objectives by developing dashboards monitoring our digital product performance. They will aim to integrate new data sources, set up automation processes and create new reports to allow an omnichannel (360) view of the Digital Lab's products.

What you'll do here: 

  • Act as a specialist in dashboard development and data pipelines, using tools such as Power BI (desktop and cloud), Power Query, Power Automate, SQL and advanced Excel.

  • Develop, produce and visualize data from multiple sources in the organization to provide a good overview of the Lab’s products performance.

  • Bring improvements and optimizations to dashboards on a regular basis considering the needs of internal customers.

  • Dig, format and validate new data sources that could benefit internal customers.

  • Ensure the quality of the data implementation.

  • Work hand in hand with analytics, products and UX teams, to ensure that the data and reports provided correspond to their needs.

  • Collaborate with different internal teams to ensure a common source of truth regarding the data showcased in the dashboards.

  • Respond to ad hoc data requests.

What you bring to the table: 

  • Passionate about digital, data and dashboarding

  • Advanced PowerBI skills and hands-on experience, incl. using DAX and Power Query

  • Intermediate to advanced SQL knowledge

  • Ability to manage large volumes of data, clean, integrate them into a dashboard and create appropriate visualization

  • Experience working with web analytics tools (Google Analytics, Adobe Analytics, Amplitude, etc.) – an asset

  • Experience working in Snowflake or similar cloud data warehouse platforms - an asset

  • Experience in process automation

  • Extremely strategic and creative in the integration and use of data

  • Analytical mind, autonomous, organized and solution-oriented

  • Ability to present innovative solutions for data integration and process optimization

  • Aptitude/interest in omnichannel data analysis

  • Strong stakeholder management and communication skills, with the ability to collaborate across different levels of the organization.

  • No Canadian work experience required however must be eligible 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.

Apply now Apply later

* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰

Job stats:  0  0  0

Tags: Amplitude CX Data analysis Data pipelines Data warehouse Engineering Excel Machine Learning Pipelines Power BI Snowflake SQL UX

Perks/benefits: Career development Equity / stock options Flex hours Health care Wellness

Region: North America
Country: Canada

More jobs like this