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

Open nowFirst seen 2 days ago

RQ00734 - Business Intelligence Specialist - Senior

SourceCode859 open roles

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

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

Your applicationOpen nowRQ00734 - Business Intelligence Specialist - SeniorSourceCode · 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 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 2 days ago

The posting

RQ00734 - Business Intelligence Specialist - Senior

7+ month contract (164 business days) - possible extension

Hybrid (onsite as needed) - 525 University Avenue

Must Haves:

  • Experience developing ETL and ELT processes using Python and AWS Glue.
  • Experience developing SQL for Amazon Redshift and relational databases.
  • Experience integrating data from REST APIs, databases, cloud platforms, and enterprise applications.
  • Experience with AWS analytics services including Redshift, Glue, S3, Athena, and CloudWatch.
  • Experience integrating healthcare data using FHIR, HL7 v2, Smile CDR, AWS HealthLake, and healthcare APIs.
  • Experience implementing secure data access using IAM, OAuth2/OIDC, and role-based security.
  • Strong SQL, data modelling, analytics, and performance optimization experience.
  • Experience evaluating AI accuracy, hallucination reduction, grounding, and response quality.
  • Experience with Pexip and Zoom APIs and data structures
  • Experience with NetIQ IAM APIs and data structures
  • Public Sector experience

Description:

The Agency is expanding the Provincial Health Services Directory (PHSD) to incorporate artificial intelligence capabilities that improve provider discovery, referral quality, and healthcare navigation across provincial digital health applications. The solution will utilize PHSD provider, practitioner, organization, healthcare service, specialty, location, and service metadata together with clinical referral context to provide intelligent recommendations while maintaining traceability to authoritative source data. AI agents will consume PHSD FHIR APIs, Smile CDR, AWS HealthLake, the Agency Master Data Management, and other provincial digital health assets to provide grounded responses rather than generative opinions. The project includes development of reusable AI services, MCP servers, semantic search capabilities, vector-based retrieval, prompt orchestration, evaluation frameworks, and secure integration with SMART on FHIR applications and provincial healthcare systems. The implementation will emphasize explainability, auditability, privacy, security, and clinical confidence while supporting future AI-enabled healthcare workflows across the Agency.

Responsibilities:

  • Design, develop, and maintain enterprise Power BI dashboards supporting operational, executive, clinical, and business reporting.
  • Develop AI-assisted dashboards utilizing Power BI Copilot, natural language queries, AI visualizations, forecasting, anomaly detection, and intelligent insights where appropriate.
  • Design and implement enterprise data warehouse solutions using Amazon Redshift.
  • Develop dimensional star schemas, fact tables, dimension tables, and semantic models supporting enterprise reporting.
  • Develop AWS Glue ETL pipelines using Python to ingest, transform, validate, and load data into Amazon Redshift.
  • Develop automated data ingestion processes from NetIQ IAM, Pexip, Zoom, Smile CDR, AWS HealthLake, Provider Registry, Master Data Management, PHSD operational databases, application logs, and other provincial digital health assets.
  • Develop data quality validation, cleansing, reconciliation, and governance processes supporting analytics accuracy.
  • Optimize Redshift performance, partitioning, indexing strategies, query execution, and warehouse scalability.
  • Develop operational KPIs, healthcare utilization metrics, provider activity reports, referral analytics, platform adoption reporting, and executive dashboards.
  • Collaborate with business stakeholders to gather reporting requirements and develop meaningful analytics solutions.
  • Develop deployment pipelines, documentation, operational procedures, and knowledge transfer materials.
  • Support production implementation, troubleshooting, report optimization, and ongoing analytics enhancements.

Desired Skills:

  • Business intelligence solution design, dashboard development, and enterprise reporting using Microsoft Power BI.
  • Enterprise data warehouse design including dimensional modelling, star schemas, fact tables, dimension tables, and semantic models.
  • ETL and ELT development using Python, AWS Glue, SQL, and Amazon Redshift.
  • Advanced SQL development, query optimization, and performance tuning.
  • Data integration from REST APIs, FHIR APIs, Smile CDR, AWS HealthLake, NetIQ IAM, Pexip, Zoom, Provider Registry, Master Data Management, and enterprise databases.
  • Healthcare analytics using FHIR R4/R4B, HL7 v2, SMART on FHIR, and healthcare interoperability standards.
  • AI-assisted analytics including Power BI AI capabilities, natural language insights, forecasting, anomaly detection, and intelligent reporting.
  • AWS analytics services including Amazon Redshift, AWS Glue, S3, Athena, IAM, CloudWatch, and related cloud services.
  • Python Glue shell experience
  • Experience with Pexip and Zoom APIs, extracting data for analytics
  • Data quality management, governance, reconciliation, validation, and operational reporting.
  • Strong analytical, communication, documentation, stakeholder engagement, and knowledge transfer skills.

Required Skills:

  • Business intelligence solution design, dashboard development, and enterprise reporting using Microsoft Power BI.
  • Enterprise data warehouse design including dimensional modelling, star schemas, fact tables, dimension tables, and semantic models.
  • ETL and ELT development using Python, AWS Glue, SQL, and Amazon Redshift.
  • Advanced SQL development, query optimization, and performance tuning.
  • Data integration from REST APIs, FHIR APIs, Smile CDR, AWS HealthLake, NetIQ IAM, Pexip, Zoom, Provider Registry, Master Data Management, and enterprise databases.
  • Healthcare analytics using FHIR R4/R4B, HL7 v2, SMART on FHIR, and healthcare interoperability standards.
  • AI-assisted analytics including Power BI AI capabilities, natural language insights, forecasting, anomaly detection, and intelligent reporting.
  • AWS analytics services including Amazon Redshift, AWS Glue, S3, Athena, IAM, CloudWatch, and related cloud services.
  • Data quality management, governance, reconciliation, validation, and operational reporting.
  • Strong analytical, communication, documentation, stakeholder engagement, and knowledge transfer skills.

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)

  • $89.31/hr - $107.17/hr Inc.

T4 RATE RANGE (7.25 billable hours per day)

  • $71.45/hr - $85.74/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.

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.