Project Financial Analyst

Venteon; Dearborn (MI); On-site; USD 34,000 - 41,000; Full time

Job summary

Venteon is seeking a Project Financial Analyst in Dearborn, MI to support a closed-loop steel supply chain. You will reconcile purchases, processing costs, and finished parts with OEM data, ensuring matches across data and cost through timely true-ups.

Requirements include GAAP understanding and advanced Excel skills. The role is onsite, full-time, with a project timeline through April 2027, and compensation of $25–$30 per hour depending on experience.

Qualifications

• GAAP understanding is required.
• Proficiency in advanced Excel for large datasets and reconciliation.
• Attention to detail to spot pricing or weight differences.
• Understanding how raw materials move through the supply chain.

Responsibilities

• Reconcile steel inventory and financial data by matching purchases, costs, and finished parts to OEM data.
• Perform timely true-ups to ensure data and cost alignment with OEM records.
• Create financial and inventory reports showing monthly or quarterly results.
• Collaborate with logistics, finance, and procurement to fix data mismatches.

Skills

Advanced Excel

GAAP understanding

Attention to detail

Supply chain logic

Education

College degree (nice to have)

Job description

Venteon and Harvard Resource Solutions are hiring a Project Financial Analyst to provide support in Dearborn, MI. Assist our client by performing financial reconciliations and analysis. You will manage the financial and material "true-up" process for a closed-loop steel supply chain.

POSITION TYPE: Full time. Onsite daily. Project to last through April 2027. PAY: $25.00 to $30.00 per hour based on skills/ years of experience.

Requirements of the Project Financial Analyst

• College degree is nice to have.
• Understanding of GAAP is required.
• Advanced Excel: Use VLOOKUP/XLOOKUP, pivot tables, and large data sets to match numbers quickly.
• Attention to Detail: Spot small pricing or weight differences in steel shipments.
• Supply Chain Logic: Learn/Understand how raw materials move from purchase to third-party processing and back to the original vendor.

Duties of The Project Financial Analyst: You will reconcile complex steel inventory and financial data by matching raw material purchases, processing costs, and finished part sales back to the Original Equipment Manufacturer (OEM). The main job is to ensure that what your company bought, paid for, and sold back to the OEM matches perfectly in data and cost by performing timely and accurate true ups with the OEM.

Key Responsibilities

• Data Reconciliations: Compare raw steel purchases and payments against processed parts sold back to the OEM using Excel.
• Dashboard Management: Pull and verify shipping, receiving, and billing data directly from the OEM portal or dashboard.
• Variance Tracking: Identify and resolve cost discrepancies, missing invoices, or inventory gaps between your records and the OEM's records.
• Process Reporting: Create clear financial and inventory reports to show monthly or quarterly true-up results to management.
• Cross-Functional Support: Work with the logistics, finance, and procurement teams to fix root causes of data mismatches.