Manager of Enterprise Data and Business Intelligence

Saint Elizabeth; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading healthcare organization in Toronto seeks a Manager of Enterprise Data and Business Intelligence. This pivotal role requires overseeing a data team and transforming legacy systems into cloud-based solutions. Candidates should have extensive experience in data management, leadership, and a strong understanding of cloud technologies like Azure and Power BI. This hybrid position offers competitive compensation and a chance to make a meaningful impact in the healthcare sector.

Benefits

Competitive Compensation

Tuition assistance

Flexible scheduling

Qualifications

• 5+ years of experience in data sphere (developer, analyst, scientist).
• 1+ year in team lead or management experience.
• Strong project management capabilities (PMP or equivalent preferred).

Responsibilities

• Manage and mentor a team of BI and data developers.
• Ensure business continuity while transitioning to cloud technologies.
• Lead requirements gathering sessions with business stakeholders.

Skills

Team leadership

Data analysis

Cloud technologies

Communication

Education

Bachelor's degree or equivalent

Tools

Microsoft Power BI

Azure Data Factory

SQL Server

Job description

Join us in re-imagining health care with the largest social enterprise in Canada. SE Health is leading a multi-year enterprise transformation project that leverages human-centered design to be at the forefront of innovation within the healthcare sector. As a leader in home care, we are expanding and enhancing our capabilities to provide personalized experiences using new platforms and cloud-native architectures, ensuring privacy and security by design. Our transformation is grounded in guiding principles drive to ensure that we prioritize team decisions, long-term planning, process standardization, data-driven insights, and balanced user adoption. If you are driven by the desire to have an impact, change the world of health care and shape the future, we invite you to be part of our journey.

Position Summary:
SE Health is seeking an experienced Manager of Enterprise Data and Business Intelligence to lead our critical transformation from legacy on-premises systems (SQL Server 2009, SSIS, SSRS, SSAS, MicroStrategy) to a modern cloud-based Microsoft ecosystem (Microsoft Fabric, Power BI, Azure ML). This pivotal role combines people leadership, technical architecture, and transformation management to ensure business continuity while driving innovation.
The successful candidate will manage a team of 5 or 6 data professionals, maintaining current operations while orchestrating their transition to cloud technologies. This position requires a unique blend of legacy system knowledge, modern cloud expertise, and exceptional change management skills to bridge the gap between where we are and where we need to be.

Location: Hybrid (Markham office) with occasional on-site requirements as needed

Key Accountabilities:

Operational Excellence & Team Leadership

• Manage and mentor a team of BI and data developers and analysts currently supporting legacy systems
• Ensure business continuity by maintaining current MicroStrategy, SSIS, and SQL Server operations (among other legacy technologies)
• Oversee ticket resolution, SLAs, and operational metrics
• Balance team workload between maintenance and transformation activities
• Conduct performance reviews and career development planning

Transformation Leadership & Skills Development

• Assess current team capabilities against cloud transformation requirements
• Design and implement comprehensive Azure/Power BI training programs
• Create individual development plans transitioning team members from legacy to modern skills
• The individual is expected to mentor the team in using cloud solutions and technologies. Therefore, the incumbent must have adequate knowledge of the future-state technologies (such as Power BI, Microsoft Fabric Stack, Azure Data Factory, etc.)
• Build a culture of continuous learning and cloud-first thinking

Project Management & Stakeholder Engagement

• Lead requirements gathering sessions with business stakeholders
• Manage multiple concurrent projects across legacy maintenance and new cloud initiatives
• Coordinate with external vendors and implementation partners
• Provide regular status updates to leadership
• Manage project timelines, budgets, and resource allocation

Technical Architecture & Strategy

• Design transition architectures that bridge legacy and modern systems
• Define data architecture standards for Microsoft Fabric implementation
• Guide migration strategies from SSIS to Azure Data Factory
• Establish best practices for Power BI adoption and governance
• Review and approve technical designs for both current and future state

Data Governance & Quality Leadership

• Champion data governance initiatives including MDM strategy
• Collaborate on Microsoft Purview implementation
• Establish data quality standards and monitoring frameworks

Qualifications:
5+ years of experience in data sphere (developer, analyst, scientist, ETL, or analytics project manager); at least 1+ in team lead or supervision or management experience.

Technical Expertise

• Legacy Systems
  (Must Have): Deep understanding of SQL Server, SSIS, SSRS, SSAS, OLAP concepts, and on-prem solutions
  (Nice to have): MicroStrategy on-prem
• Modern Cloud (Must Have): Hands-on experience with Azure Data Platform, Power BI or Microsoft Fabric, and Azure Data Factory among other Azure services
• Architecture: Proven experience designing enterprise data architectures
• Migration Experience: Led at least one major BI platform transformation
• Specialized Knowledge: Data warehousing, Data Engineering, Data Modelling
• Nice to have: Azure ML, Machine Learning, Data Science, Python

Leadership & Soft Skills

• 1+ years of leading or managing technical teams
• Demonstrated ability to upskill teams through technology transitions
• Exceptional communication skills to translate between technical and business stakeholders
• Strong project management capabilities (PMP or equivalent preferred)

Educational Requirements

• Bachelor's degree or equivalent
• Relevant Microsoft certifications (Azure Data Engineer, Power BI) are strongly preferred

Critical Considerations for This Role

• This position is unique because it requires someone who can:
• Respect the past - Understanding why legacy systems were built the way they were
• Navigate the present - Managing day-to-day operations without disruption

• Build the future - Leading transformation while bringing the team along

Why Join SE Health?

• Competitive Compensation – Enjoy a Total Rewards package including salary, benefits, pension, performance incentives, on demand pay and exclusive staff perks.
• Flexibility & Support – Our SE Flex program offers a unique hybrid model with work-from-home options, flexible scheduling, and a supportive culture to help you thrive.
• Meaningful Impact – As a Social Enterprise, your work directly supports improving lives across Canada. Your voice matters, and innovation is encouraged.
• Growth & Development – Access tuition assistance, training, and career advancement opportunities across our growing organization.
  

About SE Health
At SE Health, our people are everything—and our Home Office is an important part of that culture. When you choose to join SE Health, you become part of a caring, purpose-driven team that’s making a real difference across the country. Our Home Office is where innovation meets impact—supporting our direct care teams, driving strategic growth, and helping to shape the future of health care. As a member of our amazing Home Office team, you’ll collaborate with passionate colleagues, bring bold ideas to life, and contribute to meaningful work that supports thousands of care interactions each day. We believe in growing together, investing in our people, and creating an inclusive workplace where you can be yourself. Learn why you come first at SE Health.

In the interest of the health and safety of our patients/clients, employees, and greater good of public health, SE Health requires those that wish to work for this organization to be fully vaccinated against COVID-19. Fully vaccinated means a person has received both doses of the COVID-19 vaccine and it has been 14 days since the last dose.

SE Health is committed to the success of all its employees. If you feel you need accommodations because of illness or disability, please do not hesitate to contact the Talent Acquisition team at [e-mail] at your earliest convenience.