Talent.com
Maarut
RQ00734 Business Intelligence Specialist SeniorMaarut • Toronto, Ontario, Canada
RQ00734 Business Intelligence Specialist Senior

RQ00734 Business Intelligence Specialist Senior

Maarut • Toronto, Ontario, Canada
9 days ago
Job type
  • Full-time
Job description

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 star and snowflake schemas.
  • 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
  • Experience with AWS Bedrock

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.

Evaluation Criteria:

  • Business intelligence dashboard development Power BI reporting semantic models executive reporting KPI development and AI-assisted analytics experience. 25 Points
  • Enterprise data engineering experience including Amazon Redshift AWS Glue Python SQL dimensional modelling ETL/ELT development and enterprise data warehouse design. 25 Points
  • Healthcare analytics and interoperability experience including Smile CDR AWS HealthLake FHIR R4/R4B HL7 v2 NetIQ IAM Pexip Zoom healthcare APIs and enterprise healthcare data integration. 25 Points
  • Experience working with digital health assets including PHSD Hospital Report Manager (HRM) Enterprise Master Data Management stakeholder engagement documentation and knowledge transfer. 25 Points


Requirements

Deliverables:

  • Enterprise Power BI dashboards supporting operational executive clinical and business reporting.
  • AI-assisted Power BI reports incorporating natural language insights forecasting anomaly detection KPI analysis and interactive analytics where appropriate.
  • Amazon Redshift enterprise data warehouse including dimensional models star schemas fact tables dimension tables views and semantic models.
  • AWS Glue ETL pipelines developed using Python for automated ingestion transformation validation and loading of enterprise data.
  • Automated data extraction processes from NetIQ IAM Pexip Zoom Smile CDR AWS HealthLake PHSD operational databases Provider Registry Master Data Management application logs and other approved data sources.
  • Enterprise data quality validation reconciliation governance and monitoring processes.
  • Operational dashboards supporting platform utilization provider activity referral analytics system performance user adoption and executive reporting.
  • Documentation for data models ETL processes report definitions data lineage metadata operational procedures and deployment processes.
  • Automated deployment pipelines testing procedures production implementation support and operational transition documentation.

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



Employment Type : Full Time
Experience: years
Vacancy: 1
Monthly Salary Salary: 101 - 101
Create a job alert for this search

RQ00734 Business Intelligence Specialist Senior • Toronto, Ontario, Canada

Similar jobs

Senior Security Analyst Threat Intelligence Role

Robinhoodtoronto, on, Canada
Full-time

Be at the forefront of cybersecurity as a Senior Security Analyst for Threat Intelligence at Robinhood in Toronto.Engage in advanced threat detection and prevention efforts.This role within the Thr... Show more

 • Promoted

Business Intelligence Analyst III

TD SecuritiesToronto, ON, CA
Full-time

Business Intelligence Analyst III.Work Location: Toronto, Ontario, Canada.The Compliance Data Enablement & Transformation (CDET) team supports the effective and sustainable implementation and execu... Show more

 • Promoted

Business Intelligence (BI) Specialist

Onico SolutionsRichmond Hill, York region, Canada
Permanent

The Business Intelligence (BI) Specialist’s role is to strategically design and implement BI solutions that meet the needs of internal business stakeholders.This includes gathering requirements, de... Show more

 • Promoted

RQ09624 - Sr. Business Intelligence Specialist

Source CodeToronto, ON, CA
Full-time

Business Intelligence Specialist.Business Intelligence Specialist.Business Intelligence Specialist.Hybrid - - Candidate MUST work 3 days onsite and 2 days remote.Starting October 20, resources are ... Show more

 • Promoted

Senior Business Intelligence Business Analyst

TMX GroupToronto, Ontario, Canada
Full-time

Lead requirements gathering, analysis, and documentation for new analytics dashboards and reporting features, specifically utilizing SaaS data from Finance, HR, Legal, Projects, and Procurement.Con... Show more

 • Promoted

Business Intelligence Developer

Kumaran SystemsToronto, ON, CA
Full-time

Seeking an experienced Power BI Developer to design, develop, and maintain enterprise-level business intelligence and analytics solutions.The ideal candidate will have strong expertise in Power BI,... Show more

 • Promoted

FP&A Senior Specialist

Midea CanadaMarkham, York Region, CA
Full-time

The FP&A Senior Specialist serves as a strategic finance leader within Midea Canada, responsible for shaping a world‑class performance management system through rigorous financial planning, insight... Show more

 • Promoted

FinTech Market Intelligence Associate

SagardToronto, ON, CA
Full-time

A leading alternative asset management firm is looking for an Associate, Portfolio and Market Intelligence in Toronto.This role involves analyzing data from portfolio companies, preparing market in... Show more

 • Promoted

Business Intelligence Architect - C$86,011.4 - C$126,456.5 A Year

Alberta Gaming Liquor & CannabisEast York, Canada
Full-time

Seeking a senior Business Intelligence Architect to define and guide enterprise-wide architecture for data, analytics, AI/ML, and BI, focusing on modern, scalable analytics platforms for regulatory... Show more

 • Promoted

Sr. SAP BO Consultant

TechDoQuestmarkham, on, Canada
Full-time

SAP BO Consultant with SAP BO Admin experience.Strong hands‑on experience with SAP BO 4.Worked on at least one SAP BO upgrade project or at least one SAP BO end‑to‑end implementation project.Migrat... Show more

 • Promoted

Carbon Market Intelligence Analyst

ClearBlue MarketsToronto, ON, CA
Full-time

ClearBlue Markets is a global leader in carbon markets, helping clients navigate carbon pricing and offset strategies to drive real climate impact.With offices in Toronto, Amsterdam, and Colombia, ... Show more

 • Promoted

Business Intelligence Lead

Odyssey GlobalToronto, ON, CA
Full-time

Be among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.Business Intelligence Lead – Symbio (Government of New Brunswick).Location: Remote (Monthly travel to ... Show more

 • Promoted

Senior Product Manager - Platform Innovation & Intelligence

Martyn Bassett AssociatesToronto, ON, CA
Full-time

Our Client is a household name in the world of data communication solutions.Their product has won numerous awards in the category, including multiple Product of the Year accolades.Our client is tra... Show more

 • Promoted

Amphenol Senior IT Audit Specialist

Amphenol ICCMarkham, York Region, CA
Full-time

Drive compliance and security as a Senior IT Auditor at Amphenol Corporation in Markham, ON.This is your chance to impact global IT audit processes in a supportive environment.In this key role, you... Show more

 • Promoted

RQ06224 - Business Intelligence Specialist - Senior

Teacup Tech Systems IncToronto, ON, CA
Full-time

RQ06224 - Business Intelligence Specialist - Senior.About the job RQ06224 - Business Intelligence Specialist - Senior.Experience in business intelligence software development and a number of years ... Show more

 • Promoted

RQ08739 - Business Intelligence Specialist - Senior

Rubicon PathToronto
Full-time

RQ08739 - Business Intelligence Specialist - Senior.Job Openings RQ08739 - Business Intelligence Specialist - Senior.About the job RQ08739 - Business Intelligence Specialist - Senior.Document the n... Show more

 • Promoted

Senior Business Intelligence Manager

Metergy SolutionsToronto, ON, CA
Full-time

Metergy seeks a Senior Business Intelligence Manager based in North York, effective Fall 2026.Elevate data-driven decision-making while managing the BI team's operations and insights.You will play ... Show more

 • Promoted

Senior Business Intelligence Consultant

Yoush ConsultingToronto
Full-time

Azure DevOps Engineer with D365 and F&O experience.As a Data Engineer, you will be responsible for building and maintaining the systems and processes that allow for the extraction, transformation, ... Show more

 • Promoted

Mortgage Agent (Inside Sales)

Burke Financialrichmond hill, york region, Canada
Full-time

Chief People Officer & Mortgage Agent Level 2 | Fostering Growth & Excellence in Mortgage Servicing at Burke Financial.Job Title: Inside Sales - Licensed Mortgage Agent Level 2.Compensation Type: C... Show more

 • Promoted

Business Intelligence Developer

Insight GlobalToronto
Full-time

Get AI-powered advice on this job and more exclusive features.This range is provided by Insight Global.Your actual pay will be based on your skills and experience — talk with your recruiter to lear... Show more