Clinical Data Architect

Job not on LinkedIn

3 days ago

🌽 Illinois – Remote

Although this job is listed in Illinois, this company may be open to hiring remote in other states.

🤠 Texas – Remote

Although this job is listed in Texas, this company may be open to hiring remote in other states.

💵 $141k - $235k / year

⏰ Full Time

🟠 Senior

🔴 Lead

🚰 Data Engineer

🦅 H1B Visa Sponsor

Apply Now

Receive Emails with Similar Jobs

McKesson

WebsiteLinkedInAll Job Openings

Healthcare Insurance • Pharmaceuticals • Biotechnology

McKesson is a diversified healthcare leader specializing in pharmaceutical distribution, medical supplies, and healthcare services. Their solutions facilitate patients' access to life-changing therapies, support efficient operations for pharmacies, health systems, and clinics, and address critical issues such as drug shortages through a resilient supply chain. McKesson provides comprehensive services such as pharmacy management software, consulting, and technology solutions for specialty practices, focusing on improving health outcomes and advancing the pharmaceutical industry. They work closely with biopharma companies to enhance medication access, adherence, and commercialization while supporting oncology and biopharma practices through data-driven insights and real-world evidence.

10,000+ employees

Founded 1833

⚕️ Healthcare Insurance

💊 Pharmaceuticals

🧬 Biotechnology

📋 Description

• 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 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 • Design 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 • 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 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 • 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 • 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 • 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 needs • Serve 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.

🎯 Requirements

• Degree or equivalent and typically requires 10+ years of relevant experience • Bachelor’s or Master’s degree in Computer Science, Information Technology, Health Informatics, or a related field or 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 where team members are mentored • Minimum 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 Notebooks • 3 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 skills • Excellent communication and collaboration skills; demonstrated work experience collaborating with multiple stakeholders and mentoring team members.

🏖️ Benefits

• Competitive compensation package • Annual bonus or long-term incentive opportunities