Supply Chain Analytics Analyst

Lexington Medical Center

1d

About The Position

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.

Requirements

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

Responsibilities

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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level