Business Intelligence Analyst
Business Intelligence Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Job Title: BI Analyst
Job Type: Contract; FullTime
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 agrifood 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 sensemaking 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 decisionmaking.
The work requires knowledge of IT systems and data policies and procedures.
Research analytical problemsolving 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 stresstesting program.
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
Employment Type
Full Time
