OPGT MOD - 1x Bus. An. (Snr) - 83 Days - [Reporting]

Project Overview

The Office of the Public Guardian and Trustee (OPGT) is responsible for protecting the property and personal interests of over 10,000 incapable adults who have no one else to help them, investigating allegations of abuse of mentally incapable adults, protecting the public's interest in charities, administering intestate estates, searching for heirs, investing perpetual care funds for Cemeteries, and dealing with dissolved corporations. The OPGT has embarked on a modernization and transformation initiative to help address rapidly increasing workload and caseload pressures, modernize business processes and business-critical tools in order to improve service delivery to vulnerable Ontarians.

Key Responsibilities

• 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.
• Provide post-migration support, analyze and address data-related issues or questions; help with optimizing data management processes in the new environment.

Qualifications & Requirements

REQUIRED

• Must be able to work 5 days onsite per week
• 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.

NICE TO HAVE

• 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.

EVALUATION CRITERIA

Business Analysis Experience - 25 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.

Dynamics 365 CE / F&O Experience - 25 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
• experience in conducting business and system analysis for a Dynamics 365 CE and/or F&O solution or other CRM/ERP solutions

Quality Assurance - 15 points

• 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 - 25 points

• 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 - 10 points

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

Key Skills & Competencies

Business Analysis, System Analysis, Agile Methodologies, Waterfall Methodologies, Data Warehousing, Data Lakehouse, Business Intelligence, Data Analytics, Reporting, PowerBI, User Stories, DevOps, Data Modeling, Use Case Modeling, Process Modeling, Data Flow Modeling, SQL, ETL, Data Quality, Data Cleaning, Dynamics 365 CE, Dynamics 365 F&O, CRM, ERP, Test Planning, Test Cases, Test Scripts, Defect Management, Quality Assurance, ISO Standards, CMMI, Data Migration