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.