Business Systems Analyst

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 tomorrow's health today, we want to hear from you.

Rx Savings Solutions (RxSS), part of McKesson's CoverMyMeds business segment, is at the forefront of digital healthcare advancement. We are committed to redefining how consumers interact with health care products by providing accessible and affordable solutions. Founded and operated by a team of pharmacists and software engineers, our software-as-a-service (SaaS) products provide collaborative, cost-saving solutions for purchasing prescription drugs. 

We are seeking a Business Systems Analyst to join our Business Operations team The Business Systems Analyst (BSA) will primarily support day-to-day operations with a focus on managing data ingestion pipelines and EDI file transfers to ensure successful file transferring and loading into our system. The BSA investigates and troubleshoots any data file failures and works between our external clients and internal engineering teams to implement business solutions.

*Our preferred candidate will reside in Columbus, OH. Position will primarily allow for remote working with occasional in-office support for presence for key meetings.

* 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.

Essential Functions / Job Duties

• Meet with clients to discuss their data interchange needs

• Debug/ troubleshoot the data pipeline failures to rule out file issues

• Set up Databricks workflows and triggers using already built data pipelines

• Execute ad hoc data pipelines and perform validations using basic SQL or pre-built QA scripts

• Assist in setup and maintenance for inbound and outbound SFTP accounts

• Manage ongoing file