Senior Finance Planning & Pigment Analyst

Addepar

Ottawa

Hybrid

CAD 110,000 - 150,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Global Hybrid Workforce
Flexible Time Off
Benefits Packages
Learning & Development Allowance
Dynamic Team

Job summary

Addepar is seeking a proactive Senior Finance Planning & System Analyst to drive modernization, automation, and scalability of our global finance function. You will bridge financial strategy with scalable Pigment-based system architecture, building models, blocks, and dashboards to streamline budgeting, forecasting, and reporting.

You will collaborate with FP&A, accounting, IT, and data teams to standardize data architectures, redesign planning logic, and optimize cross-functional workflows,

Qualifications

  • Pigment expertise: hands-on experience building, modeling, and configuring items.
  • Data & Excel: advanced proficiency in financial formulas, relational data, and multidimensional modeling.
  • FP&A / Accounting core: strong understanding of financial statements, US GAAP, variance reporting, and FP&A workflows.
  • Communication: translate complex finance requirements into technical model logic for non-technical partners.
  • Education: Bachelor's degree in Finance, Accounting, Business Analytics, IS, or related field.
  • Experience: 3+ years in FP&A, Financial Modeling, or Financial Systems Admin with cloud EPM/CPM experience.
  • Problem solver: ability to troubleshoot formula logic, identify bottlenecks, optimize workflows.
  • Architect mindset: holistic thinking on metric/data interconnect across apps.
  • Data hygiene: focus on data integrity, governance, and auditability.

Responsibilities

  • Model multidimensional Pigment models, metrics, and transactions to support budgeting, forecasting, and long-range planning.
  • Design scalable Pigment items (views, metrics, properties, line items) for automating schedules like headcount and revenue recognition.
  • Collaborate with IT and Data teams to maintain Pigment integrations with ERP, CRM, and other planning systems.
  • Audit Pigment architecture to improve calculation performance, reduce complexity, and keep models scalable.
  • Translate financial rules into efficient formula logic and real-time variance dashboards (Actual vs Budget vs Forecast).
  • Standardize data structures and COA mappings across business units; design end-user dashboards for leadership.

Skills

Pigment
Data & Excel
FP&A/Accounting
Communication
Problem solving
Architect mindset
Data governance

Education

Bachelor's degree

Tools

Pigment
SQL basics
ERP integrations

Job description

  • Addepar is seeking a proactive, analytically minded Senior Finance Planning & System Analyst to drive the modernization, automation, and scalability of our global finance function
  • In this role, you will play a central part in executing our broader Finance Transformation roadmap—evaluating legacy processes, redesigning driver-based planning logic, standardizing financial data architectures, and optimizing cross-functional workflows
  • A primary focus of this position will be serving as our in-house Pigment Builder
  • You will act as the bridge between raw financial logic and scalable system architecture
  • You will be directly responsible for building, configuring, and maintaining Pigment items (such as blocks, metrics, transactions, applications, and dashboards) to streamline our budgeting, forecasting, and reporting processes
  • You will design, build, and deploy multidimensional applications, metrics, transaction lists, and executive dashboards in Pigment to replace offline spreadsheets and disconnected legacy tools
  • The ideal candidate pairs strong FP&A and accounting principles with hands-on systems architecture skills to bridge the gap between financial strategy and technological implementation
  • Pigment Development & System Architecture
  • Model Building: Design, build, and configure multidimensional models, metrics, dimension lists, and transaction blocks to support budgeting, forecasting, and long-range planning
  • Item & Workflow Design: Create clean, scalable items (data views, metrics, calculated properties, line items) within Pigment to automate complex financial schedules (e.g., headcount planning, revenue recognition, capex, working capital)
  • Integration & Maintenance: Collaborate with IT and Data Teams to maintain integrations between Pigment, ERP systems, CRM and other planning systems
  • Optimization: Audit existing Pigment architecture to improve calculation performance, simplify complexity, and maintain model scalability
  • Financial Analysis & Business Partnering
  • Financial Modeling: Translate complex business rules, accounting guidelines, and FP&A models into efficient formula logic
  • Variance & Driver Analysis: Build real-time variance analysis dashboards (Actual vs. Budget vs. Forecast) to enable fast business decision-making
  • Process Standardisation: Partner with FP&A stakeholders to standardize data structures, chart of accounts (COA) mappings, and driver assumptions across business units
  • Reporting & Dashboards: Design intuitive end-user dashboards and reporting packages within Pigment for executive leadership and department heads
Benefits
  • Equity: Stretch the idea of ownership beyond your day-to-day and take pride in being an owner in the growth of Addepar
  • Global Hybrid Workforce: Whether you work remotely or on-site, you’ll have the opportunity to build and collaborate with colleagues around the world
  • Flexible Time Off: Spend time traveling, celebrating with friends and family or relax on your schedule
  • Benefits Packages: Competitive medical, dental and vision benefits along with a monthly wellness allowance to keep you healthy and happy
  • Learning & Development Allowance: Your continued growth and development are important to us
  • Dynamic Team: Strong investment in the best talent at the intersection of technology and finance
  • Pigment Expertise: Proven hands-on experience building, modeling, and configuring items within Pigment (or equivalent Anaplan / Adaptive Planning / Jedox platforms with a track record of transitioning to Pigment)
  • Data & Excel Skills: Advanced proficiency in financial formula structures, relational data structures, multidimensional modeling concepts (dimensions, cubes, properties), and basic SQL or data transformation logic
  • FP&A / Accounting Core: Strong understanding of financial statements (Income Statement, Balance Sheet, Cash Flow), US GAAP principles, variance reporting, and corporate FP&A workflows
  • Communication: Ability to translate complex finance requirements into technical model logic and explain system capabilities to non-technical business partners
  • Education: Bachelor’s degree in Finance, Accounting, Business Analytics, Information Systems, or a related field
  • Experience: 3+ years of experience in FP&A, Financial Modeling, or Financial Systems Administration (with direct experience building in cloud EPM/CPM platforms)
  • Problem Solver: Enjoys troubleshooting formula logic, identifying model bottlenecks, and optimizing workflows
  • Architect Mindset: Thinks holistically about how individual metrics and data blocks interconnect across applications
  • Data Hygiene: Strong focus on data integrity, governance, and auditability within model structures
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior FP&A Systems Analyst, Pigment
Senior FP&A Systems Analyst, Pigment

Clio • Toronto

Hybrid
CAD 102,000 - 138,000
Competitive salary and benefits
Hybrid work environment
Flexible time off (20 days)
+1
Senior Finance Planning & Pigment Analyst
Senior Finance Planning & Pigment Analyst

Addepar • Canada

Remote
CAD 100,000 - 125,000
Senior FP&A Systems Analyst, Pigment
Senior FP&A Systems Analyst, Pigment

Clio • Vancouver

Hybrid
CAD 102,000 - 138,000
Health benefits
Dental insurance
Vision insurance
+6
Senior FP&A Systems Analyst, Pigment
Senior FP&A Systems Analyst, Pigment

Clio • Calgary

Hybrid
CAD 102,000 - 138,000
Health benefits
Dental insurance
Vision insurance
+6
Senior Pigment FP&A Model Architect - Remote
Senior Pigment FP&A Model Architect - Remote

Clio • Calgary

Hybrid
CAD 102,000 - 138,000
Health benefits
Dental insurance
Vision insurance
+6
Pigment Solution Architect
Pigment Solution Architect

Clearsulting • Toronto

Hybrid
CAD 118,000 - 150,000
Medical coverage
Unlimited PTO
Parental leave
+6
Mid Market Account Executive
Mid Market Account Executive

Pigment • Toronto

On-site
CAD 282,000 - 345,000
Stock options
Generous time off
Parental leave
+2
Senior FP&A Systems Analyst, Pigment
Senior FP&A Systems Analyst, Pigment

Clio • Vancouver

Hybrid
CAD 102,000 - 138,000
Hybrid work environment in Vancouver/2
Competitive salary with total rewards
Health benefits
+1
Product Support Specialist Team Lead
Product Support Specialist Team Lead

Pigment • Toronto

Hybrid
CAD 85,000 - 100,000
Competitive compensation
Generous time off
High-end equipment
Senior Manager, Financial Systems & Data Analytics
Senior Manager, Financial Systems & Data Analytics

EQ Bank • Toronto

On-site
CAD 120,000 - 180,000