Intermediate Technical Data Analyst

Intact FC • Montreal, QC

8d • Hybrid

About The Position

We are seeking a technical Data Analyst II with expertise in data engineering and BI development. In this role, you will deliver end-to-end analytics solutions. From raw data ingestion and transformation to executive-level dashboards. Enabling data-driven decisions across operational, market, and customer domains. If you thrive in complex data environments and love turning messy data into clean, actionable insights, this role is for you.

Requirements

• University degree in data-related field (i.e., Mathematics, Science, Statistics, AI, Computer Science, etc.), or any combination of equivalent education and experience.
• Deep knowledge of BI reporting tools such as Power BI.
• Advanced SQL Skills (Oracle, SQL Server, Snowflake).
• Solid understanding of data warehouse architecture, ETL/ELT processes, and dimensional modelling.
• 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.
• Ability to translate complex technical findings into clear business narratives.
• Motivated to learn new business and technical concepts.
• For candidates located in Quebec, bilingualism is required considering the necessity to interact on a regular basis with English-speaking colleagues across the country.
• Must be eligible to work in Canada.

Nice To Haves

• Power BI expertise is an asset, including data model design, DAX calculations, and report/dashboard development.
• Past experience in major enterprise with big contact center and sales department.
• Experience in the insurance industry.
• Experience with the agile methodology.

Responsibilities

• Design and develop reporting to test, track and improve results for new and ongoing initiatives.
• Architect and automate data pipelines to ingest, transform, and distribute data from multiple sources to internal and external stakeholders.
• Analyze and optimize the use of data and platforms to drive growth.
• Perform continuous improvement to tools, data and reports developed or used by the team.
• Ensure solutions are released properly, and each release is documented.
• Analyze product, market, and trends to build data models.
• Propose data schema and data flow optimization for reporting performance and enhancement as needed.
• Work with data warehouse architects, data scientists, and data collection application engineers.
• Generate and deliver quality reports to operation and perform quality assurance checks on reports.
• Troubleshoot and solve problems on data models.
• Set up and maintain BI tools, infrastructure, and integration with company data sources.
• Translate business requirements and problems into innovative technical solutions.
• Use data to generate reports to support business decision-making and business performance monitoring.
• Develop reporting systems that provide accessible information for decision-making.

Benefits

• Flexible work arrangements and a hybrid work model
• Possibility to purchase up to 5 extra days off per year
• Multiple benefits offered to support physical and mental wellbeing, including telemedicine, Wellness account and much more
• Share plan & other savings: up to 12% of salary or even more (ask how you could earn guaranteed income for life)
• Annual bonus target, based on the base salary, with a potential payout of up to double the target (subject to personal and company performance): 7.5%
• Employee Share Purchase Plan (ESPP) – with Intact matching 50% of your net shares
• Defined benefit pension plan, offering the opportunity to receive guaranteed income for life

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees