Consulting Operations Analyst
$76,000–$100,000 year
HybridProvo, Utah, United States
Job Summary
Analyze project financial, operational, and resource data to identify trends, risks, and inconsistencies impacting revenue forecasts and business performance. Validate project assumptions, reconcile engagement leader projections with underlying data, and provide leadership with prioritized recommendations for corrective action. Serve as a Kantata power user supporting system administration, reporting, and data governance while developing executive dashboards, KPIs, and automated reporting solutions using Excel, Power Query, and VBA. Partner with Finance, Sales, and Operations teams on budgeting, forecasting, and continuous process improvement to streamline operations and improve data quality.
Required Qualifications
- 5+ years of experience in Financial Planning & Analysis (FP&A), Consulting Operations, Business Operations, Business Systems, Financial Analytics, or a related analytical function
- Advanced to expert-level Microsoft Excel skills, including complex formulas, data modeling, pivot tables, Power Query, reporting automation, dashboard development, and VBA/macros
- Demonstrated experience developing executive dashboards, KPIs, and automated reporting solutions that drive business decision-making
- Proven ability to analyze large project portfolios and translate financial, operational, and resource data into actionable business insights
- Strong financial acumen with experience supporting forecasting, budgeting, revenue analysis, profitability analysis, and performance reporting
- Exceptional analytical, organizational, problem-solving, and communication skills, with a high level of attention to detail
- Ability to manage multiple priorities and meet deadlines in a fast-paced, highly collaborative environment
- Bachelor's degree in Finance, Accounting, Business Analytics, Information Systems, Economics, Business Administration, or a related field
- Experience with Kantata (formerly Mavenlink) and Dynamic Insights
- Experience with Power BI, Tableau, or other business intelligence and data visualization tools
Desired Qualifications
- Experience with professional services, consulting, or project-based organizations
- Experience with Kantata (formerly Mavenlink) and Dynamic Insights preferred
- Experience with Power BI, Tableau, or other business intelligence and data visualization tools is a plus
- Experience with comparable project management and professional services automation (PSA) platform experience
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.