Revenue and Commissions Analyst

Guardian Security Systems•Seattle, WA

3d•$75,000 - $90,000•Remote

About The Position

The Financial Analyst supports revenue, commissions, and month-end close activities, while building reporting models and improving financial processes and controls. This role develops and maintains financial reporting models and dashboards to drive insights, strengthens internal controls and process efficiencies, and partners cross-functionally with Sales, Operations, and IT to ensure financial data integrity and alignment with business objectives.

Requirements

Proven ability to build revenue and commissions models and calculation workbooks using advanced Excel logic
Takes ownership of financial reporting and commission work and follows through with accuracy and consistency.
Approaches discrepancies with curiosity, logic, and a problem‑solving mindset.
Works carefully and thoughtfully with compensation data and pay‑related details.
Partners easily with Payroll and Sales to keep things aligned.
Explains commission information in a calm, clear, and respectful way.
Stays organized, manages recurring cycles well, and works independently.
Handles sensitive compensation information with high level of discretion, care and professionalism.
2–4+ years of experience in finance, accounting and commissions processing
Bachelor’s degree in Accounting or Finance
Advanced Excel skills (formulas, lookups, data validation, power query, macros)
Working knowledge of SQL and Power BI
Strong attention to detail and comfort working with numbers, calculations, and deadlines
Experience working cross‑functionally with Sales, Payroll, and IT
Experience supporting sales commissions or variable compensation
MS Office Suite – comfortable with Outlook and Microsoft Word
MS Excel – higher than average knowledge, comfortable with pivot tables, VLOOKUP’s, macros and formulas
Working knowledge of SQL

Responsibilities

Calculate and book monthly/quarterly commission accruals, ensuring accurate payment processing and alignment with sales plans.
Assist in designing and reviewing commission structures to align with company growth targets.
Review customer contracts to ensure proper revenue recognition for multi-element arrangements, including recurring monthly revenue and the management of deferred revenue and contract assets.
Calculate, record, and amortize deferred commission assets related to contract acquisition costs.
Support and execute month-end close processes related to revenue, COGS and operating expenses; analyze variances to ensure accurate and timely financial reporting.
Build, maintain, and enhance financial reporting models and dashboards to support forecasting, budgeting, and performance analysis, ensuring accuracy and usability for decision-making.
Design and maintain internal controls for revenue and commissions, implementing efficiencies to streamline workflows.
Collaborate with Sales, operations and IT to ensure commission plans and contract terms are accurately reflected in financial systems.

Benefits

Low-cost medical insurance
Low-cost dental Insurance
Vision and Life Insurance premiums paid for by Guardian
401(k) with company match after 1 year
Sick Time
Paid Time Off that builds with tenure + an additional 8 paid holidays
Employee assistance program (EAP)
Health Reimbursement Arrangement (HRA)
Flexible spending account (FSA)
AD&D insurance
Tuition reimbursement/PAID Professional Development PTO (24 hours that renews every year!)
Early release Fridays during the summer months!