Financial (FP&A) and Commercial Analyst

Summary

This position leads financial planning, forecasting, and reporting, and connects those results to sales pipeline and backlog data in Microsoft Dynamics 365 CRM. It directly supports our mission to be a vital part of the success of our customers, employees, and vendor partners by giving the CFO, CEO, and General Managers timely, decision-ready information. The role is also Gladwin's internal business owner of Dynamics 365 CRM, setting priorities and directing internal and outside support.

Key Responsibilities

Financial Planning and Analysis

• Lead the annual budget and rolling forecasts for revenue, gross profit, expenses, and cash, working with General Managers on assumptions, risks, and opportunities.
• Analyze results against budget, forecast, and prior periods, and explain the variances and trends that matter.
• Build financial models for growth initiatives, investments, and scenario planning.
• Support branch, product, and vendor profitability analysis.
• Partner with the Accounting Manager on operating expense reporting and month-end variance analysis.

Management and Board Reporting

• Prepare the monthly and quarterly Board of Directors finance package, working with the CFO on content and messaging.
• Build leadership scorecards and KPI reporting for monthly management reviews.
• Serve as the primary report writer Blue Ops Business intelligence software, maintaining reports, dashboards, and cash forecasting outputs.

Commercial Analytics

• Build and maintain Dynamics 365 dashboards and Power BI reports on pipeline, backlog, forecast, and sales performance.
• Analyze pipeline health, coverage, aging, and conversion, and tie it to financial results and targets.
• Support General Manager and sales leadership pipeline and performance reviews.

Dynamics 365 Business Ownership

• Act as Gladwin's internal business owner of Dynamics 365, prioritizing improvements, reporting needs, and user requests.
• Oversee the internal CRM administrator and monitor data quality, adoption, and common definitions.
• Translate business needs into requirements for outside Dynamics and IT partners, and manage their priorities, testing, and documentation.
• Role boundary: Routine CRM administration and technical development stay with the internal administrator and outside partners.

Accounting and Close Support

• Back up the accounting team during month-end close, audit, and commission calculations.
• Keep accounting records and FP&A reporting consistent.
• Take on additional projects, as assigned.

Qualifications

• Bachelor's degree in Finance, Accounting, Economics, Business, or a related field.
• 3+ years of experience in FP&A, financial analysis, or business analysis.
• Strong Excel and financial modeling skills.
• Experience building dashboards, scorecards, or management reporting.
• Clear communicator who can simplify complex information for senior leaders, including the CFO.
• Demonstrated use of AI tools (e.g., ChatGPT, Claude, Copilot) to accelerate analysis, reporting, or data work, with the judgment to verify AI-generated output for accuracy
• Organized and detail-oriented, able to manage deadlines around close and reporting cycles.

Preferred

• Microsoft Dynamics 365 Sales/CRM experience, ideally as a power user or reporting lead.
• Power BI, Power Query, or FP&A platform experience (e.g., Blue Ops, Adaptive Insights).
• Experience working with outside CRM consultants, including gathering requirements and testing changes.
• Exposure to sales pipeline, revenue forecasting, or commission reporting.
• Background in manufacturing, distribution, or capital equipment.

Working Conditions

This role is based at our Menomonee Falls, WI or Fridley, MN office during standard business hours. Extended hours may be needed around month-end close, audit, and Board reporting.

This job description is intended to describe the general nature and level of work. It is not an exhaustive list of all duties and responsibilities and may be subject to change at the company's discretion.

Tagged as: CRM Administration, Excel, Financial Modeling, Forecasting, Microsoft Dynamics, Pipeline Management, Power BI