Trillium Health Partners

Senior Business Intelligence Data Engineer (Institute for Better Health)

System ID
Job Type
Temporary Full-Time
Mississauga Hospital
Number of Positions

Job Description


Job ID: 2023-35072

Position: Senior Business Intelligence Data Engineer (Institute for Better Health)

Status: Full-Time, Temporary (2 years with opportunity for extension)

Department: Data, Insights & Advanced Analytics, Institute for Better Health

Site: Mississauga Hospital & Remote (Hybrid)

Posted: October 2023

Role Level: Professional Group 13 ($53.02 to $66.25)


A New Kind of Health Care for a Healthier Community. That’s our mission at Trillium Health Partners (THP), one of the largest community-based acute care facilities in Canada. Comprised of the Credit Valley Hospital, the Mississauga Hospital and the Queensway Health Centre, along with several satellite locations, THP serves the growing and diverse populations of Mississauga, West Toronto and surrounding communities, is a teaching hospital affiliated with the University of Toronto and home to Institute for Better Health.


When we set out to build our vision and future, we connected with our community - patients, families, visitors, physicians, staff and volunteers. The foundational goals of our new strategic plan - quality, access and sustainability - anchor everything we do. Our mission for a new kind of health care is built on an inter-connected system of care organized around patients - inside and outside the hospital.


The Institute for Better Health (IBH) is a critical component of THP, the research, innovation and revenue generating division of THP driven to find innovative, evidence-based approaches to solving the most complex health care challenges and building a culture of innovation at all levels across THP with our partners beyond our walls. IBH was created to help shape a new kind of health care for a healthier community and currently leads research and innovation projects that align with the hospital’s goals and supports the advancement of research and innovation across the hospital – all with the intent of improving health and transforming care. Being embedded in one of the largest hospitals in Ontario offers exciting opportunities to test solutions that can be adapted to impact health in our community, province, country and beyond. IBH and THP truly are the place where we bring leading evidence and research to life. With our partners in the community, IBH offers the perfect catchment for both broad health system study and impact.


Learn more about IBH here:


If you are passionate about your career, motivated to improve the health of the community, committed to excellence, quality and patient safety consider joining our Better Together team!

Position Overview:   


Innovation is a key enabler to achieving Trillium Health Partner’s (THP) mission of a new kind of healthcare for a healthier community as outlined in the organization’s 2019-29 Strategic Plan. The Senior Business Intelligence Data Engineer will play a key role in advancing data and advanced analytics at the organization and will be responsible for building a state of the art data platform in collaboration with team members, extracting data from health information platforms such as Epic, designing and building data pipelines both on-prem and in the cloud, managing data storage, and creating sustainable dashboard solutions.


This role will report into the Manager, Data, Insights & Advanced Analytics. The Data, Insights & Advanced Analytics portfolio strives to shape a healthier tomorrow through innovative uses of data and analytics focusing on population health, artificial intelligence, cloud computing, governance, privacy and security, and business development, with the mandate to build our state-of-the-art population health data platform to empower our researchers and partners. This individual will work as a core member of a rapidly growing data team of technologists, data engineers, data scientists and clinicians at IBH while working closely with THP’s Business Intelligence team.

 Job Responsibilities:

  • Providing technical direction and quality control oversight, expertise, and review to ensure integration of all IBH projects – current, previous, and planned – working collaboratively with BI and IBH team members to ensure adherence to BI team standards (e.g. project documentation, formatting, programming, etc.).
  • Managing data integration: This includes designing and implementing solutions to integrate data from multiple sources including Epic, and ensuring data is properly transformed and cleansed during the integration process.
  • Defining data models and schemas: This includes creating data models that accurately represent the organization’s data, and designing schemas that support efficient data storage and retrieval. 
  • Designing and building data pipelines: This includes extracting data from various sources including Epic, transforming and cleaning the data, and loading it into a data warehouse or cloud infrastructure.  
  • Optimizing data processing: This includes making sure data is processed as quickly and efficiently as possible, using techniques such as indexing, partitioning, and clustering.  
  • Design, development, and deployment of BI, infrastructure and tools that support data analysis and reporting. This includes designing and building data pipelines, managing data storage, and optimizing data processing.
  • Designing, developing, deploying, monitoring, and maintaining integrated databases adhering to industry standards and best practice.
  • Troubleshooting technical issues and providing technical support for the IBH team, researchers and other stakeholders.
  • Writing functional and technical specifications and user documentation for databases and applications.
  • Responsible for consulting with internal and external stakeholders to collect requirements and designing integrated data pipelines that are delivered with a high level of quality, on time and provide business value.
  • Ensuring that THP’s data is accurate, accessible, and secure and that IBH is able to gain timely access to data for research and innovation, extract insights and make data-driven decisions from that data.
  • Promoting team effectiveness by facilitating collaboration, sharing of best practice, innovation, bringing divergent views to consensus, teamwork, and ensuring timely communication of issues and points of interest.

Key Qualifications:

  • University degree in Computer Science, Information Technology, or a related field.
  • Significant experience working as a data engineer or similar role (i.e. > than 5 years), specifically within cloud environments.
  • Significant experience creating end to end data solutions that address data integrity, security, reliability, failure recovery, encryption, logging, monitoring, etc.
  • Proficiency with AWS data services (such as AWS Glue, Redshift, RDS, DynamoDB, S3, and SageMaker) or Azure data services (such as Azure Data Factory, Azure Databricks, Azure SQL Database, Data Lake, Cosmos DB, and Azure ML) preferred.
  • Strong proficiency in SQL and experience with other languages such as Python, Java, Scala, C# or PowerShell.
  • Experience with data pipeline and workflow management tools.
  • Experience with data warehousing solutions and BI tools, such as Amazon Quicksight, Azure Synapse Analytics and Power BI.
  • Knowledge of Data modeling, SSRS, SSAS, SQL Server (2016-2023), and advanced SQL Scripting.
  • Experience managing / leading large BI projects or processes with limited oversight from manager.
  • Experience in reporting KPIs and other forms of performance reporting.
  • Experience in translating business requirements into effective Business Intelligence solutions.
  • Experience with healthcare data (incl. DAD/NACRS), population health data and/or research an asset.
  • Experience and / or certification with Epic is an asset, or willingness to receive Epic training.
  • Ability to succeed in a team-oriented environment under dynamic conditions.
  • Good presentation skills with solid communication capabilities and practices, both oral and written.
  • Willingness and ability to learn.
  • Strong problem-solving skills, interpersonal skills, attention to detail, and analytical thinking abilities.
  • Ability to work on difficult and complex problems under pressure and tight timelines.


Please disclose any use of Generative AI in your resume, submission, or interview.


Building an Anti-Racist, Equitable and Inclusive Team and Why it is Important to Us – A new Kind of Health Care for a Healthier Community:


When we set out to build our vision and future, we connected with and heard from our community - patients, families, visitors, physicians, staff and volunteers. Our plan to create a new kind of health care for a healthier community means advancing health across the hospital, the system and the community and is built on an inter-connected system of care organized around patients - inside and outside the hospital. Recognizing this mission could not be realized without also assessing and investing in our internal practices, culture and processes we are building an organization where everyone at THP feels they belong, their voice matters, and contributes to our collective success.  We commit to making systemic fairness a reality for all and are working to ensure that the community we serve is reflected at all levels, and in all professions at THP.  Diversity is our strength and we recognize and value teaching and learning we all contribute and benefit from in our environment; our unique lived experiences matter and shape our actions and behaviors.  In becoming an antiracist organization, we acknowledge the existence of oppression, racism, bias and complicity, and we have been working steadily to make changes in the way we work to dismantle these barriers. This includes developing and realizing an action plan to advance racial equity and embed anti-racism accountability across IBH, starting with our anti-Black racism priority initiative.


Work Environment:


Our main offices are located at our Mississauga Hospital; due to the COVID-19 pandemic and our Trillium HealthWorks we have successfully transitioned to a hybrid work model.  While we do not know exactly what our office of the future will look like, we do know that remote work works and that flexibility is paramount.  Our leadership team believes that remote work will be key to helping build an inclusive environment where individuals can contribute their skills and expertise.  We plan to continue supporting flexible work arrangements, balancing the need to occasionally go into the office or meet in person for operational requirements.


Important Message for Potential Applicants:


If you do not see yourself fully reflected in every job requirement listed on this posting, we still encourage you to reach out and apply. Research has shown candidates from underrepresented groups often only apply when they feel 100% qualified. We encourage applicants who are members of groups that have been marginalized on any grounds enumerated under the Ontario Human Rights Code to consider this opportunity.


As an Equal Opportunity Employer we are committed to providing an inclusive and barrier-free work environment, starting with our hiring processes.  If selected to participate in the recruitment and selection process for this opportunity and you need to be accommodated during any phase of the evaluation process, please inform our Human Resources Recruiter to request specialized accommodation(s) that you may require in respect of any materials or processes used to ensure your equitable participation.  All information received in relation to accommodation will be kept confidential.


Trillium Health Partners is an equal opportunity employer committed to fostering a healthy, safe and respectful environment for healing, based on our values compassion, excellence and courage.  To be Better Together, we commit to fostering a respectful workplace culture that promotes a safe and supportive environment for everyone who provides care, supports caregiving, receives care or visits the hospital.


Applicants must be eligible to work in Canada. We would like to thank all applicants for their interest in this position, however, only those selected for an interview will be contacted. Trillium Health Partners is recognized under the French Language Services Act.


As a condition of employment, we require all staff to be fully vaccinated for COVID19, in addition to other vaccinations required by the Public Hospitals Act. 


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed