Jordan Pierce
Financial Analyst, FP&A | Forecasting, Budgeting and Variance Analysis
Summary
FP&A analyst with 5 years in transportation and manufacturing. Owns the monthly forecast for a $420M freight business and builds the models leadership uses for pricing and capital decisions. Strong in Excel, SQL and Power BI, and clear when explaining variances to operators who do not live in spreadsheets. CFA Level II candidate.
Experience
Carolina Freightways
- Own the monthly revenue and operating expense forecast for a $420M business; full-year forecast has landed within 2% of actuals two years running.
- Built a lane-level profitability model covering 1,800 shipping lanes, which led to repricing 140 unprofitable lanes and about $3.5M in added annual margin.
- Cut the monthly reporting cycle from 8 business days to 5 by moving variance reports from Excel into Power BI with SQL feeds.
- Prepare the CFO's monthly business review deck and present variances to 6 regional operations leaders.
- Supported the business case for a $22M fleet replacement program approved by the board in 2025.
Queen City Components
- Managed the annual budget process for 3 manufacturing plants with $95M in combined operating costs.
- Built a standard cost model that found $600K in underpriced parts across the top 200 SKUs.
- Reconciled capital project spending monthly for 25 active projects.
Skills
- Financial Modeling
- Forecasting and Budgeting
- Variance Analysis
- Excel (advanced, including Power Query)
- SQL
- Power BI
- Oracle NetSuite
- Profitability Analysis
- Capital Budgeting (NPV, IRR)
- Executive Presentations
Certifications
- CFA Level II Candidate (Level I passed, 2024)
Education
BS in Finance, University of North Carolina at Charlotte, 2021