Lead Data Architect - Remote US

McKesson’s Corporate; Town of Texas (WI); Hybrid; USD 140,000 - 210,000; Full time

Job summary

Sarah Cannon Research Institute (SCRI), a McKesson subsidiary, is seeking a Lead Data Architect to drive our data strategy across products and clinical research. You will design scalable data infrastructures to support oncology trials and healthcare delivery, aligning data governance with HIPAA and business goals.

The role is remote based in the US with collaboration across teams, data engineers, scientists, and IT.

Qualifications

• Minimum 7 years in enterprise data architecture including data requirements collection, data architecture analysis, evaluation, documentation, data modeling, design, development, model validation, and data integration in modern data platforms (e.g., Azure, Databricks, Snowflake).
• Bachelor’s Degree in Computer Science, Information Systems, Engineering, or equivalent experience.

Responsibilities

• Design, build, and manage the organization's data infrastructure.
• Create the blueprint for how data is collected, stored, processed, and used, ensuring it's accessible, reliable, and secure.
• Design the structure and systems that allow the organization to effectively manage and use its data, ensuring it is a valuable asset for decision-making and business operations.
• Create and maintain documentation for database architecture, procedures, and standards.
• Data Strategy: Develop and implement a comprehensive data strategy aligned with business goals.
• Data Modeling: Design conceptual, logical, and physical data models that represent the structure and relationships of data within the organization.
• Data Architecture: Create and maintain the overall data architecture framework, including databases, data warehouses, data lakes, and other data systems.
• Data Mapping: Develop and implement data mapping rules to transform data from source systems to target systems, ensuring data accuracy and consistency.
• Data Integration: Design and implement processes for integrating data from various sources, ensuring data consistency and accuracy.
• Data Governance: Establish data governance policies and procedures to ensure data quality, security, and HIPAA compliance across all data systems and platforms.
• Technology Evaluation: Evaluate and recommend data management technologies and tools to support the organization's data needs.
• Problem Solving: Identify and resolve data-related issues, ensuring data integrity and reliability.
• AI Solutions: Design and implement architectures that seamlessly integrate AI models and algorithms with existing data infrastructures.
• Collaboration: Work closely with stakeholders, including business analysts, data scientists, and IT professionals, to understand data requirements and translate them into technical solutions.
• Influence projects to make decisions related to data strategies including data quality, data architecture and data management best practices.

Skills

Data architecture

Data modeling

SQL

Cloud data platforms

ETL/ELT

Data governance

AI integration

Stakeholder collaboration

Education

Bachelor’s Degree in Computer Science, Information Systems, Engineering, or equivalent

Tools

Azure Databricks

Snowflake

Oracle

PostgreSQL

SQL Server

Terraform

Job description

It’s More Than a Career, It’s a Mission. Our people are the foundation of our success. By joining our growing team at Sarah Cannon Research Institute (SCRI), a subsidiary of McKesson, you will have the opportunity to become part of one of the largest community-based cancer programs to advance oncology treatments and improve outcomes for cancer patients across the globe.

We look for mission-driven candidates who have a desire to advance the fight against cancer and make a difference in the lives of patients diagnosed with cancer every day.

Our Mission People who live with cancer – those who work to prevent it, fight it, and survive it – are at the heart of every decision we make. Bringing the most innovative medical minds together with the most passionate caregivers in their communities, we are transforming care and personalizing treatment. Through clinical excellence and cutting-edge research, SCRI is redefining cancer care around the world.

As the Lead Data Architect for Sarah Cannon Research Institute, you will play a pivotal role in driving our database strategy across all products. This role demands a profound expertise in data architecture to analyze, design, and implement complex systems ensuring robust, scalable solutions that support our business goals. Your expertise will ensure that our data infrastructure is robust, scalable, and aligned with our mission, enabling us to harness the power of data to improve healthcare delivery and support our ongoing commitment to clinical research and our patients.

This position is remote based in the US; relocation assistance and visa sponsorship are not available.

Job Responsibilities

• Responsible for designing, building, and managing the organization's data infrastructure.
• Create the blueprint for how data is collected, stored, processed, and used, ensuring it's accessible, reliable, and secure.
• Design the structure and systems that allow the organization to effectively manage and use its data, ensuring it is a valuable asset for decision-making and business operations.
• Create and maintain documentation for database architecture, procedures, and standards.

Key Responsibilities

• Data Strategy: Develop and implement a comprehensive data strategy aligned with business goals. This involves understanding the organization's data needs and creating a roadmap for effective data management.
• Data Modeling: Design conceptual, logical, and physical data models that represent the structure and relationships of data within the organization.
• Data Architecture: Create and maintain the overall data architecture framework, including databases, data warehouses, data lakes, and other data systems.
• Data Mapping: Develop and implement data mapping rules to transform data from source systems to target systems, ensuring data accuracy and consistency.
• Data Integration: Design and implement processes for integrating data from various sources, ensuring data consistency and accuracy.
• Data Governance: Establish data governance policies and procedures to ensure data quality, security, and HIPPA compliance across all data systems and platforms.
• Technology Evaluation: Evaluate and recommend data management technologies and tools to support the organization's data needs.
• Problem Solving: Identify and resolve data-related issues, ensuring data integrity and reliability.
• AI Solutions: Design and implement architectures that seamlessly integrate AI models and algorithms with existing data infrastructures, including cloud-native and legacy systems.
• Collaboration: Work closely with stakeholders, including business analysts, data scientists, and IT professionals, to understand data requirements and translate them into technical solutions.
• Influence projects to make decisions related to data strategies including data quality, data architecture and data management best practices.

Minimum Job Qualifications

• Minimum of 7 years of experience in enterprise data architecture, including data requirements collection, data architecture analysis, evaluation, documentation, data modeling, design, development, model validation, and data integration in modern data platforms (e.g., Azure, Databricks, Snowflake).
• Bachelor’s Degree in Computer Science, Information Systems, Engineering, or equivalent experience.

Critical Skills

• Minimum 10 years of experience in database engineering/management required.
• Knowledge of software development methodologies (e.g., Agile, DevOps, SDLC, CI/CD, GitHub).
• 7+ years' experience working with data sources (e.g. APIs) and databases such as Oracle, PostgreSQL, SQL Server, and cloud databases.
• Knowledge of cloud technologies like Azure (Data Factory, Databricks), AWS.
• Strong knowledge of industry best practices — code coverage.
• Strong knowledge of database concepts, data modeling techniques, system performance analysis and tuning, and data warehousing concepts.
• Knowledge of various operating systems such as Linux, Unix, and Windows.
• Ability to write complex queries and perform advanced database operations using SQL.

Preferred Skills

• Expertise in modern cloud-native database solutions.
• Experience with database migration tools and strategies, including handling zero-downtime migrations and data synchronization.
• Proficiency in infrastructure-as-code and automation tools (Terraform) for database deployment and management.
• Ability to design scalable database architectures that support microservices and distributed systems.
• Experience with various database patterns (CQRS, event sourcing, sharding strategies).
• Understanding of data modeling for both relational and NoSQL databases.

About Sarah Cannon Research Institute

Sarah Cannon Research Institute (SCRI) is one of the world’s leading oncology research organizations conducting community-based clinical trials. Focused on advancing therapies for patients over the last three decades, SCRI is a leader in drug development. In 2022, SCRI formed a joint venture with former US Oncology Research to expand clinical trial access across the country. It has conducted more than 850 first-in-human clinical trials since its inception and contributed to pivotal research that has led to the majority of new cancer therapies approved by the FDA in the past decade. SCRI’s research network brings together more than 1,300 physicians who are enrolling patients into clinical trials at more than 200 locations in 20+ states across the U.S.

We care about the well-being of the patients and communities we serve, and that starts with caring for our people. That’s why we have a Total Rewards package that includes comprehensive benefits to support physical, mental, and financial well-being.

As part of Total Rewards, we are proud to offer a competitive compensation package. 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.

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

We deliver careers with purpose and potential. Our focus on better health starts with creating an inclusive environment with strong values where you can build a fulfilling career. You can count on us to provide you with resources and opportunities to grow and be your best, while contributing to our pursuit of improving lives.

Every day, McKesson’s employees deliver products to healthcare providers that make a difference in the care and life of a patient.