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 contemporary 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

📌 Senior Business Intelligence Specialist - Toronto
🏢 randstad canada
📍 Toronto