Job Description

Job Title : BI Analyst

Job Type : Contract; Full-Time

Location : Canada, Multiple Locations (Hybrid, 2 days / week)

Term : 2025 / 01 / 06 – 2025 / 06 / 30

About the Company :

Our client is a Crown corporation providing specialized and personalized financial services to farming operations. Our client offers financing, insurance, software, learning programs, and other business services to producers, agribusiness owners and agri-food entrepreneurs across the country.

Responsibilities :

Understand specific business domain(s) and drive insights from data, ensuring needs are met.

Create analytics solutions from a large variety of structures and sources.

Work with stakeholders and teams to ensure analysis is understandable and actionable across subject areas.

Analyse and reveal insights to decision makers and help with sense-making and recommendations.

Requirements :

Required Experience :

Experience and expert knowledge of data pertaining to customer analytics, project management reporting, strategic reporting, and Key Risk Indicators (KRIs).

A bachelor’s degree in agriculture, finance, business, economics, mathematics, statistics, or computer science and at least four years of experience (or an equivalent combination of education and experience).

An understanding of statistics and mathematics or data configuration combined with strong business domain knowledge.

Advanced working knowledge of data manipulation and management tools, as well as mastery of one or more visualization tools

Required Skills :

Ability to identify, source, link, manipulate, and interpret data and information, and turn this into actionable reports and insights for decision-making.

The work requires knowledge of IT systems and data, policies, and procedures.

Research, analytical, problem-solving skills and creativity are required.

Good levels of understanding of statistics and mathematics or data configuration combined with strong business domain knowledge.

An advanced working knowledge of data manipulation and management tools are required, along with the ability to quickly learn and adopt new tools as the industry evolves.

Has obtained mastery of one or more visualization tools.

Analyses and develops insights regarding the organization’s processes and metrics.

Communicates insights regarding the health of the loan portfolio to internal and / or external stakeholders.

Leads the development and execution of risk measurement processes for the client’s stress-testing program.

Requirements

Specific Project Requirements : Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. Demonstrated experience in SQL programming is required. Demonstrated experience in ETL is required. Strong knowledge and demonstrated experience in current and future state data mapping. Carry out data validation and identify and resolve discrepancies (format, content, values). Work with business team members on troubleshooting Top Skills Required : Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. Well-rounded experience in the whole data lifecycle management and hands-on experience in the following data management domains : dimensional and relational data modeling, data quality, SQL programming (minimum 5 years), ETL development, metadata management and master data management, and business intelligence. Experience with reverse engineering the source to target mapping to gain data insights Experience refactoring existing SQL code to new / alternate data sources. Other Skills Required : Experience with Azure Data Platform technologies or other public cloud offerings Programming experience : SQL Experience with Databricks Excellent verbal and written communication, critical thinking, time management, priority planning and interpersonal skills. Ability to understand and interpret requirements and design documents Ability to write and maintain documentation Demonstrated experience working with key business stakeholders in areas of Finance, Risk Management and Insurance Assets : Experience working in an Agile environment / team Bilingualism in both official languages (English and French) Greater than 5 years of SQL development and refactoring existing SQL