Senior FP&A Systems Analyst, Pigment

Themis Solutions Inc.; Burnaby; Hybrid; CAD 102.000 - 138.000; Vollzeit

Benefits dieser Stelle

Hybrid work environment

Health benefits

RRSP matching & RESP contributions

Counseling benefit

20 days off per year

Zusammenfassung

Clio is seeking a Pigment Model Builder to design, build, and maintain planning models within Pigment for its FP&A organization. This hands-on role reports to the Director, FP&A Systems Strategy and focuses on translating requirements into working models, data integrations, and reports.

You will work with NetSuite, Leapfin, Workday, Salesforce, and Databricks; build calculations, document changes, support planning cycles, and deliver dashboards.

Qualifikationen

• 5+ years of FP&A, finance systems, or EPM roles, including hands-on build responsibility in an enterprise planning platform.
• Bachelor's degree or equivalent hands-on experience in related field.
• Experience building models and calculation logic in an enterprise planning tool.

Aufgaben

• 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, and mappings in line with master data standards.
• Understand and monitor data integrations between Pigment and core systems (NetSuite, Leapfin, Workday, Salesforce, Databricks) and validate data on arrival.
• Translate requirements into model designs and build, test, and iterate to sign-off.
• Build and maintain reporting templates, boards, and dashboards in Pigment and support downstream reporting.

Kenntnisse

FP&A experience

Model building

Data integration

Communication with finance

Ausbildung

Bachelor's degree in Finance/Accounting/Business

Tools

Pigment

Anaplan

Adaptive

Vena

Planful

Jobbeschreibung

Clio is the global leader in legal AI technology, empowering legal professionals and law firms of every size to work smarter, faster, and more securely. We are transforming the legal experience for all by bettering the lives of legal professionals while increasing access to justice.

Clio is hiring a Pigment Model Builder to design, build, and maintain the planning models that our FP&A organization runs on. This is a hands‑on individual contributor role reporting to the Director, FP&A Systems Strategy. The Director sets the systems roadmap, standards, and prioritization; this role does the building – translating documented requirements into working models, integrations, and reporting inside Pigment. The ideal candidate is someone who has spent real time inside an enterprise planning platform doing configuration and calculation work, not just consuming reports out of one. They are comfortable working within an established architecture and change process, fluent enough in FP&A content to build models that hold up under scrutiny, and patient with finance users during peak planning cycles.

RESPONSIBILITIES

• Build and maintain planning models, modules, and calculation logic in Pigment across revenue, headcount, operating expense, and three‑statement planning, following the agreed upon architecture and design standards.
• Configure and maintain dimensions, hierarchies, lists, and mappings – cost centers, accounts, departments, regions, entities, and business units – applying the master data standards defined by the broader finance systems governance process, including changes driven by reorganizations and newly acquired entities.
• Understand and monitor data integrations and scheduled loads between Pigment and core systems including NetSuite, Leapfin, Workday, Salesforce, and Databricks; monitor jobs, investigate failed loads, and validate data on arrival.
• Perform recurring reconciliations between Pigment and source‑of‑truth systems, document variances, and elevate unresolved discrepancies.
• Translate requirements documented in partnership with the FP&A business partners into model designs, then build, unit test, and iterate to sign‑off.
• Build and maintain reporting templates, boards, and dashboards in Pigment, and support downstream reporting in tools where planning data is consumed.
• 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 in line with established documentation standards.
• Support planning cycle readiness and execution – version rollovers, actuals refreshes, scenario setup, template rollout, and user access assignment for budget, forecast, and close cycles.
• Provide day‑to‑day support and informal training to FP&A end users during planning cycles, troubleshooting model and data questions as they arise.
• Surface platform limitations, enhancement requests, and vendor‑side defects, and raise or follow‑up on vendor support tickets as directed.

REQUIREMENTS

• 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 – dimensionality, formulas, mappings, and data flows – rather than only administering or reporting out of a planning tool.
• Able to work fluently with core FP&A content, including 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 or revenue data is structured and flows into planning systems (NetSuite, Workday, Salesforce, Leapfin, or equivalents).
• Experience configuring and troubleshooting data loads and integrations, including validation checks and reconciliation to source.
• Strong documentation discipline and attention to detail, with the ability to work inside standards, naming conventions, and change control processes set by others.
• Comfortable supporting non‑technical finance users under time pressure during active planning cycles.
• Clear written and verbal communication, with the ability to explain model behavior to finance stakeholders and technical constraints to non‑technical partners.

PREFERRED QUALIFICATIONS

• Pigment certification, or experience on a Pigment/Anaplan implementation or migration.
• Experience through a full EPM implementation or a migration off Excel or a legacy planning tool.
• Familiarity with SQL, Python, or data warehouse concepts; exposure to Databricks is a plus.

#LI‑Remote

The role is a backfill for an existing position.

What you will find here

• Competitive, equitable salary with top‑tier health benefits, dental, and vision insurance
• Hybrid work environment, with expectation for local Clions (Vancouver, Calgary, Toronto, Dublin, London, New York City and Sydney) to be in office min. twice per week.
• Flexible time off policy, with an encouraged 20 days off per year.
• $2000 annual counseling benefit RRSP matching and RESP contribution
• Clioversary recognition program with special acknowledgement at 3, 5, 7, and 10 years
• The expected salary range for this role is $101,700 to $137,700 CAD. Initial placement within the range is informed by geographic region, experience, and skillset, with room to progress as impact and tenure grow. Final offer amounts will vary based on candidate profile.

Diversity, Inclusion, Belonging and Equity (DIBE) & Accessibility

Our team shows up as their authentic selves, and are united by our mission. We are dedicated to diversity, equity and inclusion. We pride ourselves in building and fostering an environment where our teams feel included, valued, and enabled to do the best work of their careers, wherever they choose to log in from. We believe that different perspectives, skills, backgrounds, and experiences result in higher‑performing teams and better innovation. We are committed to equal employment and we encourage candidates from all backgrounds to apply. Clio provides accessibility accommodations during the recruitment process. Should you require any accommodation, please let us know and we will work with you to meet your needs.

Learn more about our culture at clio.com/careers We're a Human and High Performing AI company, meaning we use artificial intelligence to improve all of our operations. In recruitment, AI helps us streamline the process for greater efficiency. However, we've built our systems to ensure that a human always reviews AI‑generated output, and we never make automated hiring decisions. Disclaimer: We only communicate with candidates through official @clio.com email addresses.

About Clio

Clio is on a mission to transform the legal experience for all. Clio is the global leader in legal AI, building the platform that powers the future of legal work. With the scale, data, and ambition to redefine how the legal industry operates, we are advancing a comprehensive strategy that spans the full lifecycle of legal work—from knowledge and insight to execution and outcomes. At the center of this vision is the Intelligent Legal Work Platform, the legal industry’s first System of Action. By combining Clio’s core product suite with Clio Work and AI‑native capabilities, the platform turns information into insight and insight into action. As we expand into the enterprise, Clio for Enterprise extends this foundation to support the complexity, scale, and operational rigor of global organizations through solutions like Clio Operate and Vincent by Clio. Backed by industry‑leading data and intelligence, Clio is building the infrastructure that enables legal teams to operate with greater speed, confidence, and impact. Clio’s leadership and momentum have been recognized globally. In 2022, we achieved Centaur status, a milestone reached by fewer than 200 private SaaS companies worldwide. We are a proud honoree of the Forbes Cloud 100 and Fortune’s Future 50, have been named Innovator of the Year, and are a Platinum Club member of Canada’s Best Managed Companies. We are consistently recognized as one of Canada’s Top 100 Employers and a Top Employer for Young People, with our international offices also earning placements on Great Place to Work’s Best Workplaces lists. Headquartered in Vancouver, Canada, Clio has grown to more than 2,000 employees across offices in Toronto, Calgary, Dublin, Manchester, Sydney, Barcelona, and Bogotá—bringing together diverse perspectives to solve one of the world’s most complex and impactful professional challenges. Join Clio and help define the future of legal work through AI. Learn more at clio.com/careers.