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. Please note that this is a hands-on role; it requires in-depth involvement in data modelling, cloud solutioning, BI architecture and design, as well as peer-reviewing code and ensuring accuracy, and compliance with best practices.

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

Key Accountabilities:

1. Operational Excellence & Team Leadership (30%)

Manage and mentor a team of BI and data developers and analysts currently supporting legacy systemsEnsure business continuity by maintaining current MicroStrategy, SSIS, and SQL Server operations (among other legacy technologies)Oversee ticket resolution, SLAs, and operational metrics – take active role in development and support in addressing tickets and production issuesBalance team workload between maintenance and transformation activitiesAddress production issues on an ad-hoc basis. Sometimes production issues occur outside of regular hoursPeer-review development efforts, coding and other artifacts to ensure compliance and adherence to best practices. Mentor team as required.Conduct performance reviews and career development planning

2. Transformation Leadership & Skills Development (20%)

Act as Subject Matter Expert on cloud technologies including Azure services, Azure ML, API data integrations, Azure SQL Managed Instances, and Azure Data FactoryAssess current team capabilities against cloud transformation requirementsDesign and implement comprehensive Azure/Power BI training programsCreate individual development plans transitioning team members from legacy to modern skillsThe 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

3. Project Management & Stakeholder Engagement (20%)

Lead requirements gathering sessions with business stakeholdersManage multiple concurrent projects across legacy maintenance and new cloud initiativesCoordinate with external vendors and implementation partnersProvide regular status updates to leadershipManage project timelines, budgets, and resource allocation

4. Technical Architecture & Strategy (20%)

Design transition architectures that bridge legacy and modern systemsDefine data architecture standards for Microsoft Fabric implementationGuide migration strategies from SSIS to Azure Data FactoryEstablish best practices for Power BI adoption and governanceReview and approve technical designs for both current and future state

5. Data Governance & Quality Leadership (10%)

Champion data governance initiatives including MDM strategyCollaborate on Microsoft Purview implementationEstablish 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-premModern Cloud (Must Have): Hands-on experience with Azure Data Platform, Power BI or Microsoft Fabric, and Azure Data Factory among other Azure servicesArchitecture: Proven experience designing enterprise data architecturesMigration Experience: Led at least one major BI platform transformationSpecialized Knowledge: Data warehousing, Data Engineering, Data ModellingNice to have: Azure ML, Machine Learning, Data Science, Python

Leadership & Soft Skills

1+ years of leading or managing technical teamsDemonstrated ability to upskill teams through technology transitionsExceptional communication skills to translate between technical and business stakeholdersStrong project management capabilities

Educational Requirements

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

Why Join SE Health?

Competitive Compensation – Enjoy a Total Rewards package including salary, benefits, pension, performance incentives, on demand pay, car loan support 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, we love what we do.  Every day, we bring hope and happiness to clients, homes, and communities across Canada.  We treat each person with dignity and love, like our own family; we build empathy; and we do the right thing. We are always inspired to make a difference. As a not-for-profit social enterprise, we share knowledge, provide the best care, and help each client to realize their most meaningful goals for health and wellbeing. We are an inclusive workplace offering competitive pay, benefits, pension, and work life balance. We’re a great place to work, and we hope you’ll join our team.

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 careers@sehc.com at your earliest convenience.