RQ00734 - Business Intelligence Specialist - Senior
$89.31 - $107.17 per hourSource Code
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
Vacancy posted more than 2 months ago
Similar jobs that could be interesting for youBased on the RQ00734 - Business Intelligence Specialist - Senior in Toronto, ON vacancy
- ...Must Haves: Senior experience designing and developing enterprise Business Intelligence and analytics solutions. Extensive experience developing Power BI dashboards, reports, semantic models, and datasets. Experience developing dimensional data warehouses using...SeniorFull time
- ...Required Experience: Senior-level Oracle experience, including complex SQL, PL/SQL, data extraction, performance tuning, data profiling... ...and analytics. Responsibilities: ~ Work with OCRE business and technical stakeholders to define reporting requirements, business...SeniorContract workInternship
- ...We do have a job opening for Business Intelligence Specialist - Senior for our direct client State of Ontario. The position details are given below: Job Details: Job ID: RQ10945 - Business Intelligence Specialist - Senior Client : Justice Technology Services...SeniorFull timeWork at office
- ...excitement of a startup, together with a rock-solid, recession-proof business that has a 45 year track record. We’re a technology company... ...toward the end of 2026! Position Summary The Business Intelligence analyst is accountable for the management, development and execution...SeniorLong term contractPermanent employmentWork at officeRemote work
$104k - $130k per year
...Role Description Senior Business Intelligence (BI) Developer Lead II - Data Engineering Who We Are Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they...SeniorFull timeTemporary workPart timeWork at office$65k - $72k per year
...clients and sustainable growth for our business. Effectively Presents Solutions :... ...What will you be doing? The Business Intelligence Analyst plays a critical role in transforming... ..., certifications, experience, skills, seniority, geographic location, performance, shift...Remote jobFull timeLocal areaFlexible hoursShift work$80k - $95k per year
...Job Title: Analyst, Business Intelligence Department: Sales Operations & Analytics Master Department: Sales Report to: National Director, Sales Operations Effective Date: September 21, 2026 FLSA Exempt...Full timeInternshipWork at office- ...Reconciliation and financial reporting are essential to running a payments business, and given our transaction volume, this role has direct, measurable impact on financial accuracy and trust. As a Senior Analyst on the team, you will independently own reconciliation and...SeniorWork at officeLocal areaRemote workWorldwideFlexible hours
$81.6k - $115.2k per year
...Toronto, Ontario, Canada Hours: 37.5 Line of Business: Analytics, Insights, & Artificial Intelligence Pay Details: $81,600 - $115,200 CAD TD is committed... ...manner. BREADTH & DEPTH Work independently as a senior Workday reporting developer / subject matter expert...SeniorLong term contractPermanent employmentFull timeImmediate startWork from home$112k - $168k per year
...back. If Braze sounds like a place where you can thrive, we can’t wait to meet you. WHAT YOU’LL DO Join our passionate Business Intelligence Engineering team focused on building and maintaining robust data pipelines and products that enable better decision-making across...SeniorFull timeWork at officeFlexible hours$34.57 - $51.85 per hour
...General Hospital Department: Cogito Reporting Reports to: Senior Manager, Cogito Reporting Salary Range: $34.57 to $51.85... ...Closing Date: October 28, 2026 Position Summary The Business Intelligence (BI) Analyst reports to the Senior Manager, Cogito Reporting....SeniorHourly payRemplacementPermanent employmentFull timeInternshipFlexible hours- ...and corporate teams leverage data, analytics, and artificial intelligence. The Business Intelligence, Process & Innovation team is on an exciting... ...across a diverse investment portfolio. Your new role As a Senior Business Intelligence Engineer, you will serve as the Power...SeniorContract work
$100k - $115k per year
...Description Position at Resolver The Business Intelligence Manager owns Resolver's internal business data: the data in Snowflake,... ...scores. Clear development of career plans for team members. Both senior and junior stakeholders show sophisticated understanding of...SeniorLong term contractFull timeWork at officeRemote work$71.4k - $105.66k per year
...development opportunities. Our industry and business are continually evolving and fast-paced,... ..., is looking for a talented Business Intelligence Developer to join a team responsible for... ...clearly to non-technical stakeholders and senior leadership. • Comfortable working cross...SeniorFull timeCasual work$102k - $127.5k per year
...Workato Genie, AI Skills, MCP servers) to connect Legal and other business systems. Responsibilities: Design and build Recipes and... ...factors during the hiring process. Lyft may use artificial intelligence to screen applicants, however, Lyft employees make the ultimate...Hourly payContract workWork at officeFlexible hours3 days per week$60k - $75k per year
...excitement of a startup, together with a rock-solid, recession-proof business that has a 45 year track record. We’re a technology company... ...the end of 2026! Position Summary The Business Intelligence analyst is accountable for the management, development and execution...Long term contractFull timeWork at officeRemote work- ...curiosity, accountability, and new ideas. To learn more, visit us at . #LI-Hybrid Job Description The Senior Associate, Business Intelligence & Reporting Developer is responsible for designing, developing, and maintaining enterprise reporting, dashboards, and...SeniorFull timeInternshipWork at office
- ...internal mobility, and clear pathways for career growth. Position Summary We are seeking an experienced and analytical Business Intelligence (BI) Consultant with healthcare industry expertise to design, develop, and support data-driven solutions that improve operational...Full time
- ...healthcare…every day. We're searching for a Chicago-based Senior Product Manager, RLD Intelligence to join our Product Management team, so that we can... ...Intelligence Partnering with product, technical, and business leadership to maximize business value Establishing RLD...SeniorWorldwide
$85k - $95k per year
...Harcourt LLP is one of Canada’s leading business law firms. Advising many of Canada’s... ...or carve out a new path. The Specialist, Strategic Intelligence (Experience & Research) is the subject... ...growth initiatives. Reporting to the Senior Manager, Strategic Intelligence, the...SeniorFull timeWork at officeRemote work2 days per week$119k - $145k per year
...Manager, Marketplace Performance Intelligence, you will give Marketplace... ...and priority, protect specialist capacity and make trade-offs... ...experience in commercial analytics, business performance, eCommerce, retail... ..., with experience advising senior executives and responding to...SeniorPermanent employmentFull timeTemporary workWork at officeFlexible hours- ...payments and transaction engine of Scotiabank. We support Small Business, Commercial and Corporate clients with effective treasury... ...high-performing culture. Purpose The Manager, Business Intelligence & Insights for Global Banking Transaction Banking is responsible...Permanent employmentFull timeContract workWork at officeFlexible hours
$108k - $148.5k per year
...and insights, we believe that we can level the playing field so businesses can grow and local communities can thrive. We’re looking... ...change and may be modified in the future. Faire uses Artificial Intelligence (AI) to screen and select applicants for this position....SeniorFull timeWork at officeLocal areaRemote workMonday to friday3 days per week$80 - $120 per hour
...Catalyst , Peter Thiel , Adam D'Angelo , Larry Summers , and Jack Dorsey . Position: Market research / competitive intelligence Evaluator Type: Contract Compensation: $80–$120/hour Location: Remote Role Responsibilities...Full timeContract workSummer workWork at officeRemote work$75k - $105k per year
...Who We Are: Aird & Berlis LLP is a prominent Canadian business law firm located in the heart of Toronto’s and Vancouver’s financial... ...Toronto office is currently recruiting for a Business Development Specialist for our Marketing, Communications and Business team. This role...Full timeCasual workWork at office$52.7k - $74.4k per year
..., Ontario, Canada Hours: 37.5 Line of Business: Personal & Commercial Banking Pay Details... ...Team Manager, BBS, the Business Banking Specialist will engage small business customers in... ...appropriate partners, that may include Senior BBS, Merchant, Account Mangers of Small Business...SeniorPermanent employmentFull timeRemote workWork from home$71k per year
...to visualize data from various data sources Collaborate with business stakeholders and cross functional teams to understand/gather... ...the reports and PowerBI dashboards for data analysis/Business Intelligence and support data-driven decisions Leverage Python and other...Full timeContract workImmediate start- ...,000 square foot facility, with offices across Canada. Job Description ~ In-depth understanding with Data Warehousing/ Business Intelligence concepts from QA perspective Create and maintain complex SQL queries such as type 2 triggers, all types of joins, aggregations...Full time
$83k - $100k per year
...’re looking to fill an opening for a Business Analytics Specialist to join our IT Business Analytics Team... ...data. Compiling monthly reports for senior management Requirements Your... ...those with experience as a business intelligence developer CSC is considered an asset...SeniorFull timeInternship$80k - $100k per year
...expertise to the newest products and platforms, embrace new business models, employ breakthrough tools, and provide powerful... ...a member of the Sony family of global companies. The Senior Manager, Audience Intelligence leads Sony Music Canada’s audience insights function, delivering...SeniorLong term contractTemporary workWork at office
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to RQ00734 - Business Intelligence Specialist - Senior. Be the first to apply!
Related searches
- junior business intelligence analyst Toronto, ON
- business intelligence manager Toronto, ON
- spécialiste bi Toronto, ON
- business intelligence Toronto, ON
- sap bi Toronto, ON
- senior contracts manager contracts specialist Toronto, ON
- senior administrative officer Toronto, ON
- senior project accountant Toronto, ON
- senior accounting technician Toronto, ON
- senior account executive Toronto, ON