Senior Business Intelligence Specialist

Position Summary:

The Senior Business Intelligence (BI) Specialist leads advanced analytics, data modeling, and enterprise reporting to deliver actionable insights for executive and operational decision-making. The role designs scalable BI solutions, drives data governance, and partners with cross-functional stakeholders to advance digital transformation and data literacy. 

Key Responsibilities

1. Analytics, Insights & Reporting

• Design, build, and automate executive and enterprise dashboards, KPI scorecards, and self-serve reports.
• Conduct deep-dive analysis, forecasting, and scenario modeling to identify trends, risks, and opportunities.
• Translate complex data into clear narratives and recommendations for leaders.
• Deliver clear and meaningful insights to executives and operational teams.
• Ensure data quality, accuracy, and consistency in all BI outputs.
• Translate business requirements into BI specifications and deliverables

2. Data Analytics & Insights

• Conduct advanced analytics, forecasting, and trend analysis.
• Identify risks, opportunities, and performance drivers using complex datasets.
• Support strategic planning through data modeling and scenario analysis.

3. Data Management & Modeling

• Develop and optimize data models, data marts, and analytical datasets.
• Collaborate with IT on data warehouse architecture and ETL pipelines.
• Ensure strong data governance, metadata standards, and validated data sources
• Evaluate emerging BI/AI features and lead proofs-of-concept for modernization

4. Stakeholder Partnership & Enablement

• Facilitate requirements gathering, define KPIs/definitions, and manage expectations.
• Provide training, documentation, and coaching to analysts and business users for BI tools and dashboards.
• Partner with leaders to understand information needs.
• Represent BI expertise on cross-functional initiatives (finance, operations, clinical/programs, IT).
• Support business case development and executive reporting.

5. Data Governance, Privacy & Compliance

• Apply data governance standards, stewardship practices, and data classification.
• Ensure privacy/security compliance (e.g., PHIPA/HIPAA as applicable) and ethical data usage.
• Maintain audit-ready documentation for models, transformations, and KPIs.

6. Advanced Analytics & AI-Enabled Insights

• Lead predictive analytics, segmentation, and advanced statistical methods when appropriate.
• Integrate Python/R or AutoML/AI features with BI reporting where beneficial.
• Operationalize analytics with monitoring, versioning, and continuous improvement.

7.Automation & Process Improvement

• Automate manual reporting and implement BI best practices.
• Improve efficiency and accuracy of analytics processes.
• Evaluate new technologies to enhance BI capabilities.

8. Project & Delivery Management

• Plan and manage BI projects end-to-end: scope, timeline, resourcing, and stakeholder updates.
• Support digital transformation and enterprise analytics initiatives.
• Work with cross-functional teams across IT, operations, clinical and finance
• Balance multiple priorities: escalate risks early and propose mitigation strategies.
• Ensure high-quality releases using peer review, testing, and deployment standards.

Qualifications

Education & Credentials

• Bachelor’s degree in Data/Analytics, Computer Science, Information Systems, Business, or related field
• Master’s degree preferred.
• Relevant certifications (e.g., Microsoft Power BI Data Analyst, Azure data certifications, Tableau) preferred.

Experience

• 5–8+ years in BI/analytics with proven experience building enterprise dashboards and complex data models.
• Strong background in SQL, DAX/Power BI (or Tableau), and data warehousing/ETL concepts.
• Experience working with executives and cross-functional teams; healthcare/LTC/public sector experience is an asset.

Technical Skills

• Advance Power BI (data modeling, DAX, Power Query), or Tableau; strong SQL (T-SQL).
• Data warehousing (e.g., SQL Server/Azure Synapse), ETL/ELT (e.g., ADF, SSIS, dbt).
• Version control (e.g., Git), DevOps/Deployment pipelines, and BI governance (RLS, CI/CD).
• Python/R for analytics and automation (asset); understanding of statistical/predictive methods.

Key Competencies

• Strong analytical thinking and problem solving.
• Excellent communication of complex data to non-technical audiences.
• Business acumen and understanding of operational performance.
• High attention to detail and data accuracy.
• Ability to influence stakeholders and collaborate across the organization.

Working Conditions

Fast-paced office environment within a large long-term care organization.

Requires balancing multiple priorities and deadlines.

Occasional extended hours during budget cycles, audits, or major reporting periods.

Salary Range - $78,000 - $113,000

Salary Range - $78,000 - $113,000