Sql data analyst Jobs in Richmond Hill, ON

Pay at Intact is about much more than just salary.

• 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)

Salary range (but not limited to):

74,800 - 91,400

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%

As part of our commitment to Win As A Team, we share our success with employees through our annual bonus plan and Employee Share Purchase Plan (ESPP) – with Intact matching 50% of your net shares.

Our pension offerings provide flexibility and long-term security for our employees beyond their careers. We are one of the few companies offering the opportunity to receive guaranteed income for life via our defined benefit pension plan.

Salary for the candidate will be determined taking into consideration a number of factors including: experience, skills, qualifications, anticipated contribution to role, internal equity, etc. The salary range presented above is based on a 35-hour workweek and would represent a majority of different candidate profiles. However, we encourage candidates who may fall outside of this range to apply as well.

About the role

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.

What you'll do here:

• 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.

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.

• 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

• Power BI expertise is an asset, including data model design, DAX calculations, and report/dashboard development

• 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

• 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).

• 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 however must be eligible to work in Canada.

#LI-Hybrid

Ce poste jouera un rôle essentiel au sein de notre équipe. | This position will fill an essential role in our team.