HM Note: This hybrid contract role is three 3 days in office. Candidates resume must include first and last name.
Description
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.
and nbsp;
Assignment Deliverables
As a member of the data migration and reporting team you will be responsible to build and deliver modernized reports from the new data warehouse/lakehouse and assist with the data migration from the existing legacy applications to the new Dynamics 365 solution. A highlevel 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 nonfunctional requirements definitions for assigned projects including report requirements screen specifications business rules data migration requirements etc. and nbsp; and nbsp;
- 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 postmigration support analyze and address datarelated issues or questions; help with optimizing data management processes in the new environment.
- Other duties as assigned.
The Consultant 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 and amp;IT Directive Operational Policy on the I and amp;IT Project Gateway Process and other applicable Guidelines Standards and Procedures.
Skills
Experience and Skill Set Requirements
Mandatory Requirements
- 10 years of experience leading and conducting business and system analysis to assess clients business problems/opportunities and document the business/system requirements in such a way that I and amp;IT solutions can be designed. and nbsp;
- 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 clients business problems/opportunities and document the business/system requirements in such a way that I and amp;IT solutions can be designed. and nbsp;
- 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 nonfunctional requirements definitions for assigned projects including screen specifications business rules data migration requirements etc. and nbsp; and nbsp;
- 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 and amp;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 industrystandard 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 problemsolving 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.
and nbsp;
Resumes Evaluation/Criteria:
and nbsp;
Criteria 1: Business Analysis Experience 40 Points
- 10 years of experience leading and conducting business and system analysis to assess clients business problems/opportunities and document the business/system requirements in such a way that I and amp;IT solutions can be designed. and nbsp;
- 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 nonfunctional requirements definitions for assigned projects including screen specifications business rules data migration requirements etc. and nbsp; and nbsp;
- Proven experience in both agile and waterfall project management methodologies with emphasis on agile.
Criteria 2: and nbsp;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 and amp;O data
- 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 and amp;O solution or other CRM/ERP solutions
Criteria 3: Quality Assurance and nbsp; 10 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 industrystandard quality assurance practices such as ISO standards CMMI or Agile methodologies
and nbsp;
Criteria 4: and nbsp;Consulting and Communication Skills 10 Points
- Experience consulting and coordinating between Business Areas and the IT Development and Testing teams to clarify business requirements and translate them into system requirements.
- Critical thinking analytical and problemsolving skills; proven gap analysis experience
- Excellent verbal and written communication skills
- Proven ability to engage with stakeholders and build strong working relationships.
- Excellent customer service skills including tact and diplomacy to ensure client needs are managed effectively.
- A motivated flexible creative team player with perseverance excellent multitasking abilities and a proven track record for meeting strict deadlines
and nbsp;
Criteria 5: and nbsp;DevOps and Agile 10 Points
- and nbsp;Demonstrated experience with writing user stories and using tools such as DevOps.
Knowledge Transfer
and nbsp;
What needs to be KT
- Document the tasks executed and in process of as a member of the data migration team using the approach and tools required by the project manager.
and nbsp;
To whom
- Project Manager / Team members
and nbsp;
When
- 1:1 meetings / team meetings / documentation in DevOps Wiki and boards throughout the duration of the project life cycle.
Must Have:
10 years of experience leading and conducting business and system analysis to assess clients business problems/opportunities and document the business/system requirements in such a way that I and amp;IT solutions can be designed. and nbsp;
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.