Finance Analyst

Blacksmith Agency LLC; United States; On-site; USD 70,000 - 90,000; Full time

Job summary

A remote web design and development agency is seeking a Finance and Operations Analyst to enhance financial visibility and support decision-making as the company scales. Responsibilities include maintaining financial models, producing variance reports, and supporting financial operations. Strong skills in financial modeling, Google Sheets, and communication are essential for success in this full-time role.

Qualifications

• Strong experience with financial modeling and forecasting.
• Advanced capability in Google Sheets or Excel.
• Experience analyzing P and L statements, cash flow, and margins.

Responsibilities

• Maintain and update all financial models in Google Sheets.
• Produce monthly actual vs forecast variance reports.
• Calculate and maintain unit economics like CAC and LTV.

Skills

Financial modeling

Forecasting

Google Sheets or Excel

Communication skills

QuickBooks or similar

Tools

Google Sheets

QuickBooks

Salesforce

Job description

Blacksmith Agency is a remote web design and development agency headquartered in the United States. We are growing quickly and need a Finance and Operations Analyst who can help us build real financial visibility, forecasting discipline, and decision support as we scale.

This is a full time role. You will work directly with ownership and a fractional CFO. Your job is to keep our financial models accurate, our reporting clean, and our leadership team informed so we can grow with control and confidence.

Role Overview

You will own the internal financial systems at BSA. This includes maintaining financial models, updating forecasts, building dashboards, reviewing variances, and preparing insights for leadership. You will not handle taxes. You will work with our bookkeeper and CFO for those areas. Your role is to create clarity and help us make better decisions around spending, hiring, and growth.

Key Responsibilities

Financial Modeling and Forecasting

• 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

Reporting and Variance Analysis

• 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

Unit Economics and Profitability

• 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

Hiring and Capacity Planning

• 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

Financial Operations Support

• 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

What Success Looks Like

• We have a real time picture of where we are financially
• Our forecasts stay within 5%-10% accuracy
• Leadership gets weekly and monthly insights instead of raw data
• Hiring and spending decisions become data driven
• Profitability improves from early detection of issues
• We build a 3 to 5 year path to scale toward 10M

Required Skills and Experience

• 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

Tools We Use

• Google Sheets
• QuickBooks
• Salesforce Starter
• Looker Studio or similar BI tools
• JustWorks

How to Apply

Please include:

• A link to your resume
• Examples of financial models you have built (anonymized)
• A short Loom or written summary of how you approach forecasting and variance analysis