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<ul><li>Meet with clients to discuss their data interchange needs</li><li>Debug/ troubleshoot the data pipeline failures to rule out file issues</li><li>Set up Databricks workflows and triggers using already built datapipelines</li><li>Execute adhoc data pipelines and perform validations using basic SQL or pre-built QA scripts</li><li>Assist in setup and maintenance for inbound and outbound SFTP accounts</li><li>Manage ongoing file transfer processes including, PGP encryption/decryption setup, outbound file feed automation, management of SSH &amp; PGP keys and inbound file feed automation with clients and partners</li><li>Work directly with Implementation and Client Success teams on client requests</li><li>Anaylze business systems, networking configurations, and data storage facilities</li><li>Build customized data interchange systems for cross-company or department use</li><li>Gather user feedback on the accuracy, efficiency, and functionality of the system, and adjust and customize the system based on user feedback</li><li>Deploy completed systems and providing maintenance support</li><li>Train end-users on the proper use of the system</li><li>Perform other duties as reasonably requested by management</li></ul>Position Qualifications:<ul><li>Bachelor’s Degree in Computer Science, Information Systems or a similar field, or related experience, and typically requires 2+ years of related experience</li><li>Experience managing data ingestion pipelines</li><li>Basic experience in SQL</li><li>Experience in a Business Operations, Client Success, or similar organization with proven ability to communicate with cross-functional teams such as engineering, sales, or executive leadership</li><li>Experience with JIRA (or similar ticketing systems)</li><li>Ability to handle sensitive/confidential information</li><li>Demonstrated effective communication and listening skills, with the ability to efficiently problem solve novel situations by providing creative solutions</li></ul>Preferred Qualifications:<ul><li>Experience with pharmacy, healthcare, or financial industries</li><li>Experience with Tableau or other database visualization software</li><li>Experience with EDI software (GoAnywhere, MOVEit, GlobalScape, etc.)</li><li>Familiarity with Databricks or any other ETL Cloud tools in managing triggers</li><li>Familiarity with Python</li><li>Salesforce experience</li></ul>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, please <a href="https://careers.mckesson.com/en/benefits" target="_blank">click here.</a>Our Base Pay Range for this position$66,000 - $110,000McKesson is an Equal Opportunity Employer McKesson provides equal employment opportunities to applicants and employees and is committed to a diverse and inclusive environment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age or genetic information. For additional information on McKesson’s full Equal Employment Opportunity policies, visit our <a target="_blank" href="https://www.mckesson.com/about-mckesson/eeo-at-mckesson/">Equal Employment Opportunity</a> page. Join us at McKesson!