Senior Finance Planning & Pigment Analyst

Addepar is seeking a proactive, analytically minded Senior Finance Planning & System Analyst to drive the modernization, automation, and scalability of its global finance function. The role supports the Finance Transformation roadmap by evaluating legacy processes, redesigning driver-based planning logic, standardizing financial data architectures, and optimizing cross-functional workflows. A primary focus is serving as the in-house Pigment Builder, bridging raw financial logic and scalable system architecture to streamline budgeting, forecasting, and reporting processes.

Responsibilities

Design, build, and configure multidimensional models, metrics, dimension lists, and transaction blocks to support budgeting, forecasting, and long-range planning; Create clean, scalable items (data views, metrics, calculated properties, line items) within Pigment to automate complex financial schedules; Collaborate with IT and Data Teams to maintain integrations between Pigment, ERP systems, CRM and other planning systems; Audit existing Pigment architecture to improve calculation performance, simplify complexity, and maintain model scalability; Translate complex business rules, accounting guidelines, and FP&A models into efficient formula logic; Build real-time variance analysis dashboards (Actual vs. Budget vs. Forecast); Partner with FP&A stakeholders to standardize data structures, chart of accounts (COA) mappings, and driver assumptions across business units; Design intuitive end-user dashboards and reporting packages within Pigment for executive leadership and department heads; Serve as in-house Pigment Builder, designing, building, and deploying multidimensional applications, metrics, transaction lists, and executive dashboards to replace offline spreadsheets and disconnected legacy tools

Requirements

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); Strong understanding of financial statements (Income Statement, Balance Sheet, Cash Flow), US GAAP principles, variance reporting, and corporate FP&A workflows; Advanced proficiency in financial formula structures, relational data structures, multidimensional modeling concepts (dimensions, cubes, properties), and basic SQL or data transformation logic; Bachelor's degree in Finance, Accounting, Business Analytics, Information Systems, or a related field; 3+ years of experience in FP&A, Financial Modeling, or Financial Systems Administration (with direct experience building in cloud EPM/CPM platforms); Ability to translate complex finance requirements into technical model logic and explain system capabilities to non-technical business partners; Applicants must have legal authorization to work in the country where the role is based on the first day of employment; Applicants must be based in British Columbia, Alberta, Saskatchewan, Manitoba, or Ontario

Benefits

bonus; equity; benefits (compensation includes base salary, bonus, equity, and benefits)