Strategic Sourcing Analyst - Capital

Trinity Health; Livonia (MI); On-site; USD 65,000 - 95,000; Full time

Job summary

Trinity Health is seeking a Capital Sourcing Analyst to support sourcing managers with vendor quotes, CER reviews, and contract lifecycle activities. You will develop dashboards in Tableau/Power BI to track key metrics and drive decision making.

You will manage Icertis contracts, coordinate with cross-functional teams, and help realize savings across capital categories, contributing to operational efficiency and compliance.

Qualifications

• Bachelor’s degree in business or supply chain management or equivalent combination of education and work experience.
• 3+ years of sourcing experience in a large, multi-level organization.
• Strong knowledge of advanced data analytics and procurement practices; Excel, Power BI, Tableau or similar tools.
• Excellent analytical, attention to detail and ability to present complex findings clearly.
• Ability to create and maintain accurate records and reports; strong communication skills.

Responsibilities

• Support sourcing and procurement operations by managing vendor quotes and updating records in procurement systems (PeopleSoft).
• Review and approve CERs, verifying quote validity, pricing, terms, and expiration dates.
• Develop and maintain team performance dashboards using Tableau or similar tools.
• Lead contract lifecycle activities using Icertis and coordinate with Content group for contract build sheets.
• Identify and realize savings across Capital categories and support reporting to Finance and leadership.
• Collaborate with other supply chain teams to optimize value of Trinity Health—Supplier relationships.

Skills

Data Analytics

Power BI

Tableau

Excel

Vendor Management

Communication

Education

Bachelor's degree in business or supply chain management

Tools

PeopleSoft

Tableau

Power BI

Icertis

Microsoft Teams

Job description

Employment Type: Full time Shift: Day Shift Description:

Purpose

Responsible for the data capture, analysis & reporting of data information to assist the Trinity Health leadership team achieve operational efficiency. Responsible for auditing department information, producing reports & suggesting improvements to processes. Provides knowledge & expertise in the program, services & applications.

Note: “patients” refers to patients, clients, residents, participants, customers, members

Essential Functions

Our Trinity Health Culture: Knows, understands, incorporates & demonstrates our Trinity Health Mission, Values, Vision, Actions & Promise in behaviors, practices & decisions.

Work Focus:

Research, collects & analyzes information. Identifies opportunities, develops solutions, & leads through resolution.

Collaborates on performance improvement activities as indicated by outcomes in program efficiency & patient experience.

Responsible for distribution of analytical reports.

Process Focus:

Utilizes multiple system applications to perform analysis, create reports & develop educational materials.

Incorporates basic knowledge of Trinity Health policies, practices & processes to ensure quality, confidentiality & safety are prioritized.

Demonstrates knowledge of departmental processes & procedures & ability to readily acquire new knowledge.

Data Management & Analysis:

Research & compiles information to support ad-hoc operational projects & initiatives.

Synthesizes & analyzes data & provides detailed summaries including graphical data presentations illustrating trends & recommending practical options or solutions while considering the impact on business strategy & supporting leadership decision making.

Leverages program & operational data & measurements to define & demonstrate progress, ROI & impacts.

Maintains a Working Knowledgeof applicable federal, state & local laws / regulations, Trinity Health Integrity & Compliance Program & Code of Conduct, as well as other policies, procedures & guidelines in order to ensure adherence in a manner that reflects honest, ethical & professional behavior & safe work practices.

Functional Role (not inclusive of titles or advancement career progression)

The Capital Sourcing Analyst provides strategic support to the Sourcing Managers via a variety of essential activities. Supports the division in obtaining annual financial goals. Works independently and receives general direction and guidance from sourcing manager.

• Responsible for supporting sourcing and procurement operations by obtaining and managing vendor quotes, including updating expired quotes and maintaining accurate vendor records within procurement systems (PeopleSoft). Ensures pricing accuracy through verification processes and validates on-contract versus off-contract purchases to maintain compliance.
• Reviews and approves Capital Expenditure Requests (CERs) via Microsoft Teams or other designated method, confirming quote validity, pricing, terms, addresses, and expiration dates.
• Develops and maintains team performance reporting dashboards using Tableau or other designated software to track key metrics and support decision-making.
• Manages HPG contracts within Icertis, including oversight of contract lifecycle activities and coordination of contract build sheets with the Content group.
• Leads CRT form reviews for Capital initiatives and is responsible for submitting Capital CRTs to Finance. Provides support for Capital sourcing events and manages the end-to-end contract signature process.
• Leads select contract and S2 extensions, coordinates Technology and Security Assessment submissions, and calculates and documents savings across multiple Capital categories to ensure accurate reporting and value realization.
• Serves as a contact for RHM management-team members as it relates to Capital purchasing/sourcing issues. Provides guidance and investigates issues raised by ministries related to Capital contracts.
• Works with other Supply Chain verticals to support processes and procedures that optimize the value of the Trinity Health-Supplier relationship.
• Provides cross-functional support by covering sourcing specialists in purchase order (PO) processing as needed
• Manages & implements small-scale projects, programs & initiatives. Develops & manages aligned production, communications, service delivery plans & workflows to ensure plans are successfully implemented & services are delivered on time, on budget & to specifications.
• Performs other duties as assigned to meet business and organizational needs.
  

Minimum Qualifications

• Bachelor’s degree with major course work in business or supply chain management; or an equivalent combination of education and work experience.
• 3+ (three) years of sourcing experience which may include data analytics, procurement practices and/or vendor relationships in a large, multi-level, geographically dispersed organization.
• Comprehensive knowledge and skills in advanced data analytics and procurement practices including intermediate to advanced excel skills, knowledge of Power BI, Tableau, or similar applications.
• Strong analytical skills, attention to detail, and the ability to communicate complex findings in a clear and concise manner. The ideal candidate is highly proficient in data visualization, statistical analysis, and business intelligence tools.
• Knowledge of methods used in the access and use of information, the preparation of specifications, and the analysis of bids and contracts. Ability to set standards for and create and maintain accurate records and reports.
• Ability to identify problems, utilize originality and ingenuity to make recommendations and decisions, and implement solutions. Demonstrated ability to identify, investigate, analyze, and resolve complex issues.
• Excellent verbal and written communication skills.
• Strong problem-solving skills with the ability to research problems and present findings with attention to detail and a high degree of accuracy.
• Solid customer service qualities along with excellent interpersonal skills. Must be comfortable operating in a collaborative, shared leadership environment. Must have the ability to work effectively in a large, multi-level, geographically dispersed organization.
• Ability to establish and maintain productive and positive working relationships with all stakeholders and external suppliers. Ability to work independently and in collaboration with others.
• Proven prioritization, multi-tasking, and coordination skills within a fast-paced environment. Strong organizational skills and high level of initiative.
• Personal presence is characterized by a sense of honesty, integrity, and caring with the ability to inspire and motivate others to promote the philosophy, mission, vision, goals, and values of Trinity Health.
  

Additional Qualifications (nice to have)

• Healthcare experience in either clinical areas and/or supply chain
  

Physical & Mental Requirements & Working Conditions (General Summary)

Direct Healthcare Services / Indirect Healthcare / Support Services:

• Exposure to conditions which may be considered unpleasant to sight, touch, sound & / or smell. Occasional
• Exposure to fumes, odors, dusts, mists & gases, biohazards / hazards (mechanical, electrical, burns, chemicals, radiation, sharp objects, etc.). Occasional
• Exposure to or subject to noise, infectious waste, diseases & conditions. Occasional
• Exposure to interruptions, shifting priorities & stressful situations. Frequent
• Ability to follow tasks through to completion, understand & relate to complex ideas / concepts, remember multiple tasks & regimens over long periods of time & work on concurrent tasks / projects. Continuous
• Ability to read small print, hear sounds & voice / speech patterns, give / receive instructions & other verbal communications (in-person & / or over the phone / computer / device / equipment assigned) with some background noise. Continuous
• Perform manual dexterity activities & / or grasping / handling. Occasional
• Ability to climb, kneel, crouch & / or operate foot controls. Occasional
• Use a computer / other technology. Continuous
• Sit with the ability to vary / adjust physical position or activity. Frequent
• Maintain a safe working environment & use available personal protective equipment (PPE). Occasional
• Comply with applicable Code of Conduct, policies, procedures & guidelines. Continuous
• Ability to provide assistance in the event of an emergency. Occasional

Direct Healthcare Services:

• Perform activities that require standing / walking with the ability to vary / adjust physical position or activity. Occasional
• Lift a maximum of 30 pounds unassisted. Occasional
• Use upper & lower extremities, engage in bending / stooping / reaching & pushing / pulling. Occasional
• Work indoors (subject to travel requirements) under temperature-controlled & well-lit conditions. Continuous
• Encounter worksites (e.g., patient homes) or travel to worksites that may have variable internal & external environmental conditions. Occasional
• Perform work that involves physical efforts (e.g., transporting, moving, positioning & / or ambulating patients). Occasional

Indirect Healthcare / Support Services:

• Perform activities that require standing / walking with the ability to vary / adjust physical position or activity. Occasional
• Lift a maximum of 30 pounds unassisted. Occasional
• Experience of long periods of walking / standing / stooping / bending / pulling & / or pushing. Occasional
• Encounter a clinical / patient facing / hands on interactive work environment. Occasional
• Work indoors (subject to travel requirements) under temperature-controlled & well-lit conditions. Continuous
• Work outdoors with variable external environmental conditions. Occasional

Average Workday Activity: Occasional - O (1% - 33%), Frequent - F (34% - 66%), Continuous - C (67% - 100%)

Our Commitment

Rooted in our Mission and Core Values, we honor the dignity of every person and recognize the unique perspectives, experiences, and talents each colleague brings. By finding common ground and embracing our differences, we grow stronger together and deliver more compassionate, person-centered care. We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other status protected by federal, state, or local law.