RQ00734 Business Intelligence Specialist Senior
$89.31 - $107.17 per hourFull-time
Source 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
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 12 hours ago
Similar jobs that could be interesting for youBased on the RQ00734 Business Intelligence Specialist Senior in Toronto, ON vacancy
- 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...SeniorContract work
$89.31 - $107.17 per hour
...RQ10945 - Sr. Business Intelligence Specialist 10+ month contract - possible extenion of 1+ year ONSITE 5 days - 595 Bay Street Security... ...of the Public Guardian and Trustee (OPGT) requires a Senior Business Intelligence Specialist to help enhance the audit...SeniorContract workWork 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... ...the end of 2026! Position Summary The Business Intelligence analyst is accountable for the management, development and execution...SuggestedLong term contractPermanent employmentWork at officeRemote work
$80k - $130k per year
...to guide strategic decisions and improve business operations. Reporting directly into our Chief... ...scalable, high-quality business intelligence solutions that power decision-making across... ...ecosystem. You will work closely with senior BI engineers, data engineers, and business...SeniorWork at office$95k per year
...strategic advice to some of Canada's leading businesses. This is an opportunity to become part... ...environment where research, market intelligence and critical thinking directly influence... ...and continuous learning, with exposure to senior stakeholders and meaningful projects across...SeniorPermanent employmentWork at office$80k - $138k per year
...opportunity. It builds consumer and business confidence, empowers... ...your typical day look like? As a Senior Consultant specializing in Artificial Intelligence (AI) for NowAssist within ServiceNow... ...certifications (Certified Implementation Specialist, NowAssist, or related) highly...SeniorPermanent employmentFlexible hours- ...This is a remote position. Job Title: Business Analyst – Intelligent Automation Position Summary We are seeking an experienced Business Analyst – Intelligent Automation to lead business analysis activities for automation and digital transformation initiatives. The...Contract workRemote work
- ...thinking organization, apply now. We are currently seeking a Business Partner Specialist Advisor to join our team in Toronto, Ontario (CA-ON), Canada... ...Basic Qualifications: 5+ years of experience working with senior management and executives to operationalize talent...SeniorWork at officeLocal areaRemote workFlexible hours
$75.3k - $104.9k per year
...management industry to be people first then business delivering on our promise of a superior... ...professional to join our team as Sr. Intelligent Automation this role you will improve finance... .... Final hiring decisions are made by people. Required Experience: Senior IC...SeniorFull timeWork at officeLocal area$55k - $60k per year
...Canada to create sustainable employment opportunities for people, businesses and communities. We understand that work gives hope,... ...Like WCG, you believe in the power of work, As a Business Support Specialist you'll play an integral role in supporting the team with a range...Full timeContract workWork at officeLocal areaRemote workFlexible hours$70k - $95k per year
...logistics provider that helps businesses move goods across borders... ...never looked back. He began his specialist career with the firm in 2002... ...wherein he held a number of senior positions. In 2007, Trevor’s... ...promptly. Use of Artificial Intelligence We do NOT use artificial...SeniorLong term contractPermanent employmentFull timeImmediate startRelocation packageStoakley-Stewart Consultants
Toronto, ONmore than 2 months ago$50 per hour
Our client, a large financial institution, is seeking a skilled Business Intelligence & Analytics Consultant to support their ongoing data migration and reporting enhancement initiatives. This role has two functions, first focusing on creating reports and optimizing data and...Contract workWork at office2 days per week3 days per week$75k - $110k per year
...collaborative environment where your work will help provide information and coordination to support leadership decision-making and business outcomes. Key Responsibilities ~ Support operational, governance, planning, and business management activities across the Canada...Long term contractTemporary workWork at office3 days per week- ...subcontractor risk management. Through standardized prequalification, intelligent data collection, and seamless ERP integrations, we help... ...the supply chain. The Opportunity We're hiring a Business Development Senior Associate with 3–5 years of B2B sales experience to own...SeniorFull timeFor contractorsFor subcontractorWork at officeWork from home
- We are seeking an experienced Senior Software Developer - Artificial Intelligence to lead the technical design, development, and integration of enterprise-grade AI applications. In this role, you will build Retrieval Augmented Generation (RAG) pipelines, develop intelligent...SeniorContract workFlexible hours
- ...EAML) Group is responsible for all aspects of CIBCs Anti-Money Laundering (AML) and Anti-Terrorist Financing (ATF) program. As a Business Intelligence Analyst youll be part of the Insights and Reporting team where youll work closely with end users and leaders to design and...SeniorFull timeTemporary workFixed term contract3 days per week1 day per week
- Esri Canada Limited About us: Esri Canada provides geographic information system (GIS) solutions that empower people in business, government and education to make informed and timely decisions by leveraging the power of mapping and spatial analytics. If you are passionate about...Full timeSummer workWork at officeWork from home
$75k - $85k per year
...shape the future together! The Opportunity The Senior Technical Support Specialist is a highly skilled, technically focused position that... ...creativity across platforms, and unlock a new era of creative intelligence, we’d love to hear from you. Pitch us your vision- and...SeniorLong term contractFull timeInternshipLocal areaWorldwide$78.4k - $109.8k per year
...We are looking for a Senior Total Rewards Specialist to lead the administration, implementation, and continuous... ...consultation and guidance to business leaders, People Partners, Talent Acquisition... ...Hiring Hootsuite uses artificial intelligence (AI) to support our recruitment...SeniorLong term contractPermanent employmentTemporary workLocal areaRemote workRelocation- ...belong on #TeamBell. On the Bell Business Markets team, you’ll be a vital part of... ...will lead the evolution of Business Intelligence into a modern, AI-enabled decision science... ...• Demonstrated ability to influence senior stakeholders and create decision alignment...SeniorFull timeWork at office3 days per week
- ...channels to help deepen client relationships and support business priorities. As a Senior Marketing Business Analyst youll lead the execution of digital... ...coding French proficiency). We use artificial intelligence tools during the recruitment process. Our goal for the application...SeniorFull time3 days per week1 day per week
$84.19 - $101.03 per hour
...RQ00753-Business Analyst - Senior Location: Toronto (200 Front St) Hybrid (up to 3 days onsite) 1 year contract (260 business days)... ...Confluence. AI Disclaimer: Source Code may use artificial intelligence (AI) tools to assist in certain aspects of its recruiting...SeniorFull timeContract workWork at office- ...other and the world. We achieve this by providing consumers and businesses with the best network technologies in the world, innovative... ...Accessibility page f or other ways to contact us. Artificial intelligence may be used to assess parts of your application. Please review...SeniorFull timeWork at officeShift work3 days per week
- ...Services team. Enabling our industry-leading businesses requires many teams working... ...by the Company with due consideration to seniority), to participate in a standby program and... ...other ways to contact us. Artificial intelligence may be used to assess parts of your application...SeniorRemplacementFull timeFor contractorsWork at officeFlexible hoursShift workNight shiftAfternoon shift3 days per week
$69k - $114k per year
...people can find meaning and opportunity. It builds consumer and business confidence, empowers organizations to find imaginative ways of deploying... ...by the Manager, People Analytics, including presentations to Senior Manager, Director, and Partner level audiences About the team...SeniorPermanent employmentWork at officeFlexible hours$88k - $121k per year
...mission. If you are too, let's talk. The Senior Regional Marketing Specialist We are looking for a strategic... ...strategic alignment and achieve business outcomes. What You’ll Be Doing... ...Local Law 144, that use artificial intelligence, machine learning, or other automated...SeniorLocal areaWorldwide- ...Responsibilities: Works on / develops Artificial Intelligence (AI) strategy for the organization including creating the conceptual logical... ...(AI) and Conversational AI solutions based on client business requirements enterprise architecture standards security policies...SeniorFull time
- ...an independent contractor opportunity Seeking motivated Business Development Specialist that are looking for more independence, flexibility and... ...events globally. We are seeking someone with experience at a senior level in business who is looking to make a change. This independent...SeniorRemote jobFull timePart timeFor contractors
$84.19 - $101.03 per hour
...RQ11298 - Business Analyst - Senior Duration: 9 months (170 business days) Location: Toronto or Kingston NOTE: Assignment... ...standards AI Disclaimer: Source Code may use artificial intelligence (AI) tools to assist in certain aspects of its recruiting...SeniorContract workWork at officeMonday to friday- ...formal release cycles (SIT/UAT) Seniority: Flexible but preferably mid-level or juniors with some... ...Provide services in the domain of system integration, business intelligence and data flows through the full lifecycle of the MX.3: requirements...SeniorRemote workFlexible hours
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
- business intelligence manager Toronto, ON
- junior business intelligence analyst Toronto, ON
- spécialiste bi Toronto, ON
- sap bi Toronto, ON
- business intelligence Toronto, ON
- senior solution architect Toronto, ON
- pega senior system architect Toronto, ON
- senior pattern maker Toronto, ON
- senior digital marketing manager Toronto, ON
- senior administrative officer Toronto, ON