Senior Business Analyst – Data Visualization and Performance Measurement

Position Title:

Senior Business Analyst – Data Visualization and Performance Measurement

Division:

Real Estate

Department:

Realty Analytics and Client Integration – Quality Management & Reporting

ReportsTo:

Director, Contract Performance and Compliance

Position Purpose

To maintain annual key performance measurement frameworks, perform cyclical KPI scoring and exception process along with associated timelines and calendars for multiple stakeholders. To provide performance measurement analytical due diligence to deliver accurate scoring results for key performance indicators. Design new business intelligence capabilities to produce actionable insights using analytical, statistical and visualization techniques in collaboration with internal and external business partners

Key Function and Responsibilities

1. Develop and implement scoring methodologies to measure and document the achievements of business unit and corporate goal action plan indicators against targets, including milestones and establishing benchmarks.

 

  • Participate in the KPI scoring  methodology and change management processes for Property Land Management and Project Management service providers
  • Participate in the development of KPIs and document the definitions and scoring methodologies to be followed.  Present the final framework to internal workstreams and Real Estate executive team
  • Manage the production of KPI results from service providers in a consistent manner.  Review results with Director, Contract Performance and Compliance.  Ensure final results are communicated on a monthly basis, in advance of the next reporting cycle
  • Ensure the documented KPI results calculation methodology is followed with documented quality control and verification practices to withstand internal and external audits.
  • Ensure service provider KPI results are supported by valid documentation and coordinate random samples of documentation to investigate and audit KPI results
  • Participate in quarterly or other audit reviews and provide documentation to support findings to work stream leads
  • Establish a KPI exception process and document results for inclusion in PLMS and PMSP KPI results and fee at risk calculations
  • Advise service providers of the approval or denial of all requests for exceptions in a timely manner to enable final KPI scoring for the period
  • Summarize how KPIs are performing and present KPI results to senior staff; anticipate questions provide explanations for variances.
  • Collaborate with IO Finance and calculate  the fee at risk dollar amount owing and document method and results for PMSP projects
  • Represent IO interests in the areas of monthly, quarterly, and annual fee at risk calculations.
  • Verify the Property and Land Management Service Provider fee at risk calculation and invoices for accuracy and provide detailed analysis to senior management
  • Provide forecasting services and preparation of dashboards, scorecards and project status reports to internal and external stakeholders for monthly, quarterly and annual KPI scoring events

 

 

2. Maintain positive relationships  with Service Providers and lead KPI reporting activities

  • Provide knowledge and support for practical analytical problem solving.   Respond to day to day queries from the Service Providers Program Management representatives.   Follow through with formal communications to clarify reporting and/or KPI scoring processes
  • Lead monthly collaboration with service providers  meetings to progress reporting enhancements and information  quality  improvement initiatives
  • Ensure resolution of issues and concerns regarding KPI results and advise Director of potential issues and impacts
  • Ensure service provider livelink folder structure is maintained and that reports and related documentation is posted by the service provider in the appropriate location in a timely manner
  • Establish a contract deliverable protocol including document and records management to ensure that contractual deliverables from the service providers are received in accordance with predetermined deadlines and frequencies are accurate and complete.
  • Act as key liaison with service providers to coordinate and resolve financial and operational issues in consultation with IO Finance and Asset Management

 

 

3. Provide advanced analytics, information design best practices, and advanced data visualization techniques to create fully interactive tools to communicate business insights 

  • Leverage business intelligence applications such as PowerBI to transition KPI and performance metric analytics, scoring and reporting interactive formats
  • Collaborate with IT to define business requirements for direct data feeds between the data warehouse and PowerBI
  • Work closely with various departments to translate business requirements into dashboards, scorecards, trend analysis and reports; design and build static and interactive data visualization solutions using excel and business intelligence applications that will enhance understanding, clarify insights, and identify solutions for the business
  • Analyze data to identify trends, exceptions, and areas for further investigation and visualize findings in a variety of charts, interactive dashboards using PowerBI, and/or written reports
  • Ensure accuracy of information utilizing typical data quality functions involving standardization, transformation, rationalization, linking, matching and thorough analysis
  • Apply project management skills to balance competing priorities and meet/exceed project deadlines and commitments
  • Maintain or update business intelligence tools, databases, dashboards, systems, or methods. Manage timely flow of business intelligence information to users within cyclical reporting schedules

 

 

4. Develop and deploy reporting and performance management standards and processes

  • Develop an understanding of the IO real estate business and its drivers through IO's Corporate Annual Report, Business Plan and Real Estate Annual Report
  • Lead the design, development and delivery of reporting and performance measurement training programs including sources of information and output reports, dashboards and visualizations on an annual basis or as needed for IO internal staff, clients and external partners
  • Oversee the planning, scheduling and delivery of  training related to changes and improvements in reporting, information gathering and business applications
  • Continually identify gaps and training needs to improve staff competencies, and incorporate into the operational training program.
  • Ensure that the training program's objectives are clear and that the session learning outcomes are met
  • Ensure the comprehensive evaluation of the program and document lessons learned for future reference.
  • Hold focus groups to periodically review established processes, identify inefficiencies,  root cause evaluate impact of corrective action and recommend options
  • Identify gaps and recommend solutions to improve reporting and contract performance management standards, processes and forms for Real Estate Asset Management through non-conformance root cause resolution and team collaboration.

Qualifications

Education and Knowledge

  • Post-secondary degree/diploma in business administration, computer science, or statistics
  • Certified Business Intelligence Professional and/or PMP certification would be considered an asset

Experience

  • 2 to 5 years' experience in the business intelligence reporting and analytics domains to gather, analyze and report on measurement objectives; including a demonstrated ability to identify appropriate statistical analysis for large datasets
  • 3 years' experience using Microsoft Excel at an advanced level to perform macros, pivot tables etc.
  • 2 years' experience working with data analytics and visualization tools such as:  MS Power BI, Tableau, Python, Alteryx
  • Experience analyzing data sets and presenting those findings to customers
  • Experience with quality management processes and data cleansing activities
  • Experience developing performance measurement reports and delivering presentations to executives
  • Experience in the performance management of service provider and key performance indicators
  • Experience with automated workflow management systems  within the context of business processes
  • Experience developing strong relationships with a variety of stakeholders
  • Experience developing, documenting and implementing business processes related to performance measurement and contract management.

Skills and Personal Attributes

  • Strong knowledge performance measurement concepts from development, implementation to results validation
  • Strong analytical skills and systematic problem solving using data to influence business decisions
  • Ability to exercise independent judgment and drive initiatives to a successful conclusion
  • Ability to work conceptually and solve problems through design thinking
  • Ability to exercise independent judgment and drive initiatives to a successful conclusion
  • Skilled in hosting small and large group presentations and focus groups with strong interpersonal skills and ability to influence people through consultation, negotiation and consensus building
  • Excellent verbal and written communication skills to address client expectations and present recommendations
  • Understanding of data warehousing, data architecture, data quality processes, table structure,  dimension tables, data modeling and reporting process metadata
  • Strong knowledge of and commitment to effective program management and knowledge management principles, and an understanding of issues arising in the development and implementation of standard processes and knowledge tools.