Business Analyst 9453-1513
Business Analyst 9453-1513
Posted on :
11-07-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
HM Note: This hybrid contract role is three 3 days in office. Candidates resume must include first and last name.
Description
and nbsp;
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 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. 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 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 Vendors 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 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 Skillset 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 non-functional 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 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.
and nbsp;
Resumes Evaluation/Criteria:
Criteria 1: and nbsp;Business Analysis Experience - 25 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 non-functional 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 CE / F and amp;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 and amp;O data
- 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: and nbsp;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
and nbsp;
Criteria 4: and nbsp;Quality Assurance - 15 Points
- and nbsp;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
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
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 haves:
- 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.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
