Finance Analyst

Summary

Blacksmith Agency is a remote web design and development agency headquartered in the United States. They are seeking a Finance and Operations Analyst to help build financial visibility and support decision-making as the company scales. The role involves maintaining financial models, preparing reports, and providing insights to leadership.

Responsibilities

• 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, and PPC
• 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

Skills

• 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

Qualifications

Must Haves

• 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

Nice to Haves

• Previous experience in a services or agency business is a plus