FP&A Analyst

Job Description

Job Description

We are looking for an FP& A Analyst to support financial planning, reporting, and business analysis for a retail organization in Rochester, New York. This Long-term Contract opportunity is ideal for someone who is detail oriented and can strengthen day-to-day financial operations while partnering closely with merchandising and business teams to deliver timely insights. The role emphasizes reporting, data analysis, and monthly financial support, with a strong focus on SAP, Excel and Power BI in an on-site environment.

Responsibilities:

• Develop, refresh, and distribute recurring financial and operational reports for stakeholders across the business.

• Partner with merchandising and other cross-functional teams to analyze performance trends and provide actionable business insights.

• Support month-end activities by helping maintain continuity in financial reporting, gross profit analysis, and inventory-related reviews.

• Use advanced Excel capabilities, including lookup functions, pivot tables, and macros, to organize data and improve reporting efficiency.

• Build, update, and refine Power BI dashboards and visual reports to support decision-making and monthly reporting needs.

• Assist with financial analysis and provide critical FP& A support while internal team members focus on new system adoption.

• Validate reporting outputs, investigate discrepancies, and help resolve data issues identified during testing and ongoing reporting cycles.

• Contribute to inventory and store-level reporting activities, including helping establish practical reporting solutions where gaps exist.

• 5+ years of experience in FP& A, financial analysis, or a closely related accounting and reporting role.

• Strong proficiency in Excel, including VLOOKUPs, pivot tables, and macro-enabled reporting tasks.

• Hands-on experience with SAP and Power BI for dashboard creation, report maintenance, and data visualization.

• Solid understanding of budgeting, financial reporting, and performance analysis in a business-facing environment.

• General accounting knowledge with the ability to support monthly close and interpret gross profit and inventory results.

• Experience working with large data sets and producing accurate, timely reporting for business stakeholders.

• Familiarity with tools such as EPM, Adaptive Insights, capital planning processes, or annual budgeting activities is preferred.