About the role

Pigment FP&A Systems Analyst building enterprise planning models, integrations, and dashboards. Supporting Clio’s FP&A cycles as the legal AI company scales.

Responsibilities

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

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

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