Supply Chain Analytics Analyst Job Listing at Lexington Medical Center in West Columbia, SC (Job ID 1160009500)

Description

Material Management  
Full Time
Day Shift 
8am to 4:30 pm

Consistently named best hospital, Lexington Medical Center dedicates itself to providing quality health services that meet the needs of its communities. Ranked #2 in the state and #1 in the Columbia metro area by U.S. News & World Report, Lexington Medical Center is the only hospital named one of the Best Places to Work in South Carolina.

The 607-bed teaching hospital anchors a health care network that includes five community medical centers and employs more than 8,000 health care professionals. The network includes a cardiovascular program recognized by the American College of Cardiology as South Carolina's first HeartCARE CenterTM and an accredited Cancer Center of Excellence affiliated with MUSC Hollings Cancer Center for research and education. The network also features an occupational health center, the largest skilled nursing facility in the Carolinas, an Alzheimer's care center and nearly 80 physician practices.  Its postgraduate medical education programs include family medicine and transitional year.

Provide process improvement and data analysis/procurement modeling support to the Supply Chain team and other key Supply Chain stakeholders within Lexington Medical Center (LMC), including the Physician Network. Support and maintain Supply Chain Management systems to maximize effectiveness of Financial and Supply Chain business operations by working collaboratively with all internal Supply Chain customers as well as stakeholders within LMC. Assists operation subject matter experts with ensuring data integrity regarding sourcing of medical products, utilization trends, RFP response modeling, KPI dashboarding, verification of procedures to be performed, and portfolio/service line analysis of savings, spend, and the schedule to which both occur. Responsible for maintaining service line portfolio integrity regarding data, price, Payor mix, utilization, and products brought into LMC via the Value Analysis process.

Minimum Education: Bachelor's Degree in Supply Chain, Business Administration, Engineering, Procurement, Computer Science, or Related Field.
Minimum Years of Experience: 3 Years of Experience in a Combination of Supply Chain Management in Related Business Services Area or Applications/Analytics experience in a Medium to Large Organization.   
Substitutable Education & Experience: In lieu of Bachelor's Degree and 3 Years of Experience, will consider either of the following combinations:

Associate's or Bachelor's Degree in Computer Science, Management Science, Business Administration, Accounting, Engineering, Supply Chain or related field with 8 years' of related experience in relevant business system area (Finance, Accounting, Material Management, or Inventory Management).
Required Certifications/Licensure: None
Required Training: Advanced Excel and/or report writing skills; 
Strong Query/SQL skills and other database query and reporting tools;
Proficiency using Oracle/PeopleSoft or related procurement software; 
Strong understanding of Financial, Clinical or Supply Chain processes and data 

• Assists with planning and implementation of sourcing strategy initiatives and supporting analytics/modeling for Supply Chain Services in collaboration with clinical service line leaders and stakeholders across LMC as well as members of the Supplier community.  This role is responsible for gathering, analyzing, and presenting complex healthcare data to support business and clinical initiatives.
• Serves as the Supply Chain materials management information systems technology lead regarding maintenance and upkeep of the item master, Oracle Cloud initiatives regarding Supply Chain, and all maintenance and reporting as necessary.
• Serves as analytics lead for LMC Supply Chain Services on various high dollar clinical/non-clinical initiatives across LMC as assigned by the VP of SC.
• Liaison for perioperative, Cath Lab, IR and other strategic PPI (Physician Preference Item) areas and Supply Chain leadership.  Provides product analysis to support Value Analysis functionality as well as modeling throughput of critical supplies. 
• Models and constructs data to build sourcing strategies and potential outcomes regarding stakeholder requirements and  supplier response. Analyze and interpret complex healthcare data to identify trends, patterns, and monitor Supply Chain financial performance.  
• Configure ad hoc reports from Oracle and GHX to meet sourcing initiative modeling requirements, as well as related response to data inquiries from system stakeholders.
• Works and collaborates with Decision Support to determine CPT codes for procedures to model cost per case for all service lines, as well as help develop Payor reimbursement models for certain products and procedures. 
• Develops documentation/procedures to support system sourcing initiatives, contract and pricing models according to department standards.
• Develop vendor scorecards and portfolio footprints for major vendors.  Develops Sourcing Portfolios for each service line to include Epic charge process flow for new products introduced into the LMC system.
• Recommend process/customer service improvements, innovative solutions, policy changes and/or major variations from established policy.
   

• Apply critical thinking skills and quantitative analysis to detect and measure business trends. Interpret data to "tell a story" by providing actionable insights.
• Resolve problems and recommends solutions through research, inquiry and data analysis maintaining logs and tracking of issues.
• Tracks savings from the shelf to the "GL" as well as provide financial support including trending analysis and benchmark comparisons to the Cost Containment, Value Analysis, and Surgical and Procedural Sites Committees.
• Develop strong working relationships with clinical leaders in the hospital and throughout the physician network.
• Write, maintain and support a variety of reports or queries utilizing appropriate reporting tools.  Assist in development of standard reports for ongoing customer needs.  Provided ad hoc reports from key systems as requested. Help maintain data integrity through use of systems audits, running queries and analyzing data.  Identifies reports and develops report specifications for report writers to meet the needs of the application user.
• Periodically audits Supply Chain Services  data to ensure conformance with hospital policies and interdepartmental performance standards.
• Analyze Supply Chain processes, make recommendations for improvements and assist in evaluation and selection of new software solutions to maintain and enhance business operations.
• Evaluates current and prospective analytical tools related to Clinical Modeling within Supply Chain.
• Mentor and provide guidance to junior analysts regarding data analysis technique & reporting
• Reports directly to the VP of Supply Chain, LMC
• Performs all other duties as assigned and other duties as may be assigned by authorized personnel or as required in an emergency, e.g., fire, disaster.

We are committed to offering quality, cost-effective benefits choices for our employees and their families:

• Day ONE medical, dental and life insurance benefits 
• Health care and dependent care flexible spending accounts (FSAs)
• Employees are eligible for enrollment into the 403(b) match plan day one.  LHI matches dollar for dollar up to 6%.
• Employer paid life insurance – equal to 1x salary
• Employee may elect supplemental life insurance with low cost premiums up to 3x salary 
• Adoption assistance
• LHI provides its full-time employees employer paid short-term disability and long-term disability coverage after 90 days of eligible employment
• Tuition reimbursement
• Student loan forgiveness

Equal Opportunity Employer
It is the policy of LMC to provide equal opportunity of employment for all individuals, and to remain compliant with applicable state and federal laws and regulations. LMC strives to provide a discrimination-free environment, and to recruit, select, on-board, and employ all employees without regard to race, color, religion, sex, age, disability, national origin, veteran status, or pregnancy, childbirth, or related medical conditions, including but not limited to, lactation. LMC endeavors to upgrade and promote employees from within the hospital where possible and consistent with the employee's desires and abilities and the hospital's needs.