Analyst Business Intelligence (BI)

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 Business Intelligence (BI) Analyst with multiple talents to join our dynamic national BI team. Reporting to the Manager of BI, the BI Analyst will be working on designing various analytical reports on multiple data sources and delivering them to management and other interested parties. The BI Analyst works collaboratively with end users and the BI Team to develop reporting systems that provide accessible information for decision-making. The BI Analyst uses data to solve organizational problems through reports, analysis and data visualization. The BI Analyst will provide his/her data expertise with emphasis on data design, access, usage, security and quality of information assets.

The BI Analyst should be analytical and have excellent communication skills since he/she will be presenting the results of his/her work. We are looking for a person with an acute business sense and strong problem-solving skills. As an ideal candidate, you have an in-depth proficiency with data, databases and ETL frameworks. You will bring Business Intelligence projects to life; from the inception to the delivery to operations.

What You Will Accomplish With Us:

1. Develop reporting systems that provide accessible information for decision-making.
2. Use data to generate reports to support business decision-making and business performance monitoring.
3. Translate business requirements and problems into innovative technical solutions.
4. Evaluate and improve existing BI systems.
5. Set up and maintain BI tools, infrastructure, and integration with company data sources.
6. Troubleshoot and solve problems on data models.
7. Generate and deliver quality reports to operation and perform quality assurance checks on reports.
8. Work with data warehouse architects, data scientists, and data collection application engineers.
9. Propose data schema and data flow optimization for reporting performance and enhancement as needed.
10. Analyze product, market, and trends to build data models.
11. Create prototypes and proof of concepts.
12. Ensure solutions are released properly, and each release is documented.
13. Create and maintain unit and functional tests.

What You Bring To The Table:

1. University degree in data-related field (i.e., Mathematics, Science, Statistics, AI, Computer Science, etc.), or any combination of equivalent education and experience.
2. 3 to 5 years of experience as a Data Analyst or relevant experience.
3. Deep knowledge of BI reporting tools such as Power BI.
4. Solid experience with databases (Oracle, SQL Server, Snowflake) and ETL tools.
5. Understanding data and query optimization, query profiling, and query performance monitoring tools and techniques.
6. Strong problem-solving and analytical skills.
7. Great attention to detail.
8. Ability to work in a team.
9. Good communication skills.
10. Autonomous and with initiative.
11. Ability to think logically and troubleshoot issues.
12. Motivated to learn new business and technical concepts.
13. Past experience in major enterprise with big contact center and sales department (An asset).
14. Experience in the insurance industry (An asset).
15. Experience with the agile methodology (An asset).
16. For candidates located in Quebec, bilingualism is required considering the necessity to interact on a regular basis with English speaking colleagues across the country.
17. No Canadian work experience required however must be eligible to work in Canada.

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:

1. A financial rewards program that recognizes your success.
2. An industry leading Employee Share Purchase Plan; we match 50% of net shares purchased.
3. An extensive flex pension and benefits package, with access to virtual healthcare.
4. Flexible work arrangements.
5. Possibility to purchase up to 5 extra days off per year.
6. An annual wellness account that promotes an active and healthy lifestyle.
7. Access to tools and resources to support physical and mental health, embracing change and connecting with colleagues.
8. A dynamic workplace learning ecosystem complete with learning journeys, interactive online content, and inspiring programs.
9. Inclusive employee-led networks to educate, inspire, amplify voices, build relationships and provide development opportunities.
10. Inspiring leaders and colleagues who will lift you up and help you grow.
11. 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.