Aeroseal→
Financial and Planning Analysis Intern at Aeroseal in Miamisburg, OH
InternshipOn-siteMiamisburg, OH
Skills
microsoft 365excelpowerbidata analysisai toolslogical thinkingdesire to learn
Job Description
Summary: Aeroseal is one of the fastest-growing clean technology companies in the U.S., and they are seeking an FP&A Intern to support broader finance initiatives. The intern will gain exposure to corporate finance through project work, contributing to financial planning and analysis efforts.
Responsibilities:
- Automated A/R consolidation and reporting
- Integration of NetSuite, Dialpad, Shopify, Salesforce, etc
- Ability to easily drill down to key business drivers
- Ex. Customer -> PO -> Invoice -> Address/Product Type
- Matrix buildout allowing for custom categories, flagging, and tracking
- Automatic delivery to account owners of outstanding issues
- Potential for suggestive workflows and AI integration
- Capitalization planning and reporting
- Design and build a capex reporting module that fits into our planning tool that replaces the excel files we use today
- Automate capex classification of capex actuals
- Solve ad hoc transaction reporting with pain points in NetSuite
- Understand commercial ERPs
- Understand transaction flow (ledger vs non-ledger transactions)
Required Qualifications:
- Actively completing a 4-year degree program from an accredited business school
- Proficient or above in Microsoft 365, pivot tables, lookups, and other Excel or PowerBI based data analysis tools
- Organized with a strong bias towards a logic-based approach to stepping through data and processes
- A desire to learn, to build, to improve themselves, other people, and processes they touch
- Experience using AI tools
Required Skills: Microsoft 365, Excel, PowerBI, Data analysis, AI tools, Logical thinking, Desire to learn
Benefits: On-site fitness center with weekly group training and yoga instruction, Growth Mindset Learning Reimbursement including book reimbursement., Dog-friendly workplace.
Benefits
On-site fitness center with weekly group training and yoga instruction
Growth Mindset Learning Reimbursement including book reimbursement.
Dog-friendly workplace.