Business Intelligence Analyst (Hybrid - Markham, ON)

Position Type:                  Full-time

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.