OPGT MOD 2 - 1x Bus. An. (Snr) - 206+175 Days - [Reporting]

Project Overview

The OPGT Modernization initiative supports the ongoing delivery of services to Ontarians who cannot care for themselves and have no one able to act on their behalf. Phase 1 implemented a cloud-based, fully integrated Microsoft Dynamics 365 solution replacing end-of-life case, financial, and document management systems. Phase 2 will enhance the MVP with additional workflows, automation, and new features, including reporting and data platform improvements.

Key Responsibilities

• Lead and conduct business and system analysis to build the golden layer of the data lakehouse and modernized reports in PowerBI
• Lead the effort to define the reporting MVP, document legacy reports in scope, conduct gap analysis, and provide recommendations
• Document report requirements as user stories in DevOps
• Conduct analysis at varying levels of detail aligned with OPS standards
• Liaise between business areas and the data migration/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 definition (including report requirements, screen specifications, and data migration requirements)
• Produce and update documentation to support future support of implemented solutions
• Assist with identifying and resolving data quality issues, defining test cases, performing data reconciliation, and addressing testing discrepancies
• Develop KPIs to report on progress, completeness, and quality of reporting and data migration
• Provide post-migration support by analyzing and addressing data-related issues and optimizing data management processes in the new environment
• Complete work and achieve milestones within assigned deadlines
• Notify the project manager in writing of issues or material concerns related to deliverables
• Submit deliverables for approval as they are completed
• Other duties as assigned

Qualifications & Requirements

REQUIRED

• Must be able to work onsite
• 10+ years of experience leading and conducting business and system analysis to assess business problems/opportunities and document business/system requirements
• Experience with agile and waterfall methodologies
• Experience writing user stories and using DevOps
• Experience conducting business and system analysis for data marts, data warehouses, data lakehouse, or BI/data analytics and reporting solutions
• Experience conducting business and system analysis for a Dynamics 365 CE and/or F&O solution

NICE TO HAVE

• Experience conducting analyses at varying levels of detail aligned with OPS standards
• Experience with 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 definition (including screen specifications and data migration requirements)
• Experience as a business analyst on large/complex data migration projects
• Familiarity with PowerBI
• Basic SQL knowledge and ability to execute SQL queries
• Understanding of ETL, data quality, data cleaning, and data issue handling
• Experience creating use cases, test plans, test cases, and test scripts (ideally around reporting and/or data migration)
• Experience with defect management processes (identification, logging, tracking, resolution)
• Familiarity with quality assurance practices such as ISO standards, CMMI, or Agile methodologies

EVALUATION CRITERIA

Business Analysis Experience - 40 points

• 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.
• Demonstrated experience with writing user stories and using tools such as DevOps.

Dynamics 365 Experience - 30 points

• 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
• Demonstrated experience working as a business analyst in large/complex data migration projects.
• Familiarity with BI/reporting tools such as PowerBI
• Proven experience in conducting business and system analysis for a Dynamics 365 CE and/or F&O solution.

Quality Assurance - 20 points

• Experience creating use cases, test plans, test cases, test scripts ideally around reporting and/or data fixes.
• 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 Knowledge - 10 points

• Basic knowledge of SQL language; ability to execute SQL queries.
• Understanding of concepts around ETL, data quality, data cleaning, data issues’ handling.

Key Skills & Competencies

Microsoft Dynamics 365, Dynamics 365 CE, Dynamics 365 F&O, Power BI, PowerBI, Azure DevOps, DevOps, SQL, ETL, Data warehouse, Data lakehouse, Data mart, Data migration, Business intelligence, Data analytics, KPI, Use case modeling, Data modeling, Process modeling, Data flow modeling, Defect management, ISO standards, CMMI