Senior Financial Planning & Analysis (FP&A) Analyst – SQL-Driven Reporting & Executive Insights

GrabAGun•Addison, TX

1d•Onsite

About The Position

At GrabAGun, financial clarity drives operational excellence. We rely on accurate analysis, disciplined budgeting, and strategic modeling to support decisions across the organization. The Senior FP&A Analyst will translate financial data into meaningful insights, build structured budgets, conduct comparative financial reviews, and prepare executive-level presentations that help guide the business forward. This role is ideal for someone who thrives in a fast-paced environment, is highly analytical, and wants to take ownership of building financial narratives from SQL-based reporting datasets.

Requirements

4–7 years of experience in FP&A, corporate finance, or financial analysis.
Strong financial statement analysis skills, including comparative reviews, trend identification, variance explanation, and performance commentary.
Proven experience with forecasting, budgeting, and ongoing rolling estimates.
Advanced Excel skills for modeling, forecasting, scenario analysis, and data manipulation.
Demonstrated ability to prepare executive-level presentations that clearly summarize financial results, drivers, and recommendations.
Comfort working with data sourced from financial reporting systems, BI tools, and pre-generated SQL Scripts; ability to interpret structured datasets and translate them into insights.
Strong analytical reasoning and business acumen, connecting numbers to operational realities and risks/opportunities.
High attention to detail, accuracy, and consistency in all reporting and analysis.
Ability to operate in a fast-paced environment, managing multiple deliverables with tight deadlines.
Personal commitment to ethical business behavior, accountability and ownership of deliverables, and ongoing skill development and continuous improvement

Nice To Haves

Experience working with SQL-based reporting environments (a plus, not required).
Experience with Power BI for building dashboards and visual reports (highly valued).
Exposure to Snowflake or BigQuery
Familiarity with financial or operational reporting automation.
Background in eCommerce, retail, or 3PL

Responsibilities

Lead the monthly and quarterly forecasting process, including P&L, balance sheet, and cash flow.
Communicate financial results vs. budget, estimates, and strategic plan through clear, executive-ready reporting and commentary.
Orchestrate the Annual Operating Plan process, coordinating inputs from departments and consolidating into a cohesive financial plan.
Own the reliability, timeliness, and accuracy of financial forecasts and related reporting.
Prepare structured comparative analysis for leadership (actuals vs. budget, forecast, prior year, and benchmarks).
Build and maintain performance metrics and dashboards to track key initiatives and operational performance.
Develop and refine variance analysis (revenue, margin, operating expenses, working capital, cash flow) with clear explanations and drivers.
Support and help shape the company’s strategic and operational objectives through scenario modeling and financial impact analysis.
Support special projects in process improvement, documentation, and automation of reporting and analysis.
Work closely with the Director of Finance to streamline FP&A workflows and deepen analytical capabilities.
Prepare and coordinate ad hoc financial analysis, especially in support of process improvement and value-based decision-making.
Become a trusted business partner to corporate and site leadership, providing advice, challenge, and insight that supports sound decisions.