
Finance Analyst
Blacksmith Agency
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
About the role
- Maintain and update all financial models in Google Sheets
- Build and improve revenue, margin, cash flow, and EBITDA forecasts
- Update assumptions weekly or monthly based on new sales and churn data
- Run scenario models and present the impact to leadership
- Track runway and financial safety thresholds across the business
- Produce monthly actual vs forecast variance reports
- Analyze revenue, cost, margin, and utilization trends
- Prepare dashboards for leadership that show performance against targets
- Surface early warnings when margins slip or costs increase
- Provide simple summaries that explain what happened and why
- Calculate and maintain CAC, LTV, payback period, and service line economics
- Break down profitability for projects & retainers
- Identify margin erosion and propose fixes early
- Help define our pricing and hiring triggers using data
- Build and update headcount capacity models
- Identify when we need to hire and the financial impact of hiring early or late
- Support workforce planning for PMs, developers, AEs, SDRs, and contractors
- Integrate data from QuickBooks, Salesforce, and JustWorks
- Work with our bookkeeper for clean financial inputs
- Build templates and systems to automate reporting over time
- Prepare materials for quarterly planning and leadership reviews
Requirements
- Strong experience with financial modeling and forecasting
- Advanced Google Sheets or Excel capability
- Experience analyzing P and L statements, cash flow, and margins
- Ability to create scenario models and explain assumptions
- Experience working with QuickBooks, Xero, or similar accounting software
- Strong communication skills and ability to summarize insights clearly
- Comfortable working with leadership in a fast paced environment
- Previous experience in a services or agency business is a plus
Benefits
- Health insurance
- 401(k) matching
- Flexible work hours
- Paid time off
- Remote work options
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
financial modelingforecastingscenario modelingP and L analysiscash flow analysismargin analysiscapacity modelingCAC calculationLTV calculationpayback period calculation
Soft Skills
strong communicationability to summarize insightscomfortable working with leadershipability to explain assumptionsproblem-solvinganalytical thinkingattention to detailadaptabilitycollaborationtime management