Business Analyst

  • Ontario, Canada View on Map
  • Post Date : October 28, 2020

Job Detail

  • Sector Business Analyst
  • Experience Greater Than 10 Year
  • Qualifications Degree Bachelor

Job Description

Hope you are doing well!

We are working on the RQ00136 – Business Analyst that is available with one of our client Ministry of Treasury Board Secretariat in Toronto.

If you have the required experience and are available for new opportunities, please send the following documents at by Friday, October 30th, 10:00 am EST.

1. Updated Resume in word format
2. Completed Skills Matrix
3. Hourly Rate Expectation and Availability
4. Right to Represent Form

Job Title: RQ00136 – Business Analyst
Organization: Central Agencies Cluster
Ministry: Ministry of Treasury Board Secretariat
Office Location: Toronto
Estimated Start Date: 2021-01-21
Estimated End Date: 2021-03-31
# Business Days: 60

Extension of Days: 64

Security Level: CRJMC

Project Background Information

  • ORBIT corporate reporting is used extensively for management reporting, fiscal plan rollups, and internal briefings, and is based on legacy versions of Oracle Essbase / Dodeca running on Windows 2003 in Kingston Data Centre (KDC).
  • Windows 2003 is the Operating System which hosts the existing corporate reporting datastore. Support for Microsoft Windows 2003 ended globally in July 2018; no service packs or patches are available. This has introduced considerable risk – if security issues cannot be remediated locally, the service will be subject to removal from the OPS network as per CSB policy.
  • Providing a stable, modern, expandable reporting data warehouse capable of meeting current and future needs is a foundational component to ORBIT reporting modernization.
  • A modern reporting data warehouse can be used in conjunction with any front-end reporting tool and will be used to inform an assessment in the selection of a reporting platform.
  • This phase of work is a critical step to modernizing and remediating the technology risks associated with the existing ORBIT reporting application.


Job Description:


  • Working on the ORBIT program completing project implementation and support, this role is more so a hybrid of business intelligence consultant and BA/QA.

Must Haves:

  • 10 Years of experience in full scale DW testing
  • Experience testing Cognos, OBIEE
  • Experience Data Modelling


  • Public Sector Experience
  • Experience testing large data sets/budgeting platforms

The Senior Business Analyst will work closely with the Business Team, Business Architect, Systems Architect, Solution Architect, Development Team and Project Manager to ensure completeness of requirements to develop an enterprise Financial Data Warehouse capable of full-filling business expectations. The Sr. Business Analyst will need to understand how business requirements impact the Data Warehouse strategy, prioritization, and translate into technical requirements. The Sr. Business Analyst will collaborate with the client to establish test plans and validate data, structures, sources though reporting functions. The Sr. Business Analyst will also be responsible prepare documentation necessary for implementation.


Required Skillset:

  1. Candidate should have 10+ years’ experience in business analysis and modeling with at least 5+ years experience in Data Warehouse and Business Intelligence projects.


  1. 10+ years’ experience in applying business modeling techniques/tools in a way that the developed artifacts can be reused and leveraged for multiple projects
  2. Experience with the following:
  • Experience with Business Intelligence / OLAP / Analytical tools
  • Developing Test Strategy / Test Plans / Test Cases
  • Leading QA / UAT / Testing Activities Report Design, report testing in ETL
  • SQL scripting to perform Data Validations
  • Performance Testing
  • Documenting Test Results
  • Experience with OBIEE, Microsoft Power BI, Cognos reporting environment a plus
  • Experience with Microsoft DevOps or VSTS


  1. Experience in structured, object oriented and agile methodologies for users-requirements elicitation and the development of specifications


  1. Experience in UML (Unified Modeling Language)
  2. Experience in the use of Computer Aided Software Engineering (CASE) tools to document conceptual requirements and scope (e.g., Sparx Systems Enterprise Architect CASE tool)


  1. Proven ability to support the client in development of presentation materials, briefing notes, etc. related to the project.
  2. Ensure that the artifacts are aligned with the enterprise architecture standards and principles (i.e., GO-ITS 56)
  3. Understanding of OPS Budget cycle

Experience and Skill Set Requirements

Testing Skills – 30%

  • Test Strategy, plan, cases
  • ETL Testing
  • Performance testing
  • DevOps testing, Visual Studio Teams Services (VSTS)


Business Analysis, Analytics Tools – 20%

  • Experience in Data Warehouse and Business Intelligence projects


Data modelling – 10%

  • Experience with Data modelling, Information Architecture/Design


Ontario budget process – 10%

  • Knowledge and familiarity of Ontario budget process

Attached Files

Other jobs you may like