Business Process Analytics Manager

Insight Global; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

An established industry player is seeking a detail-oriented Associate to take charge of performance reporting and analytics. In this dynamic role, you will leverage your expertise in SQL, Excel, and data visualization to create impactful dashboards and reports that drive business decisions. You will collaborate with various stakeholders to ensure data integrity and optimize reporting processes. If you are passionate about analytics and enjoy working in a fast-paced environment, this opportunity offers a chance to make a significant impact on organizational performance. Join a forward-thinking team where your insights will shape the future of data-driven decision-making.

Qualifications

• 3+ years of applicable experience in data analysis and reporting.
• Strong foundation in data and ability to pull from multiple sources.

Responsibilities

• Lead performance reporting and visualization for business partners.
• Analyze large datasets to drive insights and recommendations.

Skills

SQL

Excel

PowerPoint

SAS EG coding

Data visualization

Analytic capabilities

Communication skills

Creative problem-solving

Education

BS/BA in Commerce, Finance, Statistics, Quantitative Methods, Math, Computer Science, Marketing

Tools

Power BI

Microsoft Reporting Services

Spotfire

Tableau

Job description

This range is provided by Insight Global. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

CA$40.00/hr - CA$60.00/hr

The individual will have end-to-end project accountability. Beginning with understanding the business KPIs, they will leverage expertise in process design to determine an efficient and optimal process for delivering reporting results. Ad hoc analysis will be a component of the role, digging into new territory to identify areas for organizational improvement. Report development will include structuring the data flow and setting up automation. Ownership will continue post-implementation and include investigations, improvements, and managing ongoing partner relations.

Key Accountabilities

1. Analytic Capabilities & Critical Thinking:
   • Understand business KPIs and relevant drivers and factors that can help reach business objectives.
   • Internalize and understand the larger context of data elements at different levels (e.g. transaction, account, product, customer, employee, channel, line of business) and leverage a strong awareness of how these attributes intersect.
   • Analyze large, complex datasets (from multiple sources, both structured and unstructured) to drive insights and recommendations.
   • Be a practitioner of data best practices including QA, stable design, code optimization, and automation techniques.
   • Design and improve production and ad-hoc reporting processes with the goal of optimizing consumption and performance.
2. Design and Delivery of Performance Reporting and Dashboards:
   • Responsible for performance measurement reporting and visualization that monitors overall and incremental impact on process health in quantity and quality.
   • Lead the definition, creation, and maintenance of standardized dashboards and performance reporting for business partners.
   • Refine design proposals in collaboration with various stakeholders in Personal and Business Banking.
   • Apply thoughtful consideration to the best way to present complex materials in a consumable way.
   • Create new analyses and/or tools that deliver insights that enable business users to further their objectives.
3. Leadership and Relationship Management:
   • Work collaboratively with other analytics teams and business subject matter experts to refine personal understanding and ensure consistency in reporting and design.
   • Establish and communicate standards for accurate business requirement, technical specification, and work process documentation associated with our metrics and reporting.
   • Engage with business partners to ensure needs are met, update on delivery status, and provide transparency and clarity to results.
   • Leverage consultative skills and knowledge of best practices to provide guidance and consultative sessions with partners to share insights and recommendations rooted in data.
   • Consult with and deliver results to partners within tight time constraints that consistently meet or exceed their expectations.
4. Risk Management:
   • Ensure measurement reports meet governance and risk policies and identify opportunities and solutions for continuous improvements.

REQUIRED SKILLS AND EXPERIENCE

1. Knowledge:
   • BS/BA in Commerce, Finance, Statistics, Quantitative Methods, Math, Computer Science, Marketing, or similar.
   • 3+ years of applicable experience.
   • Strong foundation in data and analysis.
   • Ability to pull data from multiple sources and formulate comprehensive and actionable reports.
   • Strong analytic and pattern recognition to connect causal factors and form hypotheses.
2. Skills:
   • Expert proficiency in SQL, Excel, and PowerPoint.
   • Proficiency in SAS EG coding.
   • Strong communication skills (verbal & written); ability to provide concise, clear reporting, actionable analysis and presentations.
   • Ability to interact with all levels of end users and technical resources.
   • Experience in data visualization preferred, including visualization software such as Power BI, Microsoft Reporting Services, Spotfire or Tableau.
   • Creative problem-solving skills.
   • A ‘can-do’ attitude and passion for analytics including the insight and value it can provide.
   • Self-motivation and the capacity to work under pressure and tight deadlines.
   • Proven ability to self-check work to ensure results are error-free.
   • Ability to plan, organize, and work on multiple tasks simultaneously.

Seniority level

Associate

Employment type

Contract

Job function

Management

Industries

Banking