Lead business and system analysis to design and deliver modernized Power BI reports from a new data warehouse/lakehouse, define reporting MVP, document requirements and legacy reports, support data migration and reconciliation, produce documentation and test artifacts, and provide post-migration support and optimization.
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.
Similar Jobs
Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
Co-op role supporting RAN troubleshooting automation: develop automation scripts, participate in AI/ML and LLM-driven use cases, reproduce faults, configure Ericsson environments, research solutions, document results, and collaborate with engineers while learning RAN software and 3GPP standards.
Top Skills:
3GppAi Agentic FrameworksBashCloud InfrastructureIp NetworkingKerasLinuxLlm ApisMatplotlibNumpyPandasPlotlyPythonPyTorchRadio Access Network (Ran)RagScikit-LearnScipySeabornTensorFlow
Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
Develop and evaluate RAN baseband system features and network-level simulations for 5G/6G. Specify algorithms, test cases, and parameters for radio resource management and physical layer functions, drive product and simulation improvements, support standards work, system verification, deployments, troubleshooting, and contribute to innovation and patents.
Top Skills:
3Gpp5G Nr6GCC++CloudJavaMatlabMimoPhysical LayerRadio Resource ManagementRan
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Partner with operations, supply chain, and finance to analyze manufacturing metrics, build and maintain dashboards (Power BI), translate business requirements into reporting solutions, support ERP/UAT and post-implementation change management, and deliver data-driven recommendations to improve production performance.
Top Skills:
AlteryxErpExcelMesMicrosoft DynamicsMicrosoft WordOraclePower BIPowerPointPythonRSAPTableauWms
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
