Financial Analyst

Job Title: Financial Analyst II - PO & Invoice Reconciliation Duration: 6 Months, with potential extension Location: North Chicago, IL 60064 (Mon/Fri Remote – Tuesday – Thursday Onsite) Position Overview The Financial Analyst II will support the Business Operations Finance team with a dedicated cleanup and maintenance initiative following the deployment of a new internal invoice forecasting tool. This hands-on role focuses on purchase order (PO) tracking, invoice reconciliation, data discrepancy resolution, and cross-functional coordination. The primary scope is operational: cross-referencing information between SAP S/4HANA and internal tracking tools, obtaining invoice schedules from project stakeholders, addressing billing delays, and executing manual data entry for non-automated material purchase orders. (Note: This role is strictly operational finance and does not involve general ledger entries, month-end closing procedures, or high-level strategic corporate modeling.) Key Responsibilities Data Cleanup & Maintenance: Lead data integrity and cleanup efforts within the newly implemented proprietary invoice forecasting tool; keep internal records synchronized with live ERP data. Purchase Order Reconciliation & Tracking: Research purchase orders and corresponding invoice status in SAP S/4HANA to reconcile discrepancies between committed POs and vendor billings. Forecasting Support & Data Entry: Manually input and update material purchase orders into the internal tool to establish expected invoice schedules. Stakeholder Coordination: Partner directly with internal project leads, vendor contacts, and procurement to obtain updated delivery and billing timelines. Delay Resolution: Proactively identify, follow up on, and resolve billing lags, invoice blocks, and PO variances. Reporting & Variance Analysis: Pull raw data, execute data matching using intermediate Excel formulas, and maintain clean tracking logs for operational review. Required Skills & Qualifications 3 to 5 years of hands-on experience in general accounting, finance operations, accounts payable, or PO/invoice reconciliation. Intermediate Microsoft Excel Proficiency: Strong command of core functions including VLOOKUP, XLOOKUP, INDEX/MATCH, Pivot Tables, data filtering, and sorting. (Advanced VBA/macros are not required). SAP S/4HANA Working Knowledge: Practical familiarity with standard PO and invoice inquiry transactions (e.g., viewing PO history, line items, and invoice statuses). No direct master data posting or journal entry creation required in SAP. Strong Communication Skills: Fluent English proficiency (written and verbal) to facilitate daily coordination with cross-functional team members and external vendors. Detail-Oriented Mindset: Proven track record in high-volume data verification, reconciliation, and issue tracking. Education Requirements High School Diploma or associate degree with direct, relevant experience in SAP S/4HANA and Excel is fully acceptable. Bachelor’s degree in finance , Accounting, Business, or related discipline is welcome, provided expectations align with transactional data cleanup, PO reconciliation, and operational tracking rather than high-level financial planning or month-end closing. Preferred (Nice-to-Have) Industry Knowledge: Prior experience in Pharmaceuticals or Healthcare. Regulatory Familiarity: Knowledge of the Sunshine Act, HCP transparency reporting, or W-9/W-8 tax forms. At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. #J-18808-Ljbffr