Scope

• 
  The Office of the Public Guardian and Trustee (OPGT)
  requires a Senior Business Analysts to assist with report development for the
  new data warehouse/lakehouse and associated data migration activities.

Assignment Deliverables

As a member of the OPGT modernization data analytics and
reporting team, you will be responsible to build and deliver modernized reports
from the new data warehouse/lakehouse. A high-level list of deliverables
follows:

• 
  Lead and conduct business and system analysis in respect to
  building the golden layer of the data lakehouse and modernized reports in
  PowerBI..
• 
  Lead the effort into defining the reporting MVP; document
  legacy reports in scope of MVP; conduct gap analysis and provide
  recommendations.
• 
  Document report requirements in user stories in DevOps.
  Conduct analysis at varying levels of detail, appropriate to the project and
  phases of project, aligning with OPS standards.
• 
  Liaise between Business Areas and the data migration and
  reporting team, to clarify business requirements and translate them into system
  and reporting requirements.
• 
  Conduct business modeling; use case modeling; conceptual and
  logical data modeling; process and data flow modeling; use case surveys;
  business rules definition and non-functional requirements definitions for
  assigned projects, including report requirements, screen specifications,
  business rules, data migration requirements, etc.
• 
  Produce/update documentation which will allow future support
  of the implemented solutions.
• 
  Assist with identifying and resolving data quality issues,
  defining test cases, performing data reconciliation, and addressing any issues
  or discrepancies that arise during the testing phase; developing KPIs to report
  on the progress, completeness and quality of the reporting and data migration
  effort.
• 
  Ongoing Support: provide post-migration support, analyze and
  address data-related issues or questions; help with optimizing data management
  processes in the new environment.
• 
  Other duties as assigned.

The Vendor’s Personnel will also be required to:

• 
  Complete work and achieve milestones within the assigned
  deadlines.
• 
  Notify the Cluster/Ministry project Manager in writing of
  any issues or other material concerns related to the Assignment Deliverables,
  as soon as he/she becomes aware of them
• 
  Submit Deliverables for the Cluster/Ministry approval as
  they are completed.
• 
  Comply with the Ontario Government and the Cluster/Ministry
  security procedures and practices
• 
  Comply with the Ontario Government and the Cluster/Ministry
  architecture/technology standards and best practices
• 
  Comply with the Ontario Government and the Cluster/Ministry
  Conflict of Interest and Confidentiality Guidelines
• 
  Provide knowledge and skill transfer to a designated
  Cluster/Ministry staff; and
• 
  Comply with the Ontario Government I&IT Directive,
  Operational Policy on the I&IT Project Gateway Process, and other
  applicable Guidelines, Standards and Procedures.

Requirements

Experience and Skill Set Requirements:

Must Haves:

• 
  10+ years of experience leading and conducting business and
  system analysis to assess client’s business problems/opportunities and document
  the business/system requirements in such a way that I&IT solutions can be
  designed.
• 
  Proven experience in both agile and waterfall project
  management methodologies.
• 
  Proven experience in conducting business and system analysis
  in respect to building data marts/data warehouses/data lakehouse or Business
  Intelligence/Data Analytics and Reporting solutions.
• 
  Demonstrated experience working as a business analyst in
  large/complex data migration projects.
• 
  Demonstrated experience with writing user stories and using
  tools such as DevOps.

Skill Set Requirements:

Mandatory Requirements
:

• 
  10+ years of experience leading and conducting business and
  system analysis to assess client’s business problems/opportunities and document
  the business/system requirements in such a way that I&IT solutions can be
  designed.
• 
  Proven experience in both agile and waterfall project
  management methodologies.
• 
  Proven experience in conducting business and system analysis
  in respect to building data marts/data warehouses/data lakehouse or Business
  Intelligence/Data Analytics and Reporting solutions.
• 
  Demonstrated experience working as a business analyst in
  large/complex data migration projects.
• 
  Demonstrated experience with writing user stories and using
  tools such as DevOps.

Desired Skills and Experience
:

• 
  10+ years of experience leading and conducting business and
  system analysis to assess client’s business problems/opportunities and document
  the business/system requirements in such a way that I&IT solutions can be
  designed.
• 
  Experience conducting analyses at varying levels of detail,
  appropriate to the project and phases of project, aligning with OPS standards.
• 
  Experience conducting business modeling; use case modeling;
  conceptual and logical data modeling; process and data flow modeling; use case
  surveys; business rules definition and non-functional requirements definitions
  for assigned projects, including screen specifications, business rules, data
  migration requirements, etc.
• 
  Proven experience in both agile and waterfall project
  management methodologies.
• 
  Proven experience in conducting business and system analysis
  in respect to building data marts/data warehouses/data lakehouse or Business
  Intelligence/Data Analytics and Reporting solutions
• 
  Demonstrated experience working as a business analyst in
  large/complex data migration projects.
• 
  Familiarity with BI/reporting tools such as PowerBI
• 
  Basic knowledge of SQL language; ability to execute SQL
  queries.
• 
  Understanding of concepts around ETL, data quality, data
  cleaning, data issues’ handling.
• 
  experience in conducting business and system analysis for a
  Dynamics 365 CE and/or F&O solution or other CRM/ERP solutions.
• 
  Experience creating use cases, test plans, test cases, test
  scripts ideally around reporting and/or data migration.
• 
  Experience with defect management processes, defect
  identification, logging, tracking, and resolution.
• 
  Familiarity with industry-standard quality assurance
  practices, such as ISO standards, CMMI, or Agile methodologies
• 
  Experience consulting and coordinating between Business
  Areas and the IT Development and Testing teams to clarify business requirements
  and translating them into system requirements.
• 
  Critical thinking, analytical and problem-solving skills;
  proven gap analysis experience
• 
  Excellent verbal and written communication skills
• 
  Proven ability to engage with stakeholders and build strong
  working relationships.
• 
  Demonstrated experience with writing user stories and using
  tools such as DevOps.

Business Analysis Experience:

• 
  10+ years of experience leading and conducting business and
  system analysis to assess client’s business problems/opportunities and document
  the business/system requirements in such a way that I&IT solutions can be
  designed.
• 
  Experience conducting analyses at varying levels of detail,
  appropriate to the project and phases of project, aligning with OPS standards.
• 
  Experience conducting business modeling; use case modeling;
  conceptual and logical data modeling; process and data flow modeling; use case
  surveys; business rules definition and non-functional requirements definitions
  for assigned projects, including screen specifications, business rules, data
  migration requirements, etc.
• 
  Proven experience in both agile and waterfall project
  management methodologies, with emphasis on agile.

Dynamics 365 CE / F&O Experience:

• 
  Proven experience in conducting business and system analysis
  in respect to building data marts/data warehouses/data lakehouse or Business
  Intelligence/Data Analytics and Reporting solutions built against Dynamics 365
  CE and F&O data
• 
  experience in conducting business and system analysis for a
  Dynamics 365 CE and/or F&O solution or other CRM/ERP solutions

Quality Assurance:

• 
  Experience creating use cases, test plans, test cases, test
  scripts ideally around reporting and/or data migration.
• 
  Experience with defect management processes, defect
  identification, logging, tracking, and resolution.
• 
  Familiarity with industry-standard quality assurance
  practices, such as ISO standards, CMMI, or Agile methodologies

Data Analysis:

• 
  Demonstrated experience working as a business analyst in
  large/complex data migration projects.
• 
  Basic knowledge of SQL language; ability to execute SQL
  queries.
• 
  Understanding of concepts around ETL, data quality, data
  cleaning, data issues’ handling.
• 
  Familiarity with BI/reporting tools such as PowerBI

DevOps and Agile:

• 
  Demonstrated experience with writing user stories and using
  tools such as DevOps.