RQ00734 - Business Intelligence Specialist - Senior
Temporary
Maarut
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
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the RQ00734 - Business Intelligence Specialist - Senior in Toronto, ON vacancy
$89.31 - $107.17 per hour
...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...SeniorFull timeContract work- 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- ...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
$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$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$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$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$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- ...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
$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- ...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
$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$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...SeniorContract workWork at office- ...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
- ...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
- ...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
- ...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
- ...The Opportunity As a Senior Collections Specialist, you will manage client collections in a timely and effective manner while maintaining positive... ...environment. Bachelors degree or college diploma in accounting or business. Previous law firm and Aderant experience is an asset....SeniorPermanent employment
$145k - $195k per year
...that wants you to grow and succeed. Senior Service Delivery Specialist (SDS) plays a pivotal role within... ...comprehensive understanding of the customer's business, goals, and challenges to offer... ...services for database, analytics, intelligent technologies, and experience...SeniorPermanent employmentFull timeLocal areaWorldwideFlexible 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$250 per day
...brilliant media strategies into inspiring business results. We believe in the... ...customers. We are proud to say that human intelligence and teamwork are what fuels our... ...people, first and foremost. As a Senior Media Investment Specialist within a talented team, you will be...SeniorFull timeWork at officeFlexible hours1 day per week
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