Data and Reporting Analyst

Role overview

Responsibilities

• Build dashboards using appropriate data extraction, cleaning, and visualization techniques.
• Deliver insights through reporting and data visualization; configure analytics solutions for consistent and repeatable use.
• Identify visualization improvements, trends, and patterns that turn raw data into actionable business insights.
• Work with teams, management, and stakeholders to improve the usability and presentation of analytics solutions.
• Translate business needs into technical specifications and evaluate existing visualization systems.
• Create visualizations of large data sets that make information intuitive for decision-makers.
• Document data flows, systems, and processes to improve business/group process design and management.
• Develop reporting tools and deliver training in reporting and self-service analytics for non-analytical users.
• Work independently on complex tasks, diagnose and solve problems, and take on broader accountabilities as needed.
• Apply the bank’s risk framework and make risk-informed decisions consistent with strategy, policies, and regulations.

Qualifications and skills

• Experience developing SQL queries to extract data.
• Experience with data mining software or languages such as SAS, SQL, or Python is an asset.
• Experience manipulating, aggregating, and analyzing data in MS Excel.
• Experience building reports with SSRS, Visual Studio, or Power BI.
• Related post-secondary degree or equivalent combination of education and experience; technical proficiency gained through education and/or business experience.
• Foundational proficiency in technical design optimization, decision-making, systems thinking, data visualization, data storytelling, data mining, illustration, creative thinking, and problem-solving.
• Intermediate proficiency in insights design and development, reporting, verbal and written communication, collaboration, analytical and problem-solving skills, and data-driven decision-making.

Pay information

• The listed salary range is $55,500–$120,000 and the pay type is salaried; no compensation cadence is stated.

Workplace

• This is a hybrid, Toronto-based role.