Senior Business Intelligence Specialist

We are seeking an accomplished Senior Business Intelligence Specialist to lead the design, development, and optimization of enterprise analytics platforms, dimensional data warehouses, and AI-assisted BI solutions. In this role, you will build automated ETL/ELT pipelines, architect dimensional schemas, and engineer interactive Power BI dashboards. Working across a modern AWS cloud stack and complex API integrations, you will ingest, transform, and model healthcare and enterprise data to deliver secure, grounded, and high-performance business intelligence solutions.

Location:

Toronto, ON (Hybrid – onsite as needed)

Duration: 8-month contract

Public Sector

Experience:

Must Have.

• Cutting-Edge Tech Stack:
  Hands-on development using Power BI, AWS Glue, Amazon Redshift, AWS Bedrock, Python, and FHIR APIs.
• Advanced AI & BI Integration:
  Drive innovation by building AI-assisted dashboards, natural language models, and vector-based analytics workflows.
• End-to-End Pipeline Ownership:
  Lead initiatives from initial REST/FHIR API ingestion to dimensional modeling and executive visualization.
• Hybrid Flexibility:
  Enjoy schedule flexibility with a hybrid work model based in Toronto.

• BI Dashboard & Analytics Engineering:
  Design, build, and maintain enterprise Power BI dashboards, reports, and semantic models, incorporating AI-assisted capabilities, natural language insights, and anomaly detection.
• Data Warehouse Architecture:
  Design and implement enterprise data warehouse solutions on Amazon Redshift, constructing dimensional star and snowflake schemas, fact tables, and dimension tables.
• ETL Pipeline Automation:
  Develop AWS Glue ETL/ELT pipelines using Python and SQL to ingest, transform, validate, and load high-volume datasets into data warehouse environments.
• API & Healthcare Data Integration:
  Architect automated data ingestion workflows connecting REST APIs, FHIR/HL7 v2 APIs, Smile CDR, AWS Health Lake, NetIQ IAM, Pexip, Zoom, and Master Data Management systems.
• Performance Optimization:
  Optimize Amazon Redshift query execution, indexing strategies, partitioning, and warehouse scalability for complex analytics queries.
• Data Quality & Governance:
  Develop data validation, cleansing, reconciliation, and governance processes to ensure maximum data accuracy and security compliance using IAM and OAuth2/OIDC protocols.
• AI & Grounding Validation:
  Evaluate AI accuracy, hallucination reduction, grounding, and response quality across integrated analytics workflows.
• Documentation & Operations:
  Author deployment pipelines, operational documentation, and knowledge transfer materials, providing ongoing production support and analytics enhancements.

• ETL & AWS Cloud Depth:
  Proven experience developing ETL and ELT processes using Python, AWS Glue, and AWS analytics services (Redshift, S3, Athena, Cloud Watch) (Strictly Required).
• Data Warehousing & SQL Mastery:
  Advanced SQL skills and hands‑on experience designing dimensional data warehouses using star/snowflake schemas on Amazon Redshift (Strictly Required).
• API & System Integrations:
  Demonstrated experience integrating data from REST APIs, databases, enterprise platforms, and specific endpoints such as Pexip, Zoom, and NetIQ IAM (Strictly Required).
• Healthcare Interoperability Standards:
  Experience integrating healthcare data using FHIR (R4/R4B), HL7 v2, Smile CDR, AWS Health Lake, and SMART on FHIR (Strictly Required).
• Identity & Security Controls:
  Hands‑on experience implementing role‑based security and secure access controls using IAM, OAuth2, and OIDC (Strictly Required).
• AI Evaluation & Analytics:
  Experience evaluating AI accuracy, hallucination reduction, grounding, and response quality, with familiarity using AWS Bedrock and Power BI AI capabilities (Strictly Required).
• Public Sector Expertise:
  Prior experience working within public sector IT and data environments (Strictly Required).

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies,…