IT Business Analyst Specialist, Data & Analytics team

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’re looking for an IT Business Analyst Specialist to join our growing team!
What you’ll do here:

• Develop business cases, project charters, and user stories to support data engineering and analytics initiatives.

• Organize and facilitate requirements gathering workshops.

• Do impact assessment and effort estimation to help prioritize and approve solution.

• Document solution using efficient methods while interacting with Business users and IT teams.

• Define mapping allowing data flow through different layers of the Data Warehouse.

• Define business rules needed on the Data Warehouse in order to facilitate KPIs and Reporting definition.

• Support the solution development as well as technical analysis done by the team.

• Work closely with data engineers to define data architecture, data integration, and ETL (Extract, Transform, Load) processes.

• Collaborate with data scientists and analysts to understand analytical requirements and deliver actionable insights.

• Facilitate the development of dashboards, reports, and visualizations to support decision-making processes.

• Validate and test data models and analytical solutions to ensure they meet business requirements.

• Assist in the design and implementation of data pipelines that ensure the quality, consistency, and reliability of data.

• Ensure data governance and compliance standards are met.

• Support QA activities and Acceptance testing.

• Support the Product Owner in the definition and prioritization of the backlog.

• Document User Stories so they are clear for the developers and the QA team.

• Identify and communicate the impact on business processes in order to support change management with the data consumption teams.

• Build and maintain a robust documentation available to all the business stakeholders.

What you bring to the table:

• Bachelor’s degree in Computer Science, Information Technology, Business Administration, or a related field.

• Minimum 8 to 10 years of IT BA experience  in data engineering and data analytics environments.

• Strong understanding of relational data modelling (Data Vault, 3NF, Dimensional)

• Strong understanding of data engineering concepts, including data warehousing, ETL processes, and data integration.

• Proficiency in data analytics tools and technologies such as SQL, Python, BI tools (e.g., Power BI, Business Objects).

• Expertise in data profiling techniques and tools to assess data quality and integrity.

• Strong Oracle/snowflake database knowledge and PL/SQL queries.

• Strong understanding of Extract, Transform and Load (ETL) concepts

• Experience and knowledge of insurance industry concepts (Claims,policy).

• Excellent communication and interpersonal skills, with the ability to interact effectively with both technical and non-technical stakeholders.

• Knowledge of Agile framework (Scrum, Kanban)

• English is required, French an asset

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