Data Analyst

Agricorp is looking for aData Analystto join the Finance Operations team in the Corporate Services division. The Finance Operations team is looking to build and grow its data presentation and aggregation capabilities, harnessing the rich data sources available to provide digestible, relevant and actionable insights to our internal and external stakeholders. Agricorp’s Finance department is a dynamic, professional team responsible for day-to-day financial operations, treasury, investment, budgeting, reporting and financial analysis, and contributes overall to Agricorp’s strategic plan.

The Role

The Data Analyst will lead complex analysis, development and maintenance of multiple sources of data into visual dashboards, reports and data stories using business intelligence software and other tools as required. You will act as an internal expert on aggregation of data. As well, you will prepare reports for end users that communicate trends, patterns and predictions. In this role you will:

• Act as key member of team, responsible for delivering high quality solutions to meet business needs
• Support data loading, processing, pulling from multiple sources including Agricorp’s data warehouse
• Develop complex visual dashboards, reports and stories for end users to provide performance, trend analysis, projections, process initiation, forecasting and internal/external statistical data.
• Develop and test reports as requested by various departments across the organization. Identify the gaps and improvements that can be made to improve efficiency and effectiveness.
• Conduct complex data analysis and resolve data management to meet customer needs (i.e. testing of data accuracy prior to release)
• Acting as a bridge between the team and the business areas
• Develop and maintain a network of collaborative, cross-functional working relationships, at all levels, to allow proactive solutions for business issues or concerns
• Develop new or modify existing team processes, methodologies, templates and other approaches in compliance with industry standards and best practices and in consultation with the manager
• Provide recommendations to management for systems solutions and improvements enabling effective results in producing accurate, visually appealing reporting and data storyboarding

Job status: 2 year Contract
Location: Guelph
Work status: full time in office, remote or hybrid work arrangements offered

Qualifications

• Post secondary education and experience in business, computer science, statistics, finance, accounting, or equivalent experience
• 3-5 years’ progressive experience in a business information/data transformation role
• Superior data management skills including experience with business intelligence tools including Cognos, Power BI, Excel and data cleaning tools an asset
• Certificates in Data Analysis, Data Visualization and Business Intelligence an asset
• CPA designation an asset
• Programming experience an asset
• Finance and/or IT industry experience with data structure an asset
  

Key Competencies

• Achieving quality results –Focuses efforts on managing one’s self to achieve high-quality results consistent with the organization’s standards and measures, while managing risk
• Initiative –Identifies and deals with situations and issues proactively and persistently, seizing opportunities that arise
• Planning and organizing –Develops, implements, evaluates and adjusts plans to reach goals, while ensuring the optimal use of resources
• Analytical thinking – Interprets, links and analyzes information and situations by breaking them down into component parts, and identifying patterns, connections and underlying issues
• Information Gathering & Processing - Locating and collecting data from appropriate sources and analyzing it to prepare meaningful and concise reports that summarize the information.

Background

As an agency of the Government of Ontario, Agricorp works with partners to contribute to a vibrant and sustainable agriculture industry. With more than 300 employees serving more than 47,000 producers province-wide, Agricorp delivers programs that help producers manage risk. The agency was established in 1997 by the provincial government under the authority of the AgriCorp Act, 1996. Agricorp delivers a variety of programs and payments on behalf of the federal and provincial governments, including AgriStability, Farm Business Registration and Production Insurance. Please go to www.agricorp.com to see the full list of programs for more information.

Please submit your application for this position by March 25, 2022.

We thank all applicants for their interest; however, only those selected for an interview will be contacted directly.