McKesson BI Analytics Developer in Ontario, Canada

McKesson is in the business of better health and we touch the lives of patients in virtually every aspect of healthcare. At McKesson Canada, we touch the lives of 12 million Canadians every day. We carry more than 35,000 products in 17 distribution centers and ultimately provide distribution to 6,300 retail pharmacies, 1,350 hospitals, long-term care centers, clinics and institutions all over Canada. But we're so much more than a distribution company. We've automated 2,500 retail pharmacies and dispense over 100 million doses a year through our automation solutions. Manufacturers, healthcare providers and patients count on us for a full range of services that contribute to the quality and safety of care for us all.

At McKesson Canada, you’ll help us carry out our mission to improve lives and advance healthcare. Working here is your opportunity to shape an industry that’s vital to us all.

Job Summary

  • This position requires an individual with strong Microsoft SSAS, SSRS and SSIS development skills to manage and extend the use of cubes, data marts and/or views. Incumbent will be responsible for guiding, recommending, and developing enhancements to the environment, and supporting SQL reporting and analytics environments.He/she will be responsible for developing solutions which will improve the McKesson efficiency and analytic capabilities by enhancing our BI environment.

Section A – Specific Responsibilities

Duties and responsibilities include but are not limited to:

  • Work collaboratively with Business teams to build data cube solutions for the business

  • Improve analytic capabilities of the BI environment.

  • Automate processes in order to improve team efficiencies.

  • Improve processes to enhance the quality of the underlying data.

  • Review current processes and advise on database design plans to support business needs

  • Develop quality control processes to ensure quality of data feeds

  • ETL development to automate data feeds to the data warehouse from various internal and external sources of data

  • Standardizing coding of data to enable better data consolidation

  • Documenting processes and supporting development of a data dictionary

  • Support and maintain regularly scheduled weekly, monthly and quarterly updates to the database

Section B – General Responsibilities

  • Fully qualified to execute the functions related to job/role; work independently on most aspects of work.

  • Coaches and mentors other colleagues on Microsoft BI environment

  • Seeks and provides candid and timely feedback to improve performance; shares information in an open manner; fosters teamwork and innovation by involving others in problem solving, decision-making and creative thinking.

  • Ensures that commitments toward internal and external customers are met in a timely and cost-effective manner; solicits feedback from customers to identify opportunities to improve products and/or services; resolves minor conflicts, and involves others in conflict or problem resolution.

  • Develops internal and external relationships, with emphasis on those that facilitate the achievement of job/role accountabilities, such as relationships with key suppliers, customers and internal service providers.

  • Ensures to respect and adhere to company policies and procedures.

  • May participate in some aspects of project management; may be asked to review work delivered by external suppliers.

  • Ensures to sustain job performance standards and objectives set through the progress and appraisal guidelines.

Section C – Position Requirements

  • Bachelor’s Degree in Computer Science or related field

  • Minimum of 7 years in Information Technology

  • Minimum of 5 years as an analyst/programmer

  • Certification with Microsoft SQL Server SSAS, SSRS, and SSIS an asset

  • Experience in Microsoft SQL Server SSAS, SSRS, and SSIS, Power BI

  • Experience with vb.Net / C# / ASP.Net RestAPI an asset

  • Strong knowledge of Business Intelligence solutions

  • Experienced with dealing with data from multiple sources with varying data quality issues

  • Experienced with Oracle and MS SQL Server environments

  • Good analytical capacity

  • Ability to work in a team

  • Good written and oral communication skills in both French and English

  • Organized, methodical with rigorous work approach

  • Ability to work efficiently under pressure

  • Ability to work autonomously

  • Ability to work in crisis situations and in multi-tasks mode

Benefits & Company Statement

McKesson believes superior performance – individual and team – that helps us drive innovations and solutions to promote better health should be recognized and rewarded. We provide a competitive compensation program to attract, retain and motivate a high-performance workforce, and it’s flexible enough to meet the different needs of our diverse employee population.

We are in the business of better health and we touch the lives of patients in virtually every aspect of healthcare. We partner with payers, hospitals, physician offices, pharmacies, pharmaceutical companies and others across the spectrum of care to build healthier organizations that deliver better care to patients in every setting.

But we can’t do it without you. Every single McKesson employee contributes to our mission—whatever your title, whatever your role, you act as a catalyst in a chain of events that helps millions of people all over the globe. Talented, compassionate people are the future of our company—and of healthcare. At McKesson, you’ll collaborate on the products and solutions that help us carry out our mission to improve lives and advance healthcare. Working here is your opportunity to shape an industry that’s vital to us all.

Qualified applicants will not be disqualified from consideration for employment based upon criminal history.

Job Specifics

Grade: 103

Job Family Title: CAN-Analyst / Programmer 2

Recruiting Disclaimer

The material contained herein is provided for informational purpose only. All open jobs offered by McKesson Canada on this recruitment system are subject to specific job skill requirements. The job skill requirements, qualifications, and preferred experience are determined by a subsidiary, office or department within the company which is offering the position, and all positions are subject to local prevailing employment laws and restrictions. This would include immigration laws pertaining to work authorization requirements and any other applicable government permissions or compliance.

The materials on this site are provided without warranties of any kind, either expressed or implied, including but not limited to warranties regarding the completeness of information contained on this site or in any referenced links. While McKesson Canada attempts to update this site on a timely basis, the information is effective only as of the time and date of posting.

By providing your application to McKesson Canada you hereby consent to McKesson Canada obtaining personal information regarding you that is related to the position applied for. You also consent to McKesson Canada transferring your application details to our recruitment partners for their review and assistance. You also consent to McKesson Canada keeping your application on file.

McKesson Canada is an equal opportunity employer and values diversity in its workforce. We encourage applications from all qualified individuals and will accommodate applicants' needs, up to the point of undue hardship, throughout all stages of the recruitment and selection process.

The information on this site is for information purpose only and is not intended to be relied upon with legal consequence.

Job: Data Management

Organization: McKesson Canada

Title: BI Analytics Developer

Location: Canada-Ontario-Oakville

Requisition ID: 18006318