Senior FP&A Systems Analyst, Pigment
clio · Vancouver
Job description
About the role
Clio, a legal AI technology company, is hiring a Senior FP&A Systems Analyst (Pigment) in Vancouver. This is a hands-on individual contributor role reporting to the Director, FP&A Systems Strategy, who sets the systems roadmap and standards. The analyst translates documented requirements into working models, integrations and reporting inside Pigment.
Key responsibilities
- Build and maintain planning models, modules and calculation logic in Pigment across revenue, headcount, operating expense and three-statement planning, following the agreed architecture and design standards.
- Configure and maintain dimensions, hierarchies, lists and mappings (cost centers, accounts, departments, regions, entities, business units) in line with finance systems governance, including changes from reorganizations and acquisitions.
- Monitor data integrations and scheduled loads between Pigment and core systems such as NetSuite, Leapfin, Workday, Salesforce and Databricks, investigating failed loads and validating data on arrival.
- Perform recurring reconciliations with source-of-truth systems, document variances and escalate unresolved discrepancies.
- Translate requirements with FP&A business partners into model designs, then build, unit test and iterate to sign-off.
- Build reporting templates, boards and dashboards in Pigment and support downstream reporting in other tools.
- Execute test plans, coordinate user acceptance testing, log defects and track them to closure.
- Maintain model documentation, calculation logic dictionaries, change logs and runbooks.
- Support planning cycle readiness and execution, including version rollovers, actuals refreshes, scenario setup, template rollout and user access assignment.
- Provide day-to-day support and informal training to FP&A users, troubleshoot model and data questions, and raise or follow up on vendor support tickets.
Required profile
- Bachelor's degree in Finance, Accounting, Business, Information Systems or a related field, or equivalent hands-on experience.
- 5+ years of experience in FP&A, finance systems or EPM roles, including hands-on build responsibility in an enterprise planning platform; Pigment strongly preferred, with Anaplan, Adaptive, Vena, Planful or similar considered.
- Demonstrated experience building models and calculation logic rather than only administering or reporting out of a tool.
- Strong documentation discipline, attention to detail and comfort supporting non-technical finance users under time pressure.
Required skills
- Fluent FP&A content: driver-based planning, headcount planning, three-statement modeling and SaaS metrics such as ARR, churn, NRR and pipeline conversion.
- Working knowledge of how ERP, HRIS, CRM and billing data flow into planning systems (NetSuite, Workday, Salesforce, Leapfin).
- Experience configuring and troubleshooting data loads and integrations, including validation and reconciliation.
- PREFERRED: Pigment certification, full EPM implementation or migration experience, and familiarity with SQL, Python or data warehouse concepts; Databricks exposure is a plus.
What we offer
- Expected salary range of $101,700 to $137,700 CAD.
- Competitive salary with health, dental and vision insurance.
- Hybrid work, with an expectation of being in the office at least twice per week.
- Flexible time off policy, with an encouraged 20 days off per year.
- $2,000 annual counseling benefit, RRSP matching and RESP contribution.
- Clio anniversary recognition program.
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches in Canada.
Salaries by job title
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
By continuing, you accept our terms of use.
Already have an account? Login
A question about this job?
Ask it here: you will get the full job summary by e-mail, right away.
Published 1 hour ago
Expires 1 month from now
5 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
clio
Vancouver