FP&A Intern

Job Summary:

The FP&A Analyst Intern will support the Finance team with financial planning, reporting transformation initiatives, business analytics, and performance management activities. This role provides hands-on exposure to financial reporting, market and product profitability analysis, data visualization, and enterprise performance management processes within a manufacturing environment.

A key focus of this internship will be supporting three strategic initiatives: transitioning financial reporting from market analysis to product analysis, developing analytics for channel partner product sales by market and application, and assisting with the implementation of Value Stream and Product Line reporting within HFM. The intern will work closely with Finance, Accounting, Operations, Sales, Product Management, Engineering, Customer Service, and Supply Chain teams to develop analytical insights that support business decision-making and continuous improvement.

Essential Duties and Responsibilities:

Financial Reporting Transformation 

• Support the transition of management reporting from a market-based view to a product line, product family, and product profitability perspective. 

• Assist with developing reporting structures, data mappings, and validation processes to support enhanced product profitability analysis. 

• Analyze sales, bookings, backlog, margins, and operating performance by new product segments and product lines. 

Product, Channel, Market and Application Analytics 

• Assist in developing analytical models and dashboards to evaluate channel partner sales performance by part, product, market, and application. 

• Support analysis of revenue trends, market penetration, profitability, product mix, and growth opportunities across distribution channels. 

• Create Power BI or Excel-based reports and visualizations to provide management insight into product sales performance and customer demand trends. 

• Perform data extraction, cleansing, validation, and reconciliation activities from ERP and reporting systems. 

HFM Value Stream and Product Line Reporting 

• Assist with implementation and testing of Value Stream and Product Line reporting structures within HFM. 

• Support development of reporting hierarchies, dimension mappings, and validation procedures. 

• Participate in user acceptance testing and report validation activities. 

• Help document reporting processes, data definitions, and business requirements. 

• Assist with preparation of management reports utilizing the new reporting structures. 

Month-End Close Support 

• Assist Finance and Accounting teams with month-end reporting requirements. 
• Support account analysis and reconciliations as assigned. 
• Research and investigate reporting variances. 
• Prepare schedules and supporting documentation for management review and audit requests. 

QUALIFICATIONS GUIDELINES

Experience/Training/Education:

Required: Pursuing a Bachelor's degree in Finance, Accounting, Economics, Business Analytics, Data Analytics, or related field. Senior or Graduate student preferred.

Knowledge, Skills and Abilities:

• Strong analytical and problem-solving capabilities.
• High attention to detail and accuracy.
• Ability to work independently and manage multiple assignments.
• Strong organizational and time-management skills.
• Excellent written and verbal communication skills.
• Ability to present data in a clear and meaningful manner.
• Curiosity and willingness to learn financial planning and analysis processes.
• Team-oriented mindset with strong interpersonal skills.

Technical Skills:

• Proficiency in Microsoft Excel, including pivot tables, formulas, lookups, and data analysis. 
• Familiarity with Power BI, or other business intelligence tools preferred. 
• Basic understanding of financial statements and accounting concepts. 
• Experience with data analysis and reporting tools preferred. 
• Knowledge of QAD systems is a plus. 
• Strong computer and analytical skills. 

Learning Opportunities:

• Financial planning and forecasting processes. 
• Budget development and variance analysis. 
• Power BI dashboard development. 
• Sales, orders, backlog, and profitability analytics. 
• Manufacturing cost analysis. 

Hourly range: $23.00 to $25.00

This description has been designed to indicate the general nature and level of work being performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.

Crane Company. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, gender, sexual orientation, general identity, national origin, disability or veteran status.