McKesson is hiring a Clinical Data Architect

McKesson is hiring a Clinical Data Architect to design, implement, and maintain the data architecture for our industry-leading ophthalmology products, clinical operations, and research. This role leads technical data efforts, builds team capacity, ensures data quality, and supports users of our clinical data systems.

What You'll Do

• Design, 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.
• Lead data integration efforts through the entire lifecycle for multiple electronic medical record (EMR) and practice management (PM) systems.
• Collaborate on designing, evolving, and implementing data architecture, infrastructure, and data collection efforts.
• Establish monitoring solutions to prevent outages and promote timely, accurate data collection, ingestion, processing, and analysis.
• Design architecture for highly performant, scalable, and maintainable data pipelines; oversee implementation and performance testing.
• Lead a team of integration specialists, developers, and database administrators to ensure timely completion of data projects.
• Write and optimize complex SQL queries using PostgreSQL for ETL processes; mentor the team to increase capacity and skills.
• Provide technical leadership and mentorship to junior colleagues.
• Conduct code reviews to promote readability, reuse, performance, and security; author code as needed.
• Create, 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 identify problems proactively.
• Ensure the quality and integrity of clinical data, with an emphasis on ophthalmology/retina data.
• Ensure proper data quality is maintained across all clinical systems and that products receive high-quality data.
• Develop and maintain documentation for data architecture, data flows, and data models.
• Ensure data products are delivered on time with high quality, accuracy, and integrity.
• Support internal and external data users by troubleshooting issues, implementing resolutions, and promoting data transparency, leveraging AI tools as appropriate.
• Use service tickets for all work and ensure proper documentation; serve as the final approval for moves to production.
• Ensure database performance so data is accessible and available on-time to analysts, products, support personnel, and AI needs.
• Help orchestrate and prepare datasets for future needs, such as AI, data models, or visualizations.
• Serve as data owner and steward for HIPAA-protected health information (PHI) and other regulatory requirements.
• Stay current with industry trends and best practices in data engineering.

What We're Looking For

• Degree or equivalent with 10+ years of relevant experience. Fewer years required with relevant Master’s or Doctorate.
• Bachelor's or Master's degree in Computer Science, Information Technology, Health Informatics, or related field, or a minimum of 5 years IT work experience in data.
• Clinical background and/or demonstrated work experience with healthcare data and workflows; experience with ophthalmology preferred.
• Collaborative, problem-solving management style focused on mentoring team members.
• Minimum of 5 years in data architecture, data engineering, or a similar role.
• Minimum of 5 years work experience with healthcare terminologies and standards (e.g., ICD10, CPT, HL7, FHIR); experience with GEMS crosswalk of ICD9 a plus.
• Minimum of 3 years coding in SQL and Python; ability to work in Jupyter Notebooks.
• 3 years work experience with scripting in shell environments (Linux, PowerShell, AWS CLI).
• Minimum of 3 years expertise with PostgreSQL, including partitioning, indexing, query optimization, parallelization, and clustering.
• Minimum of 3 years work experience with data modeling, ETL processes, and data warehousing using the 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.
• Excellent attention to detail and strong analytical and problem-solving skills.
• Excellent communication and collaboration skills; experience collaborating with multiple stakeholders and mentoring team members.
• 15% travel required, schedulable in advance.
• Candidates must be authorized to work in USA. Sponsorship is not available.

Nice to Have

• Knowledge of additional database systems such as SQL Server, Oracle, and/or Snowflake.
• 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, Tableau).
• Knowledge of statistics: fundamental concepts, tests of statistical significance, regression, etc.
• Experience with additional cloud platforms (e.g., Azure, GCP).

Technical Stack

• PostgreSQL, Python, SQL
• AWS (S3, Lambda, ECS, CloudWatch, RDS)
• Linux, PowerShell, AWS CLI
• Jupyter Notebooks, Data Build Tool (DBT)
• HL7, FHIR, ICD10, CPT

Team & Environment

You will lead a team of integration specialists, developers, and database administrators to ensure the timely and accurate completion of data integration projects.

Benefits & Compensation

• Compensation: $141,000 - $235,000

McKesson provides equal employment opportunities to all 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.