Senior Finance Planning, Pigment Analyst

This is a fully remote position, open to applicants in Canada.

📋 Description

• Lead the modernization, automation, and scalability efforts of Addepar’s global finance department.

• Implement the Finance Transformation roadmap.

• Assess legacy processes and redesign planning logic based on drivers.

• Standardize financial data architectures while enhancing cross-functional workflows.

• Develop, configure, and maintain Pigment blocks, metrics, transactions, applications, and dashboards.

• Design, build, and deploy multidimensional Pigment applications, metrics, transaction lists, and executive dashboards.

• Create models, metrics, dimension lists, and transaction blocks for budgeting, forecasting, and long-range planning.

• Generate scalable Pigment items to automate financial schedules, including headcount planning, revenue recognition, capital expenditures, and working capital.

• Work closely with IT and Data Teams to ensure Pigment integrations with ERP, CRM, and other planning systems are maintained.

• Audit and enhance Pigment architecture for optimal performance, simplicity, and scalability.

• Convert business rules, accounting guidelines, and FP&A models into formula logic.

• Develop real-time dashboards for Actual vs. Budget vs. Forecast variances.

• Standardize data structures, chart-of-accounts mappings, and driver assumptions across various business units.

• Create reporting packages and dashboards tailored for executive leadership and department heads.

⛳️ Requirements

• Must have legal authorization to work in Canada starting from the first day of employment; visa sponsorship is not available.

• Demonstrated hands-on experience in building, modeling, and configuring items within Pigment, or similar experience with Anaplan / Adaptive Planning / Jedox, with a successful transition to Pigment.

• Strong grasp of financial statements, US GAAP principles, variance reporting, and corporate FP&A workflows.

• Advanced knowledge of financial formula structures, relational data structures, and multidimensional modeling concepts.

• Basic proficiency in SQL or data transformation logic.

• Bachelor’s degree in Finance, Accounting, Business Analytics, Information Systems, or a related discipline.

• Over 3 years of experience in FP&A, Financial Modeling, or Financial Systems Administration, with direct involvement in building within cloud EPM/CPM platforms.

• Capability to translate complex financial requirements into technical model logic and articulate system functionalities to non-technical business partners.

• Comprehensive understanding of how metrics and data blocks interrelate across applications.

• Strong emphasis on data integrity, governance, and auditability within model structures.

• Proficient in troubleshooting formula logic, identifying model bottlenecks, and optimizing workflows.

🏝️ Benefits

• Bonus

• Equity

• Benefits

• Reasonable accommodations for individuals with disabilities

• Equal opportunity and inclusive workplace