Business Intelligence Analyst (Hybrid - Markham, ON)
Top Benefits
About the role
Position Type: Full-time (Fixed-term, Approximately 14 months)
Department: IT
Work Location: Markham, Ontario
Work Hours: Monday - Friday, standard business hours
Work Arrangement: Hybrid
A proudly Canadian company, Sentrex Health Solutions is a fully integrated specialty distributor and patient support provider for pharmaceutical manufacturers, physicians, and their patients. We provide innovative solutions focused on ensuring patients have access and the support they need to maximize their treatment outcomes. We do this through strategic distribution models and patient support programs that are backed by powerful, integrated technology, a dedicated in-house creative agency, and experienced, cross-functional teams. Our core capabilities include Specialty Pharmacy Services, Customized Solutions for Warehouse, Wholesale & Distribution, Patient Support Programs, Strategic Creative Services as well as HCP & Clinic Services.
Come and join our team! But first, let us tell you why we love working here:
- We are 100% Canadian with locations across the country
- State-of-the-art facilities to provide high-quality products and services
- The opportunity to be a part of a winning, high-performing team
- Collaborative, engaging workplace culture – we are passionate about our people!
- Flexible working environment that promotes a healthy work-life balance
- Diverse and inclusive culture where your talent and commitment to excellence is welcomed and valued
- High-growth environment that provides opportunities for learning and growth supported by our Employee Development Program and industry-leading, in-house corporate training offered throughout the year
The Opportunity: In this role, the successful candidate will serve as an operational data subject matter expert (SME) within the organization in topics ranging from PSP, Pharmacy, finance and visualization and data presentation best practices. This role specializes in collecting, organizing and analyzing data from various resources and translating it into compelling reports and presentations for internal and external clients.
A Day in the Life (What you will do here):
- Develop reports, dashboards and self-serve data products using Power BI and Excel.
- Evaluate source data and build views required for high performing reporting and analytics.
- Practical knowledge of programming software and languages used for report building and data analysis. PBX, RDL, and SQL are mandatory. Knowledge and experience with Python is helpful.
- Collaborate regularly with various cross functional departments and stakeholders to understand their business reporting needs and requirements
- Generate analytical insights that drive the performance of a large-scale programs
- Support the team with mining data, data insights, data availability through producing reports and dashboards
- Assist in identifying opportunities in the business and works to produce impactful analysis
- Examine reporting relationships to increase end-user productivity, availability, and accuracy
- Working with the technical team to establish protocols to extract data in a standardized process from a variety of data sources
- Analyzing large amounts of data to provide concise, targeted reports for internal and external clients
- Able to work independently and with team to gather requirements and provide process recommendation to stakeholders
- Identify areas of opportunity to make a difference through the use of data
- Assist with other duties as assigned by the manager
What you need to ensure you are set up for success:
- Degree in Computer Science, Data Science or Business is an asset.
- 3-5 years of working experience navigating relational databases via SQL and NoSQL architectures
- Ability to write high performance SQL queries, including concepts like subqueries, common table expressions, and window functions
- Ability to work in a fast-paced environment and manage multiple projects through effective prioritization.
- Strong problem-solving skills and demonstrated ability to be highly creative in formulating solutions.
- Knowledge of Spark SQL, T-SQL, git and Python are assets
- Knowledge of data visualization and building dashboards in Power BI is a strong asset
- Knowledge of Data Lakehouse setup on Databricks is a strong asset
What makes you a great fit for this team:
- Your commitment to providing a high level of service to your internal and external clients.
- You are highly adaptable with a track record of success during times of growth and organizational change.
- You have a proven track record of developing trust and influence at multiple levels.
- You demonstrate an impactful and candid communication style.
- You have exceptional organizational skills with the ability to build effective working relationships with colleagues, management, and stakeholders.
Why join Sentrex? We value our employees! Our permanent full-time employees are provided with a:
- Competitive Salary and generous vacation entitlement
- Wellness Program (5 paid days off for your well-being!)
- Paid Sick Days
- Competitive Benefits Package including Dental & Extended Health Benefits, AD&D, LTD & Employee/Dependent Life Insurance
- Employee & Family Assistance Program
- RRSP Matching Program
Sentrex Health Solutions is proud to be an equal opportunity employer demonstrated by our commitment to diversity, inclusion, belonging, equity, and accessibility. We provide a safe space for all team members to express their individuality within our corporate culture.
We encourage you to apply and accept all applications. We realize that not every candidate will meet every single desired qualification. If your experience looks a little different from what we have identified and you think you can bring value to the role, we would love to learn more about you!
Accommodations can be made available upon request for those candidates taking part in the selection process.
About Sentrex Health Solutions
Proudly Canadian, Sentrex is a patient support services provider, specialty pharmacy, and pharmaceutical distributor committed to simplifying access to care and improving patients’ lives. Founded in 2017 with a bold vision to challenge the industry’s status quo, we’ve grown rapidly—supporting over 60,000 PSP patients and 140,000 pharmacy patients across Canada in just five years. Today, our national presence includes 7 specialty pharmacy locations and a network of PerCuro by Sentrex specialty clinics, all dedicated to redefining care and exceeding expectations. Agile and responsive, we adapt quickly to meet our clients’ evolving needs, while empowering our people to make a meaningful impact every day.
Sentrex, une entreprise fièrement canadienne, est un fournisseur de services de soutien aux patients, une pharmacie spécialisée et un distributeur de produits pharmaceutiques, déterminée à simplifier l’accès aux soins et à améliorer la vie des patients. Fondée en 2017 avec une vision audacieuse pour remettre en question le statu quo de l’industrie, Sentrex a connu une croissance rapide, soutenant plus de 60 000 patients par l’intermédiaire de ses programmes de soutien et plus de 140 000 patients faisant appel à ses services pharmaceutiques partout au Canada en seulement cinq ans. Aujourd’hui, nous sommes présents à l’échelle nationale et possédons sept pharmacies spécialisées et un réseau de cliniques spécialisées PerCuro de Sentrex, qui visent toutes à redéfinir les soins et à dépasser les attentes. Agiles et réactifs, nous nous adaptons rapidement afin de répondre aux besoins changeants de nos clients, tout en donnant à nos employés les moyens de faire une réelle différence tous les jours.
Business Intelligence Analyst (Hybrid - Markham, ON)
Top Benefits
About the role
Position Type: Full-time (Fixed-term, Approximately 14 months)
Department: IT
Work Location: Markham, Ontario
Work Hours: Monday - Friday, standard business hours
Work Arrangement: Hybrid
A proudly Canadian company, Sentrex Health Solutions is a fully integrated specialty distributor and patient support provider for pharmaceutical manufacturers, physicians, and their patients. We provide innovative solutions focused on ensuring patients have access and the support they need to maximize their treatment outcomes. We do this through strategic distribution models and patient support programs that are backed by powerful, integrated technology, a dedicated in-house creative agency, and experienced, cross-functional teams. Our core capabilities include Specialty Pharmacy Services, Customized Solutions for Warehouse, Wholesale & Distribution, Patient Support Programs, Strategic Creative Services as well as HCP & Clinic Services.
Come and join our team! But first, let us tell you why we love working here:
- We are 100% Canadian with locations across the country
- State-of-the-art facilities to provide high-quality products and services
- The opportunity to be a part of a winning, high-performing team
- Collaborative, engaging workplace culture – we are passionate about our people!
- Flexible working environment that promotes a healthy work-life balance
- Diverse and inclusive culture where your talent and commitment to excellence is welcomed and valued
- High-growth environment that provides opportunities for learning and growth supported by our Employee Development Program and industry-leading, in-house corporate training offered throughout the year
The Opportunity: In this role, the successful candidate will serve as an operational data subject matter expert (SME) within the organization in topics ranging from PSP, Pharmacy, finance and visualization and data presentation best practices. This role specializes in collecting, organizing and analyzing data from various resources and translating it into compelling reports and presentations for internal and external clients.
A Day in the Life (What you will do here):
- Develop reports, dashboards and self-serve data products using Power BI and Excel.
- Evaluate source data and build views required for high performing reporting and analytics.
- Practical knowledge of programming software and languages used for report building and data analysis. PBX, RDL, and SQL are mandatory. Knowledge and experience with Python is helpful.
- Collaborate regularly with various cross functional departments and stakeholders to understand their business reporting needs and requirements
- Generate analytical insights that drive the performance of a large-scale programs
- Support the team with mining data, data insights, data availability through producing reports and dashboards
- Assist in identifying opportunities in the business and works to produce impactful analysis
- Examine reporting relationships to increase end-user productivity, availability, and accuracy
- Working with the technical team to establish protocols to extract data in a standardized process from a variety of data sources
- Analyzing large amounts of data to provide concise, targeted reports for internal and external clients
- Able to work independently and with team to gather requirements and provide process recommendation to stakeholders
- Identify areas of opportunity to make a difference through the use of data
- Assist with other duties as assigned by the manager
What you need to ensure you are set up for success:
- Degree in Computer Science, Data Science or Business is an asset.
- 3-5 years of working experience navigating relational databases via SQL and NoSQL architectures
- Ability to write high performance SQL queries, including concepts like subqueries, common table expressions, and window functions
- Ability to work in a fast-paced environment and manage multiple projects through effective prioritization.
- Strong problem-solving skills and demonstrated ability to be highly creative in formulating solutions.
- Knowledge of Spark SQL, T-SQL, git and Python are assets
- Knowledge of data visualization and building dashboards in Power BI is a strong asset
- Knowledge of Data Lakehouse setup on Databricks is a strong asset
What makes you a great fit for this team:
- Your commitment to providing a high level of service to your internal and external clients.
- You are highly adaptable with a track record of success during times of growth and organizational change.
- You have a proven track record of developing trust and influence at multiple levels.
- You demonstrate an impactful and candid communication style.
- You have exceptional organizational skills with the ability to build effective working relationships with colleagues, management, and stakeholders.
Why join Sentrex? We value our employees! Our permanent full-time employees are provided with a:
- Competitive Salary and generous vacation entitlement
- Wellness Program (5 paid days off for your well-being!)
- Paid Sick Days
- Competitive Benefits Package including Dental & Extended Health Benefits, AD&D, LTD & Employee/Dependent Life Insurance
- Employee & Family Assistance Program
- RRSP Matching Program
Sentrex Health Solutions is proud to be an equal opportunity employer demonstrated by our commitment to diversity, inclusion, belonging, equity, and accessibility. We provide a safe space for all team members to express their individuality within our corporate culture.
We encourage you to apply and accept all applications. We realize that not every candidate will meet every single desired qualification. If your experience looks a little different from what we have identified and you think you can bring value to the role, we would love to learn more about you!
Accommodations can be made available upon request for those candidates taking part in the selection process.
About Sentrex Health Solutions
Proudly Canadian, Sentrex is a patient support services provider, specialty pharmacy, and pharmaceutical distributor committed to simplifying access to care and improving patients’ lives. Founded in 2017 with a bold vision to challenge the industry’s status quo, we’ve grown rapidly—supporting over 60,000 PSP patients and 140,000 pharmacy patients across Canada in just five years. Today, our national presence includes 7 specialty pharmacy locations and a network of PerCuro by Sentrex specialty clinics, all dedicated to redefining care and exceeding expectations. Agile and responsive, we adapt quickly to meet our clients’ evolving needs, while empowering our people to make a meaningful impact every day.
Sentrex, une entreprise fièrement canadienne, est un fournisseur de services de soutien aux patients, une pharmacie spécialisée et un distributeur de produits pharmaceutiques, déterminée à simplifier l’accès aux soins et à améliorer la vie des patients. Fondée en 2017 avec une vision audacieuse pour remettre en question le statu quo de l’industrie, Sentrex a connu une croissance rapide, soutenant plus de 60 000 patients par l’intermédiaire de ses programmes de soutien et plus de 140 000 patients faisant appel à ses services pharmaceutiques partout au Canada en seulement cinq ans. Aujourd’hui, nous sommes présents à l’échelle nationale et possédons sept pharmacies spécialisées et un réseau de cliniques spécialisées PerCuro de Sentrex, qui visent toutes à redéfinir les soins et à dépasser les attentes. Agiles et réactifs, nous nous adaptons rapidement afin de répondre aux besoins changeants de nos clients, tout en donnant à nos employés les moyens de faire une réelle différence tous les jours.