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)
Knowledge of SQL/Python (preferred but not required)
Soft Skills
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).
#LI-DP1
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!