Business Intelligence Analyst

Position Type:                  Full-time

Department:                    IT

Work Location:               Markham, Ontario

Work Hours:                    8:30am - 5:00pm

Work Arrangement:     Remote

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
• Quarterly virtual social events!

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):

• Analyze large datasets to generate actionable insights and drive performance improvements for large-scale programs.
• Design, develop, and maintain dashboards and self-serve reporting tools using SQL, SSRS, SSIS, Power BI, and Excel.
• Collaborate with cross-functional teams to understand business reporting needs and deliver solutions.
• Provide detailed, concise reports for internal and external stakeholders, ensuring data accuracy and clarity.
• Develop and implement protocols for standardized data extraction from various sources.
• Identify business opportunities through data analysis and recommend actionable strategies.
• Continuously monitor and improve reporting processes to enhance productivity, accuracy, and data availability.
• Work independently and within a team to gather requirements and offer process recommendations.
•  Support the technical team in optimizing data workflows and ensuring seamless integration across platforms.
• Assist with other duties as assigned by the manager

 What you need to ensure you are set up for success:

• Minimum 5 years of experience with SQL and NoSQL databases, including the ability to write complex queries (subqueries, CTEs, window functions), along with 5 years of experience in data visualization and dashboard development using Power BI.
• Advanced proficiency in Microsoft Office applications, including Excel (advance functions), Access, SharePoint Lists, and VBA.
• Ability to thrive in a fast-paced environment and manage multiple projects effectively.
• Exceptional problem-solving skills with the ability to analyze complex data and deliver creative, actionable solutions.
• Strong communication skills, with the ability to influence stakeholders and present findings clearly.
• Attention to detail and commitment to data accuracy.
• At least 1 year of experience with Azure Data Factory, Spark SQL, T-SQL, Git, and Python.
• At least 3 years of experience with Data Lakehouse architecture on Databricks is preferred.
• Experience in pharma, insurance, finance and/or healthcare is a plus, as it will enhance the ability to delivery business-focused insights.
• Degree in Data Science, Business, or related field.

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

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.