Senior Analytics Engineer [AQ-24725]

Aquent; Chicago (IL); On-site; USD 130,000 - 170,000; Full time

Job summary

Aquent partners with a leading healthcare organization in Chicago to build and maintain advanced analytics across procurement, supplier management, and payments. You will deliver self-serve dashboards, drive spend optimization, and enable data-driven decisions across enterprise functions.

With 5+ years in analytics or finance analytics, you will champion data governance, model forecasting, and KPI development while collaborating with Finance, IT, and procurement teams to maximize value and

Qualifications

• 5+ years of leading complex data analytics, BI, procurement analytics, or finance analytics initiatives.
• Proven expertise in SQL for data extraction, reconciliation, and validation.
• Dashboard development with Power BI or similar BI tool.
• Forecasts, projections, benchmarks, and performance metrics for strategic decisions.
• Data validation rules, reconciliations, data flows, and definitions.

Responsibilities

• Design, deliver, and maintain self-serve analytics dashboards, reports, scorecards, and executive-ready analyses for payments, procurement, supplier management, and spend.
• Lead cross-functional initiatives with Finance, Category Management, Supplier Management, and IT to align on data, definitions, and KPI assumptions.
• Analyze invoice data, payment cycles, POs, maverick spend, cycle times, and payment terms to identify improvements and efficiencies.
• Develop and maintain procurement forecasting models, spend pipelines, and contract renewal scenarios with performance tracking.
• Perform contract and supplier analytics, assess performance, risk, sustainability, and metadata to enable rationalization and renewal tracking.

Skills

SQL

Power BI

Forecasting & Modeling

Data Validation & Reconciliation

KPI & Metrics

Education

Bachelor’s degree or equivalent

Tools

Oracle

Coupa

Zip

iCertis

Job description

Aquent is proud to partner with a leading organization in the healthcare sector, a company deeply committed to improving lives and pioneering advancements in healthcare. This organization stands at the forefront of leveraging data to drive strategic decisions, optimize operations, and significantly enhance patient care. Joining this mission-driven environment means your work will directly contribute to the efficiency and effectiveness of critical enterprise functions, making a tangible difference in the future of healthcare.

We are searching for a highly skilled and passionate individual to join a dynamic team, where you will be instrumental in transforming complex data into actionable insights across critical enterprise functions like Procurement and Supplier Management. In this pivotal role, you will design, develop, and maintain cutting-edge analytical solutions that directly inform strategic business decisions, optimize spend, and drive operational efficiencies. Your expertise will not only enhance data visibility but also empower cross-functional teams to make data-driven choices that shape the future of healthcare operations. Get ready to make a significant impact by bringing clarity and foresight to complex data landscapes!

Key Responsibilities

• Design, deliver, and maintain self-serve analytics dashboards, reports, scorecards, and executive-ready analyses covering payments, procurement, supplier management, savings, and data governance.
• Lead cross-functional initiatives, collaborating with Finance, Category Management, Supplier Management, and IT teams to align on business definitions, KPI assumptions, data flows, and strategic recommendations.
• Optimize spend and working capital by analyzing invoice data, payment cycles, purchase orders, maverick spend, cycle times, and payment terms to identify actionable improvements and operational efficiencies.
• Drive procurement forecasting and modeling by establishing and maintaining methodologies and scenario models for spend, savings, pipeline activity, and contract renewals, while rigorously tracking forecast performance.
• Perform comprehensive contract and supplier analytics, evaluating supplier performance, risk, sustainability, diversity, and contract metadata to enable base rationalization and proactively track upcoming expirations and renewals.
• Lead financial tie-out activities with Finance and key stakeholders to validate cost savings accuracy and eliminate duplicate recognition.
• Benchmark purchase prices and procurement performance indicators against market data to pinpoint risk areas and identify cost-saving opportunities.
• Establish robust data quality and governance frameworks, including creating data validation rules, executing reconciliations, conducting audits, developing source-to-report documentation, and maintaining data dictionaries to ensure high data integrity across systems.
• Partner with IT on data mapping and reporting requirements for system integrations, while providing technical guidance, office hours, and documentation to empower internal users.

Must-Have Qualifications

• Bachelor’s degree (or equivalent practical experience) with 5+ years of experience leading complex data analytics, business intelligence, procurement analytics, or finance analytics initiatives.
• Strong proficiency in SQL for complex data extraction, reconciliation, and validation.
• Proven expertise in developing dashboards using Power BI or a comparable business intelligence tool.
• Demonstrated track record creating forecasts, projections, benchmarks, and performance metrics that directly inform strategic business decisions.
• Proven ability to establish data validation rules, execute reconciliations, trace root causes, and document data flows, business logic, and definitions.
• Outstanding ability to translate ambiguous business questions into structured analytical frameworks and clearly convey complex technical findings to non-technical leaders.
• Strong organizational skills to independently prioritize and manage a portfolio of concurrent projects with minimal supervision.

Nice-to-Have Qualifications

• Prior experience in procurement, supply chain, strategic sourcing, accounts payable, strategic spend analytics, working capital analysis, or healthcare analytics.
• Hands-on experience working with enterprise procurement and contract systems such as Oracle, Coupa, Zip, or iCertis.
• Experience applying statistical analysis, financial modeling, or scenario analysis in a large-enterprise environment.