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.McKesson is a leading healthcare organization dedicated to improving patient outcomes through innovative solutions. We are seeking a highly skilled Clinical Data Architect to join our team and play a pivotal role in shaping our data infrastructure and our analytics capabilities. The Clinical Data Architect is responsible for designing, implementing, and maintaining the data and data architecture that supports McKesson’s industry-leading products, clinical operations and research initiatives for Ophthalmology. The ideal candidate will have a strong technical background in cloud-based data pipelines, expertise in data &amp; architecture for clinical data management, extensive experience using PostgreSQL, and a passion for leveraging data to drive healthcare improvements and innovation. The ideal individual will also have a drive for performance improvement and innovation using both traditional and non-traditional methods.  The ideal candidate is comfortable at the command line, but can also lead a technical team to scale and grow.Key Responsibilities LEAD TECHNICAL DATA EFFORTS<ul><li>Design, develop, and maintain robust data architectures to support clinical data integration,  products, and analyses.</li><li>Collaborate with clinical, product and IT teams to understand data requirements and translate them into effective data models and solutions.</li><li>Lead data integration efforts from start to finish, through the entire data life cycle (i.e. prototype to production, and data  ingestion to product usage and archival) for multiple electronic medical record (EMR) and practice management (PM) systems.</li><li>Collaborate with the larger team to design, evolve and implement data architecture(s), infrastructure, data collection efforts and improvements to existing scale, processes and approaches.</li><li>Establish monitoring solutions to prevent outages, to promote timely and accurate data collection, ingestion, processing and analysis.</li></ul>BUILD CAPACITY &amp; LEAD DATA TEAM<ul><li>Design architecture for infrastructure changes for highly performant, scalable, maintainable data pipelines; oversee implementation; test and characterize performance before moving to production.</li><li>Lead a team of  integration specialists, developers and database administrators to ensure timely and accurate completion of data integration projects.</li><li>Write and optimize complex SQL queries using PostgreSQL to extract, transform, and load (ETL) clinical data; mentor team to increase team capacity and skills.</li><li>Provide technical leadership and mentorship to technical junior colleagues.</li><li>Conduct code reviews to promote readability, reuse, performance and security; author code as appropriate and needed.</li></ul>ENSURE DATA QUALITY &amp; PERFORMANCE<ul><li>Create, manage, and monitor data quality metrics as part of the Clinical Data Quality Program.</li><li>Use statistics and tools to evaluate data, present to leadership and stakeholders, and identify problems proactively.</li><li>Ensure the quality and integrity of clinical data, with a particular emphasis on ophthalmology / retina data.</li><li>Work to ensure proper data quality is maintained across all clinical data systems and that supporting products get the high quality data they need, when they need it.</li><li>Develop and maintain documentation for data architecture, data flows, and data models.</li><li>Ensure data products are produced on time with high quality, accuracy and integrity </li></ul>SUPPORT USERS OF THE DATA<ul><li>Support the people who use the data, both internally and externally, via tracing and  troubleshooting data issues, implementing resolutions, and promoting data transparency, leveraging AI tools as appropriate.</li><li>Promote and evolve data transparency</li><li>Use service tickets for all work, and ensure work is properly documented; verify and approve the work of the team as needed.  Serve as the final approval of moves to production.</li><li>Ensure database performance such that that data are accessible and available on-time to analysts, products, support personnel, and AI needs.</li><li>Help orchestrate and prepare datasets for future products or needs, such as AI, data models, visualizations, or other needs</li></ul>OTHER<ul><li>Serve as data owner and data steward for HIPAA protected health information (PHI), and other regulatory requirements, including corporate security and compliance.</li><li>Stay current with industry trends and best practices in data engineering and data technologies.</li><li>Other duties as requested / required.</li></ul>Minimum RequirementDegree or equivalent and typically requires 10+ years of relevant experience. Less years required if has relevant Master’s or Doctorate qualifications.Education Bachelors or Masters degree in Computer Science, Information Technology, Health Informatics, or a related field, or minimum of 5 years IT work experience in data.Critical Skills<ul><li>Clinical background and/or demonstrated work experience with healthcare data and workflows; experience with ophthalmology preferred.</li><li>Collaborative, problem-solving management style where team members are mentored </li><li>Minimum of 5 years of experience in data architecture, data engineering, or a similar role.</li><li>Minimum of 5 years work experience with healthcare terminologies, standards, billing/ claims (e.g., ICD10, CPT,  HL7, FHIR); experience with GEMS crosswalk of ICD9 a plus.</li><li>Minimum of 3 years of experience coding in SQL and Python; must be able to work in Jupyter Notebooks</li><li>3 years work experience with scripting in shell environments (Linux, PowerShell, AWS CLI).</li><li>Minimum of 3 yrs expertise with PostgreSQL, including partitioning, indexing (full and partial), query optimization, parallelization, connection pools, clustering, etc.</li><li>Minimum of 3 yrs work experience with data modeling, ETL processes, and data warehousing using AWS cloud platform. Must know S3, Lambda, ECS, CloudWatch and RDS well.  </li><li>2 years work experience with Data Build Tool (DBT) , and using direct DB access, APIs, file ingestion, HL7 v. (2.x and 3), FHIR, etc. to access and manage data.</li><li>Excellent attention to detail; strong analytical and problem-solving skills</li><li>Excellent communication and collaboration skills; demonstrated work experience collaborating with multiple stakeholders and mentoring team members.</li></ul>Preferred Skills<ul><li>Knowledge of additional database systems such as SQL Server, Oracle, and /or Snowflake preferred.</li><li>Expertise in bidirectional data transactions via APIs using Python, AWS lambda, ECS, etc.</li><li>Work experience with data visualization and prototyping  tools (e.g., Seaborn, Plotly libraries in python,  Tableau, etc.).</li><li>Knowledge of statistics: fundamental concepts to summarize, analyze, and visualize data, tests of statistical significance, regression, etc.</li><li>Experience with additional cloud platforms a plus (e.g. Azure, GCP, etc.)</li></ul>Travel15% travel required, can be scheduled in advance.Candidates must be authorized to work in USA. Sponsorship is not available for this role.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. The pay range shown below is aligned with McKessons pay philosophy, and pay will always be compliant with any applicable regulations. 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 <a href="https://careers.mckesson.com/en/benefits" target="_blank">click here.</a>Our Base Pay Range for this position$141,000 - $235,000McKesson 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 <a target="_blank" href="https://www.mckesson.com/about-mckesson/eeo-at-mckesson/">Equal Employment Opportunity</a> page. Join us at McKesson!