Skip to content

Open nowFirst seen 45 hours ago

RQ00223 - Systems Analyst - Senior

SourceCode858 open roles

Get the CV for this job

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

Your applicationOpen nowRQ00223 - Systems Analyst - SeniorSourceCode
  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 SourceCode'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 45 hours ago

The posting

RQ00223 - Systems Analyst - Senior  Duration: 6 Months (130 Business Days)

Location: hybrid, 3 days in office (with the possibility for 5 days on-site) at 277 Front Street West, 4th floor

Must Haves:

  • Demonstrated knowledge and experience with the Systems Development Life Cycle (SDLC), including requirements gathering, solution design, development, testing, implementation, and post-deployment support.
  • Ability to quickly understand existing applications, data structures, reporting ecosystems and business processes.
  • Advanced Power BI development including DAX, Power Query/M, data modelling, semantic models and Power BI Service.
  • Strong SQL and data modelling knowledge, including relational databases, dimensional modelling, facts, dimensions and star-schema concepts, with the ability to understand and work with SQL-based data sources when required.
  • Experience integrating and modelling data from multiple systems and data sources, including enterprise and third-party applications.
  • Demonstrated experience gathering requirements and translating business needs into technical and reporting solutions.
  • Experience supporting and troubleshooting existing Power BI solutions in production.
  • Strong analytical and problem-solving skills, with the ability to identify data, process and performance gaps and recommend improvements.
  • Experience with Power BI RLS, workspace management, and security.
  • Experience with Power Apps, Power Automate.
  • Advanced Excel skills, including Power Query, Power Pivot and VBA/macros where applicable.
  • Strong communication and stakeholder management skills, with the ability to work effectively across business and technical teams.
  • Knowledge and experience in rapid application development (RAD) methodologies

Public Sector Experience: Preferred

Nice to Haves:

  • Experience integrating data from APIs, cloud-based data services, enterprise applications and third-party systems.
  • Experience with project and portfolio management platforms such as Asana, Microsoft Project, or similar enterprise PM systems is preferred.
  • Experience with PMO, project portfolio, financial or operational performance reporting, with an understanding of project status, risks, financials, milestones and resource reporting.
  • Experience working in environments where multiple BI, data or development teams collaborate on shared reporting models, datasets, workspaces or enterprise data sources.
  • Python or other scripting experience for data analysis, automation or data processing

Job Summary

We are looking for a Performance Analyst to join our team. The successful candidate will be a self-starter that has strong Power BI development, Excel, data modelling and analytical skills, with the ability to build intuitive, dynamic and engaging dashboards that enable leadership and business users to self-serve and understand their data. The role will also involve optimizing the performance of existing reports and data solutions, developing new reporting capabilities, and ensuring that data is accurate, reliable and presented in a meaningful way.

The candidate should be comfortable working with data from multiple enterprise and third-party systems and collaborating with Finance, I&IT as well as data and application teams to bring together the information required for effective performance reporting.

The ideal candidate is a business-minded data specialist and problem solver who can bridge the gap between business requirements and technical implementation. They can take an ambiguous reporting or performance challenge, understand the underlying process and data, and turn it into a practical, scalable and decision-ready solution.

This role is an in‑office position based at our 277 Front Street West, Toronto location. Our team is highly collaborative, and much of our work benefits from in‑person co‑creation, relationship‑building, and hands‑on partnership with leaders across the organization.

Responsibilities

Business Analysis & Performance Reporting

  • Create and maintain end-user documentation, technical documentation, and developer guides for both existing and newly developed solutions.
  • Establishing reporting standards, KPI definitions, and data governance practices.
  • Gather and translate business requirements into reporting and technical specifications.
  • Understand business processes and identify opportunities for process improvement, automation and reporting optimization.
  • Design and maintain intuitive Power BI dashboards, KPIs and trend analysis for leadership and business users.
  • Develop both ad-hoc analysis and structured recurring reports to support decision-making.
  • Partner with PMO, Finance, I&IT and other stakeholders to understand and integrate their data requirements.

Power BI & Data Development

  • Design, develop and maintain Power BI reports using DAX, Power Query/M, data modelling, and semantic models.
  • Build efficient reporting models using dimensional modelling / star-schema principles.
  • Optimize existing reports, datasets and models for performance, usability and scalability.
  • Implement appropriate RLS, workspace security and access controls.
  • Troubleshoot data refresh, model, DAX and reporting issues.

Data Integration & Solution Development

  • Work with data from multiple enterprise and third-party applications (such as ServiceNow, EcoSys, Jira,etc).
  • Analyze source systems and design appropriate data structures and integration approaches for reporting.
  • Collaborate with data engineers, application developers and other BI teams to source and exchange data.
  • Work with technologies such as SQL, Azure Data Lake, Dataverse and APIs as required.
  • Identifying data quality issues and implementing appropriate controls.

Existing Solution Support & Continuous Improvement

  • Quickly understand and support existing applications, reports, data models and business processes.
  • Investigate production issues, identify root causes and implement sustainable solutions.
  • Evaluate existing solutions and identify opportunities to automate manual processes, improve data quality, and enhance performance.
  • Provide ongoing maintenance and enhancement of reporting solutions.

Data Migration & Platform Transition

  • Analyze source and target data structures and develop data mapping, migration strategies and templates.
  • Support migration of reporting data and processes when applications or platforms change.
  • Validate migrated data and ensure business reporting requirements are maintained during transition.

Testing, Deployment & Documentation

  • Develop and execute UAT, regression and production validation scenarios.
  • Support reporting releases and post-production validation.
  • Maintain business, technical and data documentation.
  • Collaborate with developers and business users throughout the solution lifecycle.

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)

  • $77.05/hr - $92.46/hr Inc.

T4 RATE RANGE (7.25 billable hours per day)

  • $61.64/hr - $73.97/hr T4
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 SourceCode'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 SourceCode'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

    SourceCode'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.

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.