Addepar - Senior Finance Planning & Pigment Analyst
Requirements
• 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). • Pigment Expertise: • 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. • FP&A / Accounting Core: • 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. • Professional Background • Education: Bachelor’s degree in Finance, Accounting, Business Analytics, Information Systems, or a related field. • Education: • Experience: 3+ years of experience in FP&A, Financial Modeling, or Financial Systems Administration (with direct experience building in cloud EPM/CPM platforms). • Communication: Ability to translate complex finance requirements into technical model logic and explain system capabilities to non-technical business partners. • Communication: • Key Competencies & Behaviors • Architect Mindset: Thinks holistically about how individual metrics and data blocks interconnect across applications. • Architect Mindset: • Data Hygiene: Strong focus on data integrity, governance, and auditability within model structures. • Data Hygiene: • Problem Solver: Enjoys troubleshooting formula logic, identifying model bottlenecks, and optimizing workflows. • Problem Solver: • Addepar takes a market-based approach to pay. A successful candidate's starting pay will be determined based on the role, job-related skills, experience, qualifications, work location, and market conditions. • The range displayed on each job posting reflects the minimum and maximum target base salary for this role within Canada. • Compensation for this role includes base salary + bonus + equity + benefits. • Your recruiter can share more about the specific salary range during the hiring process. Additionally, these ranges reflect the base salary only, and do not include bonus, equity, or benefits. Applicants must be based in British Columbia, Alberta, Saskatchewan, Manitoba, or Ontario.
Responsibilities
• 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. • Model Building: • 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). • Item & Workflow Design: • Integration & Maintenance: Collaborate with IT and Data Teams to maintain integrations between Pigment, ERP systems, CRM and other planning systems. • Integration & Maintenance: • Optimization: Audit existing Pigment architecture to improve calculation performance, simplify complexity, and maintain model scalability. • Optimization: • Financial Analysis & Business Partnering • Financial Modeling: Translate complex business rules, accounting guidelines, and FP&A models into efficient formula logic. • Financial Modeling: • Variance & Driver Analysis: Build real-time variance analysis dashboards (Actual vs. Budget vs. Forecast) to enable fast business decision-making. • Variance & Driver Analysis: • Process Standardisation: Partner with FP&A stakeholders to standardize data structures, chart of accounts (COA) mappings, and driver assumptions across business units. • Process Standardisation: • Reporting & Dashboards: Design intuitive end-user dashboards and reporting packages within Pigment for executive leadership and department heads. • Reporting & Dashboards:
Benefits
• $100,000—$125,000 CAD • Our Values • Act Like an Owner - Think and operate with intention, purpose and care. Own outcomes. • Act Like an Owner - • Build Together - Collaborate to unlock the best solutions. Deliver lasting value. • Build Together - • Champion Our Clients - Exceed client expectations. Our clients’ success is our success. • Champion Our Clients - • Drive Innovation - Be bold and unconstrained in problem solving. Transform the industry. • Drive Innovation - • Embrace Learning - Engage our community to broaden our perspective. Bring a growth mindset. • Embrace Learning -
Apply in one click
Upload My Resume
Drop here or click to browse · Tap to choose · PDF, DOCX, DOC, RTF, TXT