Manager - Business Analyst

We're hiring a Manager, Business Analyst to drive data-driven insights, process improvements, and strategic decision-making. This hybrid role offers exposure across multiple business functions. This role will require 5+ years of experience and will be working from our Goregaon, Mumbai office.

Key responsibilities

Show performance reporting

• Build and maintain show-level performance reporting covering revenue, cost, margin, utilisation, recoverability, realised rate and shots-in-progress against budget
• Produce weekly performance packs explaining not just what moved, but why margin moved, where bench sits, and which shows need attention
• Maintain the master KPI framework across the group — definitions, sources and calculations — covering realised rate, utilisation, efficiency, labour cost per hour, workforce mix and show margin

Rate card and economic model

• Maintain the rate-card / EBITDA model and its underlying assumptions — pricing, utilisation, efficiency, workforce mix, labour cost and Cloud cost allocation
• Translate rate-card and pricing assumptions into actionable business reporting
• Provide modelling support for bid and quoting decisions using prior show performance, resource costs and benchmarks

Group-wide finance analysis

• Produce payroll, labour-cost and people-cost analysis — by department, by location, by show
• Produce departmental cost analysis, utilisation reporting and bench analysis
• Prepare and Post monthly payroll journal ensuring payroll costs, taxes and benefits, bonuses and accruals are accurately recorded
• Support headcount reporting and analysis across UK, Montreal and Mumbai
• Surface areas of concern, variance against budget and commercial opportunity for the Commercial FD and leadership team to act on

Data and systems

• Extract, clean and integrate data from production systems (Shotgun, Ftrack or equivalent), HR and payroll systems, and Xero
• Build and maintain reporting tools in Power BI or equivalent BI platform
• Develop and improve data pipelines so that operational data flows into finance reporting with minimum manual intervention
• Document data sources, definitions and refresh cadences so the reporting is reproducible and not dependent on a single person

Commercial finance support

• Provide the Commercial FD with reforecast inputs, margin analysis and pipeline reporting
• Contribute to budgeting and planning cycles with show-level, departmental and historical labour-economics analysis
• Prepare clear, well-structured analysis to enable senior decisions — the role facilitates the challenge to producers and operations leads rather than leading it directly

Cross-team working

• Work closely with show producers and operations leads across UK, Canada and India to source the right data
• Partner with HR and payroll on people-cost reporting and headcount analysis
• Coordinate with the broader Mumbai finance team under pastoral leadership of the Senior Finance Manager

Key skills

Essential

• Strong SQL and proven experience building reporting in Power BI, Tableau or equivalent
• Advanced Excel — modelling, complex formulas, Power Query
• Demonstrable experience working with operational and financial data in a project-based, people-intensive business (VFX, post-production, animation, agency, architecture, consulting or similar)
• Understands the economic model of a service business — rate card, utilisation, realised rate, bench, labour cost — and how operational decisions translate to margin
• Finance literacy — P&L, margins, contribution, working capital — and able to connect operational data to financial outcomes
• Strong written communication; produces clear, well-structured analysis that supports senior decision-making
• Curious and self-directed — willing to dig into data to find the story rather than waiting to be told what to look for
• 5+ years' relevant experience

Desirable

• Light scripting (Python or similar) to extract and transform data from production system APIs
• Experience of Xero or similar cloud accounting platforms
• Experience of Shotgun, Ftrack or other VFX production tracking systems
• Accountancy qualification (part-qualified, qualified or qualified-by-experience)
• Exposure to creative industries, VFX, post-production, animation or media
• Experience working with payroll and HR data

Personal attributes

• Intellectually curious — wants to understand why the numbers are what they are, not just report them
• Pragmatic — comfortable building something good enough fast, then iterating
• Strong documenter — builds reproducible processes, not personal knowledge silos
• Discreet — handles sensitive payroll and people data with appropriate care
• Confident working across time zones with UK and Mumbai-based colleagues