About McKesson Compile

Established in 1833, McKesson is a Fortune 10 global leader in healthcare supply chain management solutions, retail pharmacy, healthcare technology, community oncology, and specialty care. We partner with life sciences companies, manufacturers, providers, pharmacies, governments, and other healthcare organizations to help provide the right medicines, medical products, and healthcare services to the right patients at the right time, safely and cost effectively. Our enterprise consists of the following businesses:

Pharmaceutical Solutions and Services (PSaS)Medical Surgical Solutions (MMS)CoverMyMeds (CMM)McKesson International (Europe and Canada)

McKesson draws upon its rich and nearly 200-year history to serve as the central nervous system of healthcare, touching nearly 1/3 of all pharmaceuticals used each day in North America, leading as the 4th largest pharmacy chain, and serving as the #1 distributor in Oncology and key specialties. Most recently, McKesson has been awarded the honor and public health responsibility of serving as the centralized distributor of the COVID 19 vaccine(s) and all associated ancillary products and supplies.

McKesson Compile’s data is a comprehensive, full linked system of record for the US Healthcare market, with intelligence on 2M+ healthcare professionals (HCPs) and over 800K facilities. Compile’s data includes high capture medical and pharmacy claims, closed capture Medicare claims (100%), along with best-in-class provider affiliations and customer master. The linked data enables commercial teams to move beyond the traditional approaches that only rely on claims volumes. Our innovations include - Best-in-class provider affiliations - Fully linked data across claims, affiliations, customer master and more - Cleansed, normalized and analytics-ready patient-level data.

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.

What sets McKesson apart as an exceptional place is our people. Our employees understand that together, unified by our global i²care values, we fulfil our mission and uphold our reputation as a trusted partner to our customers and their patients. Our i²care values are foundational to all that we do, and who we are as a company.

Integrity – We do What’s right

Inclusion –We embrace and respect each other as we are

Customer First – We succeed when our customers succeed

Accountability – We take personal responsibility for our actions and our work

Respect – We treat people with dignity and respect

Excellence – We insist upon quality

As a Software Development Intern with a focus on Data Engineering and Data Engineering Platforms, your role and responsibilities might include the following:

Roles:

1.Data Engineering Support: - Assist in the design, development, and maintenance of scalable data pipelines. - Help in the extraction, transformation, and loading (ETL) of data from various data sources into data warehouses or data lakes.

2. Data Platform Assistance:  - Support the development and maintenance of data platforms that facilitate data storage, processing, and analytics. - Assist in the integration of data platforms with other enterprise systems.

3. Collaboration: - Work closely with senior data engineers, data scientists, and other cross-functional teams to understand data requirements and deliver solutions. - Participate in team meetings and contribute to project planning and progress updates.

4. Learning and Development: - Continuously improve your understanding of data engineering concepts, tools, and technologies. - Take advantage of mentorship opportunities and training programs offered by the organization.
 

Responsibilities:

1. Data Pipeline Development: - Write code to build and optimize data pipelines. - Ensure data integrity and consistency across various stages of the pipeline.

2. Data Quality and Testing: - Implement data validation and quality checks. - Conduct testing to ensure data pipelines are robust and reliable.

3. Data Integration: - Assist in integrating diverse data sources, including APIs, databases, and flat files. - Help in the development of data ingestion processes.

4. Documentation: - Document data workflows, pipeline structures, and data models. - Create user guides and technical documentation for future reference.

5. Performance Tuning: - Monitor and optimize the performance of data pipelines and platforms. - Assist in troubleshooting and resolving performance issues.

6. Tool and Technology Utilization: - Utilize data engineering tools and technologies such as SQL, Python, Apache Spark, Hadoop, etc. - Gain hands-on experience with cloud platforms like AWS, Azure, or Google Cloud Platform.

7. Data Analysis and Reporting: - Support data analysis tasks and generate reports as needed. - Use data visualization tools to present insights and findings.

 8. Compliance and Security: - Ensure compliance with data governance and security policies. - Assist in implementing data protection measures and access controls.

Skills to Develop:

1. Programming Languages: - Proficiency in languages such as Python, SQL, and possibly Java or Scala.

2. Data Tools: - Familiarity with ETL tools, data warehouses (e.g., Snowflake, Redshift), and big data technologies (e.g., Hadoop, Spark).

3. Cloud Platforms: - Experience with cloud data services (e.g., AWS S3, Google BigQuery, Azure Data Lake).

 4. Database Management: - Understanding of relational databases (e.g., MySQL, PostgreSQL) and NoSQL databases (e.g., MongoDB, Cassandra).

 5. Data Modeling: - Knowledge of data modeling techniques and best practices.

6. Version Control: - Proficiency with version control systems like Git.

 7. Soft Skills: - Strong problem-solving skills, attention to detail, and the ability to work in a team-oriented environment.

Conclusion: Your role as a Software Development Intern focusing on Data Engineering and Data Engineering Platforms will involve a mix of hands-on technical tasks, collaboration with experienced professionals, and continuous learning. This experience will help you build a solid foundation in data engineering principles and practices, preparing you for a future career in the field.