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.
