Senior FP&A Systems Analyst, Pigment

Clio - Cloud-Based Legal Technology

. Build and maintain planning models, modules, and calculation logic in Pigment across revenue, headcount, operating expense, and three-statement planning .

Posted 10/26/2026full-timeVancouver • CanadaSenior💰 CA$101,700 - CA$137,700 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in building and maintaining financial planning models and calculation logic within Pigment, along with strong capabilities in data integration, validation, and reconciliation processes. Proficient in supporting FP&A functions through effective communication and documentation practices.

Highest-signal resume keywords

Pigment Model DevelopmentFinancial Planning & Analysis (FP&A)Data Integration & TroubleshootingDocumentation & Attention to DetailDriver-Based Planning & SaaS Metrics

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Model BuildingCalculation LogicDimensionalityFormulasMappingsData FlowsSQLPythonData Warehouse ConceptsThree-Statement Modeling

Soft Skills

Clear CommunicationAttention to DetailSupport Under PressureTraining & Support

Tools & Technologies

PigmentNetSuiteLeapfinWorkdaySalesforceDatabricksERP SystemsHRIS SystemsCRM Systems

Certifications & Qualifications

Pigment Certification

Industry Keywords

Enterprise Planning PlatformEPM ImplementationRevenue Data StructuresHeadcount PlanningSaaS MetricsChange Control Processes

Tech Stack

Tools & technologies

ERPPythonSQL

About the role

Key responsibilities & impact

Build and maintain planning models, modules, and calculation logic in Pigment across revenue, headcount, operating expense, and three-statement planning
Configure and maintain dimensions, hierarchies, lists, and mappings for cost centers, accounts, departments, regions, entities, and business units
Monitor data integrations and scheduled loads between Pigment and NetSuite, Leapfin, Workday, Salesforce, and Databricks
Investigate failed loads and validate incoming data
Perform recurring reconciliations between Pigment and source-of-truth systems
Document variances and escalate unresolved discrepancies
Translate FP&A requirements into model designs; build, unit test, and iterate to sign-off
Build and maintain reporting templates, boards, and dashboards in Pigment
Support downstream reporting using planning data
Execute test plans and coordinate user acceptance testing with FP&A stakeholders
Log defects and track them to closure
Maintain model documentation, calculation logic dictionaries, change logs, and support 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 end users during planning cycles
Troubleshoot model and data questions
Surface platform limitations and enhancement requests
Raise or follow up on vendor support tickets

Requirements

What you’ll need

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; Anaplan, Adaptive, Vena, Planful, or similar considered as adjacent experience
Demonstrated experience building models and calculation logic, including dimensionality, formulas, mappings, and data flows
Fluency with driver-based planning, headcount planning, three-statement modeling, and SaaS metrics such as ARR, churn, NRR, and pipeline conversion
Working knowledge of ERP, HRIS, CRM, and billing or revenue data structures and flows into planning systems
Experience configuring and troubleshooting data loads and integrations, including validation checks and source reconciliation
Strong documentation discipline and attention to detail
Ability to work within standards, naming conventions, and change control processes
Ability to support non-technical finance users under time pressure during active planning cycles
Clear written and verbal communication
Pigment certification, or experience on a Pigment/Anaplan implementation or migration, preferred
Experience through a full EPM implementation or migration off Excel or a legacy planning tool, preferred
Familiarity with SQL, Python, or data warehouse concepts; Databricks exposure is a plus

Benefits

Comp & perks

Competitive, equitable salary
Top-tier health benefits
Dental insurance
Vision insurance
Hybrid work environment
Flexible time off policy, with an encouraged 20 days off per year
$2000 annual counseling benefit
RRSP matching
RESP contribution
Clioversary recognition program with special acknowledgement at 3, 5, 7, and 10 years
Accessibility accommodations during the recruitment process