Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowFirst seen 2 days ago

RQ09219 - Business Analyst

Rubicon Path638 open roles

Where
Toronto, ON, Canada
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowRQ09219 - Business AnalystRubicon Path · Toronto, ON, Canada

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Rubicon Path's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

11.8% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 2.1%1 day
  2. 4.4%3 days
  3. 11.8%7 days
  4. 18.6%14 days
  5. 35.6%30 days
  6. 45.1%60 days
This job: first seen 2 days ago

The posting

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 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 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 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&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.

SkillsExperience and Skill Set Requirements

A Note on the VOR Master Service Agreement:

The VOR Master Service Agreement which expires on April 5, 2026, leaves some Contracts with funding unassigned for fiscal 2026-27. If the current statement of work expires on March 31, 2026, the remaining funds can be used to exercise an option to extend the SOW beyond March 31, 2026, based on business case approvals. Such extensions will be allowable, only if the Master Service Agreement is extended beyond April 5, 2026, and be upon the same terms, conditions, and covenants contained in the SOW.

The start date is subject to change based on security clearances and contract signing timelines.

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&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 clients 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.

Resumes Evaluation/Criteria:

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

Criteria 2: 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&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&O solution or other CRM/ERP solutions

Criteria 3: Quality Assurance - 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 industry-standard quality assurance practices, such as ISO standards, CMMI, or Agile methodologies

Criteria 4: 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 problem-solving 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 multi-tasking abilities and a proven track record for meeting strict deadlines

Criteria 5: DevOps and Agile - 10 Points

  • 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 execution as a member of the data migration team using the approach and tools required by the project manager.

To whom

  • Project Manager / Team members

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

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Rubicon Path's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on Rubicon Path's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    Rubicon Path's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.