Job Description
Your ConsentGoogle AnalyticsWe may use Google Analytics to measure how you interact with our website in order to improve the user experience. To learn more about Google Analytics privacy practices and opt-out, click here .Google Analytics for RemarketingMarketoServiceTickSessionCamClickTalePardotDoubleClickBrightCoveTwitterHTML5 StorageOther Tracking Technologies UsedWe may use other tracking technologies to collect and store personal information about your visit to our website. They may include:Server Logs – used to track the website traffic (i.e. number of website visitors, number of visitor per page, IP address, etc.). We may use this information to analyze the website traffic in order to improve our business and user experience.Web Beacons – used to collect aggregate information (i.e. loading errors, most visited website pages, etc.). We may use web beacons to help display website content that is relevant to you and generate website traffic statistics to enhance our website.Embedded Content and FeaturesHow We Respond to “Do Not Track” SignalsMcKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health, happiness, and well-being of you and those we serve – we care.What you do at McKesson matters. We foster a culture where you can grow, make an impact, and are empowered to bring new ideas. Together, we thrive as we shape the future of health for patients, our communities, and our people. If you want to be part of tomorrow’s health today, we want to hear from you. ------------------------------------------------------------------------------------------------------------------------- Specific Responsibilities Design, develop and maintain Data platform solutions Develops databases and ETLs from scratch, Implements data pipelines, schedule and orchestrate jobs, automate tasks, Produce design documents according pre-determined methodology or process, Design, code and debug according to pre-determined standards; code review as required , Perform unit testing, integration and performance testing Promotions to different environments Be proactive and provide status of effort accomplished , estimates of remaining effort, and issues impacting progress May supervise resources for design/development activities and follow up on efforts Collaborate with internal (architect, analyst, DBA and others) and/or external stakeholders where needed to solve problems Train, coach and provide guidance to others in area(s) of specialization; foster teamwork and innovation by involving others in problem solving and creative thinking Participate in the evaluation and identification of new technologies Ensure 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. Position Requirements 7+ years of hands-on experience as a BI / ETL Developer in a data warehouse environment, including ETL design, development, testing, and deployment 5+ years of data warehouse modeling experience in large-scale enterprise data warehouse environment Experience and knowledge of Snowflake, Matillion , Azure platform, Power BI Gateway Oracle PL/SQL, SQL Server (including SSIS, SSAS, SSRS) are a plus Solid understanding of database engineering and design, including relational, de-normalized, and data lakes Ability to work independently or in a group under a limited degree of supervision Experience working with JIRA, Git Team player, with an ability to motivate and be a positive role model for others Ability to work efficiently under pressure and manage multiple assignments Strong written and oral communication skills in English and French The incumbent of this position will provide daily support to internal and/or external clients outside Quebec and/or in the United States. Therefore, he/she must be proficient in spoken and written English. Please note that the number of positions requiring English language skills has been limited where possible. We are proud to offer a competitive compensation package at McKesson as part of our Total Rewards. This is determined by several factors, including performance, experience and skills, equity, regular job market evaluations, and geographical markets. In addition to base pay, other compensation, such as an annual bonus or long-term incentive opportunities may be offered. For more information regarding benefits at McKesson, please click here. Our Base Pay Range for this position$82,400 - $137,400McKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health, happiness, and well-being of you and those we serve – we care.What you do at McKesson matters. We foster a culture where you can grow, make an impact, and are empowered to bring new ideas. Together, we thrive as we shape the future of health for patients, our communities, and our people. If you want to be part of tomorrow’s health today, we want to hear from you. Responsabilités spécifiques : Concevoir , développer et maintenir des solutions de plateforme de données Effectuer le cycle de développement complet , comprenant : Analyser / évaluer les exigences commerciales en matière de données, Analyser les données, créer des modèles de données, des mappages de données, Développer des bases de données et des ETL à partir de zéro , Implémenter des pipelines de données, planifier et orchestrer des tâches , automatiser des tâches , Produire des documents de conception selon une méthodologie ou un processus prédéterminé , Concevoir , coder et déboguer selon des normes prédéterminées ; effectuer des examens de code si nécessaire , Effectuer des tests unitaires , des tests dintégration et de performance Promouvoir vers différents environnements Être proactif et fournir un état davancement des efforts accomplis , des estimations des efforts restants et des problèmes impactant la progression Peut superviser des ressources pour les activités de conception/ développement et faire le suivi des efforts Collaborer avec des parties prenantes internes ( architecte , analyste , DBA, etc.) et/ ou externes si nécessaire pour résoudre des problèmes Former, encadrer et fournir des conseils à dautres personnes dans leur (s) domaine (s) de spécialisation ; favoriser le travail déquipe et linnovation en impliquant les autres dans la résolution de problèmes et la réflexion créative Participer à lévaluation et à lidentification de nouvelles technologies Veiller à ce que les engagements envers les clients internes et externes soient respectés de manière opportune et rentable ; solliciter les commentaires des clients pour identifier des opportunités damélioration des produits et/ ou services. Exigences du poste: Diplôme universitaire en informatique / génie informatique Plus de 7 ans dexpérience pratique en tant que développeur BI / ETL dans un environnement de data warehouse, y compris la conception, le développement , les tests et le déploiement des ETL Plus de 5 ans dexpérience en modélisation de data warehouse dans un environnement de data warehouse dentreprise à grande échelle Expérience et connaissance de Snowflake, Matillion , de la plateforme Azure, du Power BI Gateway Oracle PL/SQL, SQL Server (y compris SSIS, SSAS, SSRS) sont un plus Compréhension solide de lingénierie et de la conception de bases de données, y compris les bases de données relationnelles , dénormalisées et les data lakes Capacité à travailler de manière indépendante ou en groupe avec un degré limité de supervision Expérience de travail avec JIRA, Git Expérience de la livraison Agile Esprit déquipe , avec la capacité de motiver et dêtre un modèle positif pour les autres Capacité à travailler efficacement sous pression et à gérer plusieurs tâches Solides compétences en communication écrite et orale en anglais et en français . Le.la titulaire de ce poste aura à soutenir de façon quotidienne des clients internes et/ ou externes à l’extérieur du Québec et/ ou aux États-Unis. Par conséquent , ce poste requiert une maîtrise de l’anglais à l’écrit et à l’oral . Veuillez noter que le nombre de postes dont les tâches requièrent une connaissance de la langue anglaise a été restreint dans la mesure du possible. ------------------------------------------------------------------------------------------------------------------------- Specific Responsibilities Design, develop and maintain Data platform solutions Perform full development lifecycle, including: Analyze / evaluate business data requirements, Analyze data, create data models, data mappings, Develops databases and ETLs from scratch, Implements data pipelines, schedule and orchestrate jobs, automate tasks, Produce design documents according pre-determined methodology or process, Design, code and debug according to pre-determined standards; code review as required , Perform unit testing, integration and performance testing Promotions to different environments Be proactive and provide status of effort accomplished , estimates of remaining effort, and issues impacting progress May supervise resources for design/development activities and follow up on efforts Collaborate with internal (architect, analyst, DBA and others) and/or external stakeholders where needed to solve problems Train, coach and provide guidance to others in area(s) of specialization; foster teamwork and innovation by involving others in problem solving and creative thinking Participate in the evaluation and identification of new technologies Ensure 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. Position Requirements Bachelor’s degree in Computer Science/Computer Engineering 7+ years of hands-on experience as a BI / ETL Developer in a data warehouse environment, including ETL design, development, testing, and deployment 5+ years of data warehouse modeling experience in large-scale enterprise data warehouse environment Experience and knowledge of Snowflake, Matillion , Azure platform, Power BI Gateway Oracle PL/SQL, SQL Server (including SSIS, SSAS, SSRS) are a plus Solid understanding of database engineering and design, including relational, de-normalized, and data lakes Ability to work independently or in a group under a limited degree of supervision Experience working with JIRA, Git Agile delivery experience Team player, with an ability to motivate and be a positive role model for others Ability to work efficiently under pressure and manage multiple assignments Strong written and oral communication skills in English and French The incumbent of this position will provide daily support to internal and/or external clients outside Quebec and/or in the United States. Therefore, he/she must be proficient in spoken and written English. Please note that the number of positions requiring English language skills has been limited where possible. We are proud to offer a competitive compensation package at McKesson as part of our Total Rewards. This is determined by several factors, including performance, experience and skills, equity, regular job market evaluations, and geographical markets. In addition to base pay, other compensation, such as an annual bonus or long-term incentive opportunities may be offered. For more information regarding benefits at McKesson, please click here. Our Base Pay Range for this position$82,400 - $137,400 McKesson is an Equal Opportunity Employer McKesson provides equal employment opportunities to applicants and employees and is committed to a diverse and inclusive environment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age or genetic information. For additional information on McKesson’s full Equal Employment Opportunity policies, visit our Equal Employment Opportunity page. Join us at McKesson! McKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health, happiness, and well-being of you and those we serve – we care. What you do at McKesson matters. We foster a culture where you can grow, make an impact, and are empowered to bring new ideas. Together, we thrive as we shape the future of health for patients, our communities, and our people. If you want to be part of tomorrow’s health today, we want to hear from you.