FP&A Intern: Product Profit & Analytics

Crane Company; Los Angeles (CA); On-site; USD 32,000 - 34,000; Full time

Job summary

Crane Company is seeking an FP&A Analyst Intern in Los Angeles to support financial planning, reporting transformation, and performance management in a manufacturing environment.

You will help develop analytics for product profitability, create Power BI or Excel reports, and assist with Value Stream and Product Line reporting within HFM, collaborating with Finance, Operations, Sales, Product Management, Engineering, Customer Service, and Supply Chain teams.

Qualifications

• Pursuing a Bachelor’s degree in Finance, Accounting, Economics, Business Analytics, Data Analytics, or related field. Senior or Graduate student preferred.
• 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.

Responsibilities

• 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.
• Develop 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.
• 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.
• 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.

Skills

Excel

Power BI

Data analysis

Communication

Education

Bachelor’s degree in Finance/Accounting/Economics/Business Analytics

Tools

QAD

Job description

Crane Company is seeking an FP&A Analyst Intern in Los Angeles to support financial planning, reporting transformation, and performance management in a manufacturing environment.

You will help develop analytics for product profitability, create Power BI or Excel reports, and assist with Value Stream and Product Line reporting within HFM, collaborating with Finance, Operations, Sales, Product Management, Engineering, Customer Service, and Supply Chain teams.