Sr Associate Data Engineer (ETL / Databricks)

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.

Rx Savings Solutions, part of McKessons CoverMyMeds organization, offers an innovative, patented software system that educates and empowers consumers to make the best healthcare choices at the lowest cost. Founded and operated by a team of pharmacists and software engineers, we support a collaborative, cost-saving solution for purchasing prescription drugs.

We currently have an opportunity for aSr AssociateData Engineer (ETL / Databricks)to join our growing Business Operations Support data engineering team!This role will assist in planning, designing, troubleshooting and documenting technical requirements for data flows between disparate operational systems and our data warehouse. Our ideal candidate will have Databricks experience, ETL tool experience (i.e. Talend, Informatica, SSIS or DataStage), experience with SQL, and general-purpose programming languages such as Python or Java for dataengineering/ingestionwork. This individual will assist in end-to-end development of the ETL processes, data analytics, review business requirement documents and execute object and data models.

* Our ideal candidate will reside in the Columbus, OH area, with the work primarily being remote with occasional in-office work.We may consider a well-qualified, fully remote candidate.

*At this time, we are not able to offer sponsorship for employment visas. This includes individuals currently on F-1 OPT, STEM OPT, or any other visa status that would require future sponsorship. Candidates must be authorized to work in the United States on a permanent basis without the need for current or future sponsorship.

Responsibilities:

Build data pipelines to ingest and automate files provided by customers using ETL tool

Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using primarily ETL tools

Explore and learn the latest AWS technologies to provide new capabilities and increase efficiency

Investigate and resolve data related issues and provide support and troubleshooting expertise

Collaborating across teams to understand business needs and propose innovative solutions

Requirements:

Bachelors degree in Computer Science or related technical degree, or equivalent experience, and 2+ years of relative experience

2+ years of experience with Databricks and building data pipelines to ingest and automate files provided by customers

2+ years of experience with SQL queries, including various SQL commands

Experience with Python

Knowledge of Structured and Unstructured data

Possess understanding of BI concepts and be familiar with relational or multi-dimensional modeling concepts

Understanding of RDBMS best practices and performance tuning techniques

Experience with cloud technologies such as AWS services such as S3, CloudWatch, EC2, and passion for a role working in a cloud data warehouse

It would be nice if you had...

Experience with Agile and Scrum methodologies

Knowledge of Java or JavaScript

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 $80,600 - $134,400

McKesson has become aware of online recruiting-related scams in which individuals who are not affiliated with or authorized by McKesson are using McKessons (or affiliated entities, like CoverMyMeds or RxCrossroads) name in fraudulent emails, job postings or social media messages. In light of these scams, please bear the following in mind:

McKesson Talent Advisors will never solicit money or credit card information in connection with a McKesson job application.

McKesson Talent Advisors do not communicate with candidates via online chatrooms or using email accounts such as Gmail or Hotmail. Note that McKesson does rely on a virtual assistant (Gia) for certain recruiting-related communications with candidates.

McKesson job postings are posted on our career site: careers.mckesson.com.

McKesson is an Equal Opportunity Employer

McKesson provides equal employment opportunities to applicants and employees, without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age, genetic information, or any other legally protected category. For additional information on McKessons full Equal Employment Opportunity policies, visit our Equal Employment Opportunity page.

Join us at McKesson! PDN-a0baced5-bc94-4d9a-a8ca-c8a2a058480d