Financial Analyst

Job Title: Financial Analyst II - PO & Invoice Reconciliation
Duration: 6 Months, with potential extension
Location: Sheridan Rd, North Chicago, IL 60064
Work Model: 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. This position's pay range is $35.00/hr – $39.00/hr.