Clinical Data Architect 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 tomorrows 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 McKessons 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 & 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 ResponsibilitiesLEAD TECHNICAL DATA EFFORTSDesign develop and maintain robust data architectures to support clinical data integration products and analyses.Collaborate with clinical product and IT teams to understand data requirements and translate them into effective data models and solutions.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.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.Establish monitoring solutions to prevent outages to promote timely and accurate data collection ingestion processing and analysis.BUILD CAPACITY & LEAD DATA TEAMDesign architecture for infrastructure changes for highly performant scalable maintainable data pipelines; oversee implementation; test and characterize performance before moving to production.Lead a team of integration specialists developers and database administrators to ensure timely and accurate completion of data integration projects.Write and optimize complex SQL queries using PostgreSQL to extract transform and load (ETL) clinical data; mentor team to increase team capacity and skills.Provide technical leadership and mentorship to technical junior colleagues.Conduct code reviews to promote readability reuse performance and security; author code as appropriate and needed.ENSURE DATA QUALITY & PERFORMANCECreate manage and monitor data quality metrics as part of the Clinical Data Quality Program.Use statistics and tools to evaluate data present to leadership and stakeholders and identify problems proactively.Ensure the quality and integrity of clinical data with a particular emphasis on ophthalmology / retina data.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.Develop and maintain documentation for data architecture data flows and data models.Ensure data products are produced on time with high quality accuracy and integritySUPPORT USERS OF THE DATASupport 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.Promote and evolve data transparencyUse 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.Ensure database performance such that that data are accessible and available on-time to analysts products support personnel and AI needs.Help orchestrate and prepare datasets for future products or needs such as AI data models visualizations or other needsOTHERServe as data owner and data steward for HIPAA protected health information (PHI) and other regulatory requirements including corporate security and compliance.Stay current with industry trends and best practices in data engineering and data technologies.Other duties as requested / required.Minimum RequirementDegree or equivalent and typically requires 10 years of relevant experience. Less years required if has relevant Masters or Doctorate qualifications.EducationBachelors 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 SkillsClinical background and/or demonstrated work experience with healthcare data and workflows; experience with ophthalmology preferred.Collaborative problem-solving management style where team members are mentoredMinimum of 5 years of experience in data architecture data engineering or a similar role.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.Minimum of 3 years of experience coding in SQL and Python; must be able to work in Jupyter Notebooks3 years work experience with scripting in shell environments (Linux PowerShell AWS CLI).Minimum of 3 yrs expertise with PostgreSQL including partitioning indexing (full and partial) query optimization parallelization connection pools clustering etc.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. 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.Excellent attention to detail; strong analytical and problem-solving skillsExcellent communication and collaboration skills; demonstrated work experience collaborating with multiple stakeholders and mentoring team members.Preferred SkillsKnowledge of additional database systems such as SQL Server Oracle and /or Snowflake preferred.Expertise in bidirectional data transactions via APIs using Python AWS lambda ECS etc.Work experience with data visualization and prototyping tools (e.g. Seaborn Plotly libraries in python Tableau etc.).Knowledge of statistics: fundamental concepts to summarize analyze and visualize data tests of statistical significance regression etc.Experience with additional cloud platforms a plus (e.g. Azure GCP etc.)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 pleaseclick here.Our Base Pay Range for this position$141000 - $235000McKesson is an Equal Opportunity EmployerMcKesson 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 McKessons full Equal Employment Opportunity policies visit our Equal Employment Opportunity page.Join us at McKesson! Key Skills Fund Management,Drafting,End User Support,Infrastructure,Airlines,Catia Employment Type : Full-Time Experience: years Vacancy: 1 Monthly Salary Salary: 141000 - 235000