The Role
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.
Summary Generated by Built In
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.
Skills Required
- 10+ years leading and conducting business and system analysis to document business/system requirements
- Proven experience with both agile and waterfall project methodologies
- Proven experience designing or analyzing data marts, data warehouses or data lakehouse solutions and BI/reporting
- Demonstrated experience on large/complex data migration projects
- Demonstrated experience writing user stories and using Azure DevOps (or DevOps)
- Familiarity with Power BI for report development
- Basic knowledge of SQL and ability to execute queries
- Understanding of ETL concepts, data quality, and data cleansing processes
- Experience conducting business modeling, use case modeling, conceptual/logical data modeling, and process/data flow modeling
- Experience creating test plans, test cases, test scripts and defect management around reporting/data migration
- Experience with Dynamics 365 CE and/or F&O data or other CRM/ERP systems for reporting solutions
- Strong written and verbal communication and stakeholder engagement skills
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Maarut Inc. is a Canadian company specializing in IT services, technology staffing, and software development, dedicated to assisting businesses with digital transformation and solving business challenges through technology.
