Financial Analyst

Location: Boise, ID (hybrid- 3 days on site) or remote in the MST or PST time zones

Reports To: Aquent Studios Director of Finance

Employment Type: Full-Time

Salary $75-95,000 plus full benefits

Job Summary

We seek an analytical and detail-oriented Financial and Data Analyst to drive financial planning, performance tracking, and data-driven decision-making. This role involves analyzing financial and operational data, identifying trends, and delivering actionable insights to senior leadership. The ideal candidate will excel in financial modeling, data visualization, and cross-functional collaboration to enhance forecasting, resource utilization, and business performance.

Key Responsibilities

Financial Analysis and Performance Tracking

Track and analyze company-wide performance against budget and forecast, identifying variances, risks, and opportunities.

Conduct deep-dive financial reviews to support strategic decisions, including project and individual-level gross profit assessments.

Assist in monthly close activities, breaking down performance by client, industry, and sub-industry to identify growth and efficiency opportunities.

Resource Utilization and Forecasting

Analyze resource utilization trends to optimize allocation and improve forecasting accuracy through week-to-week monitoring.

Support client-level financial forecasting to enhance revenue and resource planning.

Audit monthly billable staff allocation to align with financial objectives.

Data Visualization and Reporting

Designed and maintained dynamic Tableau dashboards and reports to provide real-time visibility into key performance indicators for senior leadership.

Deliver timely, insightful ad-hoc financial reports to support strategic discussions.

Cross-Functional Collaboration and Process Improvement

Partner with Accounting, Accounts Receivable, and Analyst teams to improve financial reporting, headcount tracking, and business processes (e.g., utilization, bill rates).

Support bid model refinements for data-driven pricing and planning in new business opportunities.

Audit and Payroll Support

Gather and organize financial documents for annual audits, providing context and clarification to auditors.

Prepare payroll cost analyses to support workforce planning and recommend labor cost optimization strategies.

Professional Integrity

Maintain confidentiality, discretion, and reliability in all financial matters.

Qualifications & Skills

Education

Bachelor’s degree in Finance, Accounting, Economics, Data Analytics, or related field.

Experience

3+ years in financial analysis, data analytics, or FP&A.

Essential Technical Skills

Advanced Excel (pivot tables, complex formulas)

Tableau (dashboard creation, data visualizations)

Soft Skills

Knowledge of SQL/Python (preferred but not required)

Strong analytical and problem-solving abilities

Excellent communication and presentation skills

Ability to explain financial concepts to non-finance teams

Experience in professional services, consulting, or agency environments.

Familiarity with project-based financial metrics (utilization, realization rates).

Client Description

Aquent Studios is a global creative studio that delivers scale, speed and efficiency to the world’s most recognized brands. We create the work that matters the most to them—work that has a real impact on their business. As an Aquent Studio team member, you’ll have the opportunity to engage with the largest and most influential companies in the world, solving design challenges and extending their brands across tactic types and platforms, including digital design, UI/UX, video, motion, content, print design, web development, and more. If you want to do work that matters in a collaborative setting that values ingenuity and personal growth, you have found the right place!