Business intelligence Jobs in Mont-Royal, QC

JOB DESCRIPTION

About the role

From coast-to-coast, our inspiring colleagues are at the heart of what we do best : helping people, businesses and society prosper in good times and be resilient in bad times. With our team, you’ll bring this purpose to life every day by living our Values, being open to change, and pursuing your goals.

At belairdirect, we’ll give you countless opportunities to learn and grow, alongside a diverse and passionate community of experts – the best the industry has to offer. You’ll be empowered to be your best self, do your best work, and make a meaningful impact. Here, you can : shape the future of insurance, 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'll do here :

Develop reporting systems that provide accessible information for decision-making.

Use data to generate reports to support business decision-making and business performance monitoring.

Translate business requirements and problems into innovative technical solutions.

Evaluate and improve existing BI systems.

Set up and maintain BI tools, infrastructure, and integration with company data sources.

Troubleshoot and solve problems on data models.

Generate and deliver quality reports to operation and perform quality assurance checks on reports.

Work with data warehouse architects, data scientists, and data collection application engineers.

Propose data schema and data flow optimization for reporting performance and enhancement as needed.

Analyze product, market, and trends to build data models.

Create prototypes and proof of concepts.

Ensure solutions are released properly, and each release is documented.

Create and maintain unit and functional tests.

What you bring to the table :

University degree in data-related field (i.e., Mathematics, Science, Statistics, AI, Computer Science, etc.), or any combination of equivalent education and experience.

3 to 5 years of experience as a Data Analyst or relevant experience

Deep knowledge of BI reporting tools such as Power BI.

Solid experience with databases (Oracle, SQL Server, Snowflake) and ETL tools.

Understanding data and query optimization, query profiling, and query performance monitoring tools and techniques.

Strong problem-solving and analytical skills.

Great attention to detail.

Ability to work in a team.

Good communication skills.

Autonomous and with initiative.

Ability to think logically and troubleshoot issues.

Motivated to learn new business and technical concepts

Past experience in major enterprise with big contact center and sales department (An asset).

Experience in the insurance industry (An asset)

Experience with the agile methodology (An asset).

Bilingual (French and English) : Need to interact on a regular basis with an English-speaking clientele and colleagues across the country. ​

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.