Working Capital Solutions Intern

Columbia Bank • Seneca, IL

4d • $22 • Onsite

About The Position

This intern will report to the Working Capital Solutions Team. In this role, you will support client facing teams by preparing meeting materials, taking notes, tracking actions, and drafting executive ready summaries and decks. You will analyze AR, AP, inventory, and cash flow data; baseline DSO, DPO, DIO, and CCC; and build Excel based financial models and scenario analyses. You will contribute to engagement management by tracking milestones, KPIs, and deliverables, and you will collaborate across sales, product, credit, procurement, treasury, operations, and IT to support pilots, tools, and workflow documentation. Your objective will be to strengthen client relationships, deliver accurate and insightful working capital analyses, support project execution, and contribute to a smooth and value focused client experience. This includes producing on time, error free deliverables; maintaining clear action tracking and stakeholder engagement; building repeatable templates/models; and supporting business development efforts such as proposals, case studies, and ROI calculators. Preferred degree and skillset include a degree in Finance, Accounting, Economics, Business Administration, Supply Chain, Operations Management, MIS, Information Systems, Data Analytics, or Industrial Engineering. Skillset will consist strong written and verbal communication; ability to synthesize complex findings. Organization, project management, attention to detail, and KPI tracking. Financial and analytical skills including working capital metrics and financial statement understanding. Excel proficiency (lookups, nested formulas, pivots, scenario/sensitivity exposure). Bonus: Power BI, Tableau, SQL, Python, Power Query. Tools: Microsoft 365, CRM familiarity, ERP exposure. Mindset: curious, quantitative, proactive, client centered, adaptable. About You: You’re an undergraduate student aiming to graduate in spring 2026/2027 or a recent graduate within the last year. Available to work full-time (40 hours/week), fully onsite, for 10 weeks starting in June. Strong written and verbal communication skills. Proficient in Excel and PowerPoint. Excellent interpersonal skills.

Requirements

• Undergraduate student aiming to graduate in spring 2026/2027 or a recent graduate within the last year
• Available to work full-time (40 hours/week), fully onsite, for 10 weeks starting in June
• Strong written and verbal communication skills
• Proficient in Excel and PowerPoint
• Excellent interpersonal skills

Nice To Haves

• Degree in Finance, Accounting, Economics, Business Administration, Supply Chain, Operations Management, MIS, Information Systems, Data Analytics, or Industrial Engineering
• Strong written and verbal communication
• Ability to synthesize complex findings
• Organization, project management, attention to detail, and KPI tracking
• Financial and analytical skills including working capital metrics and financial statement understanding
• Excel proficiency (lookups, nested formulas, pivots, scenario/sensitivity exposure)
• Power BI, Tableau, SQL, Python, Power Query
• Microsoft 365, CRM familiarity, ERP exposure
• Mindset: curious, quantitative, proactive, client centered, adaptable

Responsibilities

• Preparing meeting materials
• Taking notes
• Tracking actions
• Drafting executive ready summaries and decks
• Analyzing AR, AP, inventory, and cash flow data
• Baseline DSO, DPO, DIO, and CCC
• Build Excel based financial models and scenario analyses
• Contribute to engagement management by tracking milestones, KPIs, and deliverables
• Collaborate across sales, product, credit, procurement, treasury, operations, and IT to support pilots, tools, and workflow documentation
• Strengthen client relationships
• Deliver accurate and insightful working capital analyses
• Support project execution
• Contribute to a smooth and value focused client experience
• Producing on time, error free deliverables
• Maintaining clear action tracking and stakeholder engagement
• Building repeatable templates/models
• Supporting business development efforts such as proposals, case studies, and ROI calculators

Benefits

• Comprehensive healthcare coverage (medical, dental, and vision plans)
• A 401(k)-retirement savings plan with employer match for qualifying associate contributions
• An employee assistance program
• Life insurance
• Disability insurance
• Tuition assistance
• Mental health resources
• Identity theft protection
• Legal support
• Auto and home insurance
• Pet insurance
• Access to an online discount marketplace
• Paid vacation, sick days, volunteer days, and holidays

What This Job Offers

• Job Type: Full-time
• Career Level: Intern
• Education Level: No Education Listed