Apply now

First seen by our source: last month

RQ10947 - Sr. Business Analyst (Dynamics 3654 CE & F&O)

@ Source Code

Toronto, Ontario

$67.35–$101.04/hr10+ years experience
Apply now
SIGNALS

Overview

Source Code is hiring a Senior Business Analyst on a 10+ month contract, with two possible extensions, for the Office of the Public Guardian and Trustee (OPGT) in Ontario. The role is fully onsite five days a week at 21 College Street and supports report development for the data warehouse and lakehouse and related data migration. Pay is $84.19 to $101.04 per hour incorporated, or $67.35 to $80.83 per hour as T4.

Pay:

$67.35–$101.04 an hour

Responsibilities:

  • Lead business and system analysis for the data lakehouse golden layer and Power BI reports
  • Define the reporting MVP and conduct gap analysis on legacy reports
  • Document report requirements as user stories in DevOps
  • Liaise between business areas and the data migration and reporting team

Requirements summary:

  • 10+ years leading business and system analysis
  • Proven agile and waterfall project management experience
  • Experience with data warehouse, BI or reporting solutions
  • Experience with Dynamics 365 CE and/or F&O solutions
  • Familiarity with Power BI

Tools & skills

Source and dates

Source type not verified · manatal

Employer posting date
Not provided
First seen by our source
2026-10-12
Source record updated
2026-10-15

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SenioritySenior
DepartmentData & analytics
Experience10+ years
Hours per week36.25
Scheduleday
Travelair: none · ground: none
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish
Background checkscredit
Security clearanceOther clearance

Summary and details written by AI from the posting; the employer’s posting is the authority.

Source Code

FieldValue
Open jobs on Jobsy505
Job description

RQ10947 - Sr. Business Analyst

10+ month contract (206 business days) - 2 possible extensions

ONSITE 5 days - 21 College Street

Security Level: CRJMC + Credit Check

Must-haves:

  1. 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.
  2. Proven experience in both agile and waterfall project management methodologies; demonstrated experience with writing user stories and using tools such as DevOps.
  3. 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.
  4. Proven experience in conducting business and system analysis for a Dynamics 365 CE and/or F&O solution.
  5. Familiarity with BI/reporting tools such as PowerBI

Nice-to-have:

  1. Basic knowledge of SQL language; ability to execute SQL queries.
  2. Understanding of concepts around ETL, data quality, data cleaning, data issues' handling.

Scope:

  • The Office of the Public Guardian and Trustee (OPGT) requires a Senior Business Analysts to assist with report development for the data warehouse/lakehouse and associated data migration activities.

Assignment Deliverables

As a member of the PGTIMS Support and Data Migration team, you will be responsible to lead and conduct business and systems analyst related to data migration activities.

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.

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

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

AI Disclaimer: Source Code may use artificial intelligence (AI) tools to assist in certain aspects of its recruiting and business operations.

Note: The higher end of the range is intended for absolutely exceptional candidates who meet all must-have requirements and most or all nice-to-have qualifications. The client will evaluate candidates based on both rate expectations and overall skill set when shortlisting.

INCORPORATED RATE RANGE (7.25 billable hours per day)

  • $84.19/hr - $101.04/hr Inc.

T4 RATE RANGE (7.25 billable hours per day)

  • $67.35/hr - $80.83/hr T4

Similar jobs

  • Senior Corporate Counsel - Public Sector

    Toronto, ON
    Full Time

    Snowflake: **Snowflake is proud to be the Official Data Collaboration Provider for LA28 and Team USA.**

    The ideal candidate brings sold expertise in SLED contracting and compliance, have a background negotiating SaaS transactions and the ability to operate effectively in a fast-paced,…; +7 years of experience, ideally…

  • Executive Assistant, Office of the CEO

    Toronto, ON

    ClearGov

    5+ YOECandidates need 5+ years supporting a C-suite executive, ideally at a high-growth company, with proven experience managing complex calendars and travel. Strong written and verbal communication, discretion with confidential information, and skill in Google Workspace and Expensify are required, plus living in Toronto.

    Google Calendar, Gmail, Google Drive, Google Docs, Google Sheets, Expensify

  • Talent Pool > Light Duty Cleaners - Greater Toronto Area

    Toronto, ON

    Alpine Building Maintenance: Alpine Building Maintenance is a proudly Canadian, minority-owned, and operated provider of premium facility cleaning and maintenance services.

    Candidates need to be eligible for security clearance and able to stand, walk and bend for long shifts. Prior hospitality, retail, customer service or janitorial experience, WHMIS knowledge, reliable transportation and shift flexibility are assets.

    Talent Pool > Heavy Duty Cleaners - Greater Toronto Area, ON

    Toronto, ON

    Alpine Building Maintenance: Alpine Building Maintenance is a proudly Canadian, minority-owned, and operated provider of premium facility cleaning and maintenance services.

    Candidates need experience operating heavy-duty cleaning equipment such as auto scrubbers, sweepers or pressure washers, plus professional janitorial experience in high-traffic public spaces. They must be able to lift up to 50 lbs consistently and be eligible to obtain security clearance. WHMIS knowledge is an asset.

    auto scrubber, sweeping machine, pressure washer, leaf blower

  • Senior Account Manager, Digital Investment

    Toronto, ON

    Monks

    3+ YOECandidates need 3+ years of programmatic or digital media management, hands-on experience with DV360, The Trade Desk or Amazon DSP, and familiarity with DCM and ad serving. They also need strong analytical skills and experience presenting to clients.

    DV360, The Trade Desk, Amazon DSP, DCM, Floodlight

  • Contract, Corporate Events Specialist

    Toronto, ON
    $80k–$101k/yr

    Toronto Hydro: Toronto Hydro owns and operates an electricity distribution system that delivers electricity to approximately 793,000 customers in the city of…

    5+ YOEToronto Hydro needs 5 to 8 years of progressive experience in corporate events, employee communications or engagement, plus large multimedia event delivery and vendor and budget management. A post-secondary education in communications, PR, marketing, event management or business is preferred, and strong project management skills are essential.

    Leadership, Motivate employees, Logistics, Public relations, Event planning, Project management

    Manager, Internal Communications & Events

    Toronto, ON
    $116k–$146k/yr

    Toronto Hydro: Toronto Hydro owns and operates an electricity distribution system that delivers electricity to approximately 793,000 customers in the city of…

    7+ YOE3+ MgmtCandidates need a bachelor's degree in communications or a related field, 7 to 10 years of corporate communications or related experience, and 3 to 5 years of progressive leadership. They also need extensive large-scale event production experience and strong writing and multi-media content skills.

    Digital communication platforms, Communications analytics tools

    Corporate Events Specialist

    Toronto, ON
    $80k–$101k/yr

    Toronto Hydro: Toronto Hydro owns and operates an electricity distribution system that delivers electricity to approximately 793,000 customers in the city of…

    5+ YOEToronto Hydro needs five to eight years of experience in corporate event management, employee communications or engagement, including large events with multimedia. Candidates should be strong in project management, vendor and budget management, and working with stakeholders, and post-secondary education in a related field is preferred.

    Leadership, Motivate employees, Logistics, Public relations, Event planning, Project management

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.