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.
Advantages
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.
Responsibilities
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 HealthLake, 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.
Qualifications
ETL & AWS Cloud Depth: Proven experience developing ETL and ELT processes using Python, AWS Glue, and AWS analytics services (Redshift, S3, Athena, CloudWatch) (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 HealthLake, 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).
Summary
If you're interested in the "Senior Business Intelligence Specialist" role based in Toronto, we encourage you to apply online at www.randstad.ca.
Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!
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, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to [email protected] to ensure their ability to fully participate in the interview process.
