Job Title: Data & Reporting Analyst

Location: Toronto, ON M5X 1A1 (Hybrid - 2 days in office per week)

Duration: 12 months

Contract Type: T4

Pay Rate: CA$47.77 – CA$48.78/Hour

Role Responsibilities:

• Consults on analytical solutions to understand, analyze, and synthesize requirements, goals and objectives relative to data and business intelligence needs and to enable high-quality, fact-based business decisions to drive better business outcomes.
• Provides advice on the configuration, functionality, applicability, and usability of data management, data analytics, and data visualization technology solutions. Supports the development of the strategy and roadmap for data quality and data analytics, and dashboard reporting.
• Designs, develops, and implements innovative analytical solutions.
• Breaks down strategic problems, and analyses data and information to provide subject matter insights and recommendations.
• Structures and assembles data into multi-dimensions with various granularities
• Integrates information from multiple sources to enable more efficient processes, enhanced analysis and/or streamlined reporting.
• Builds reports and visualizations to effectively communicate data driven insights to users for a variety of audiences e.g. visualization solutions of data into reports, graphics, dashboards to illustrate facts, trends, and insights.
• Supports development and execution of strategic analytics & reporting initiatives in collaboration with internal and external stakeholders.
• Analyzes data and information to provide subject-matter insights and recommendations.
• Develops tools and delivers training programs for use of reporting tools and self-serve analytics by non-analytical end users; may include delivery of training to audiences.
• Collaborates with internal and external stakeholders in order to deliver on business objectives.
• Works independently on a range of complex tasks, which may include unique situations.

Must Have Skills:

• At least 3-5 years of experience within the field
• Excellent Oral and written communication skills
• Advanced Excel skills - VBA and Macros running queries
• Great Stakeholder management skills, Experience leading meetings
• Experience with Manual Data Validation into an automation tool with clear examples of this experience.
• 3-5 years of experience using Power Query in Excel

Nice To Have:

• Experience using RSA-ARCHER 3-5 years (Outline areas of experience)