Skills Advanced proficiency in Microsoft Excel, including formulas, pivot tables, and data modeling Experience with reporting tools (e.g., Crystal Reports, dashboards, query development) Strong attention to detail with ability to synthesize complex data into executiveĆ¢level insights Effective written and verbal communication skills Ability to manage projects and priorities in a dynamic environment Comfortable presenting data and findings to leadership and stakeholder groups Strong collaboration skills across technical and nonĆ¢technical teams Responsibilities Expectations Contract Sourcing Analytics Develops and maintains analytics related to GPO and local contract utilization, pricing compliance, and savings realization Supports sourcing initiatives by preparing spend analysis, pricing comparisons, benchmarks, and utilization insights Partners with Contract Analysts to support supplier evaluations, negotiations, and sourcing events with dataĆ¢driven insights Tracks and reports contract benefits, rebates, inefficiencies, and compliance trends Reporting Business Intelligence Designs, builds, and maintains reports and dashboards supporting Sourcing Contracting leadership Writes and maintains system queries and reports based on business specifications Ensures high quality, integrity, and consistency of data across sourcing, purchasing, and financial systems Supports adĆ¢hoc reporting requests related to contracts, suppliers, pricing, and utilization ERP Systems Support Supports integrity of the ERP system (Lawson/Infor) as it relates to contract, pricing, and sourcing data Coordinates with IT and Finance on system enhancements, integrations, and data flows impacting sourcing and contracting Assists with onboarding and integration of new software or tools impacting sourcing analytics or contract data Maintains working knowledge of EDI processes and data integration impacting contract pricing and utilization CrossĆ¢Functional Collaboration Acts as a liaison between Sourcing Contracting, Purchasing, Accounts Payable, Finance, and Information Services Supports reconciliation of pricing, contract execution, and ReceivedĆ¢NotĆ¢Invoiced (RNI) balances as they relate to contract compliance Provides analytical support for audit inquiries, compliance reviews, and leadership reporting Serves as a subject matter expert for contractĆ¢related data and analytics questions Continuous Improvement Innovation Benchmarks best practices in healthcare sourcing analytics and reporting Identifies opportunities to improve contract visibility, reporting automation, and data usability Enhances analytical capabilities of the Sourcing Contracting function through advanced reporting and system optimization Participates in special projects and enterprise initiatives as assigned Department Responsibilities Expectations Promotes Aultman RESPECT values to foster a healthy, inclusive work environment Abides by and demonstrates the Aultman Leadership Promise (ACE): Act, Communicate, Engage Lives the mission and values of AHF in dayĆ¢toĆ¢day behaviors Supports a culture of accuracy, compliance, and accountability Demonstrates professionalism, integrity, and collaboration in all interactions Working Conditions 8:00am 4:30pm M-F; variable based on operational needs. The Business Analyst works closely with the Executive Director of Sourcing Contracting, Contract Analysts, Contract Administrators, Purchasing, Accounts Payable, Finance, and Information Services to ensure contractĆ¢related data is accurate, integrated, and effectively leveraged across enterprise systems.