Pigment Consultant (Contract)

Ascend Partners is the Diamond Standard in EPM Advisory & Delivery. From our headquarters in New York, NY, we work with finance, planning and data leaders across North America to choose, build and run the systems they depend on. Our experienced teams help clients close faster, plan with confidence and trust their numbers, on whichever platform best fits their needs.

Ascend’s proven methodology and deep product knowledge underpin our EPM practices and have earned us recognition as an award-winning OneStream Diamond Partner. InnoFin operates as our Oracle practice, drawing on extensive platform expertise and Gold Partner credentials to guide each implementation.

This is a contract role for a Pigment Consultant. The Pigment Consultant is responsible for delivering Pigment solutions for Ascend clients from design through handover, including running workshops, writing requirements, overseeing the model build, testing, and handing the model over to the client. Pigment projects are delivered in short, Agile cycles, and AI does a growing share of the model build, so the Pigment Consultant reviews and approves what the AI builds.

The Pigment Consultant works directly with client finance users and administrators, builds with the client, and transfers knowledge throughout the engagement so the client is able to run the model. The Pigment Consultant is expected to be senior in Pigment, to work independently, and to support more than one client at a time.

Position Responsibilities

•    Gather requirements and turn workshop output into user stories with acceptance criteria that can be tested
•    Lead design workshops and sprint demos with client finance teams
•    Design Pigment solutions, splitting the work into Applications and applying Pigment best practices for scale
•    Design Pigment models, and build them or oversee the AI build, including Metrics, Lists and dimensions, Tables, Boards, and Views
•    Use Pigment's AI agents, including the Modeler Agent, to accelerate the model build, and judge when a Frame is a better fit than a Board
•    Write clear build specifications for each user story so the AI can build it
•    Review models built by the AI and catch formula errors, performance problems, and security gaps before approving them
•    Set up data integrations, roles and access rights, AI data access settings, and automated data loads
•    Design tests and run user acceptance testing with the client
•    Run delivery in an Agile, iterative way, with sprints, frequent demos, backlog management, and changes in scope as they come
•    Build with the client, working live in the model with client administrators and transferring knowledge throughout so the client is able to run the model
•    Put working prototypes in front of finance users early, and help the client rethink their process rather than copy their spreadsheets
•    Apply FP&A knowledge, including driver-based P&L, opex, rolling forecasts, and budget cycles, to inform solution design
•    Document decisions, the reasoning behind design choices, and handover material
•    Own design, build oversight, testing, and handover end-to-end, without needing a separate technical team
•    Support two or more clients at once, each at a different stage
•    Represent Ascend on client work and follow Ascend's delivery method and documentation standards, without independently selling into the account
•    Maintain current Pigment certifications and keep them current as new ones are released
•    Travel to client sites only if a client requires it
•    All other duties as assigned

Position Outcomes/Objectives and Standards of Performance

1.   Ensures Pigment solutions are designed, built, and handed over successfully.

Delivery for all assigned client engagements is completed on schedule and meets the agreed-upon expectations as outlined to the client. Models are accurate, perform well at scale, and are secure, as confirmed by client feedback.

2.   Ensures models built by AI are reviewed and approved with care.

Everything the AI builds is reviewed before it is approved. Formula errors, performance problems, and security gaps are caught before approval, and models are tested through user acceptance testing with the client.

3.   Effectively manages relationships with clients and leaves them able to run their models.

Feedback from clients indicates overall satisfaction with workshops, demos, and communication. Knowledge transfer and handover material leave the client's administrators able to run the model on their own.

4.   Delivers consistently in Agile cycles across multiple clients.

Sprint demos are delivered on a regular cadence, the backlog is managed, and changes in scope are handled as they come. Two or more clients are supported at once, each at a different stage, without a drop in quality.

5.   Documents work to a high standard.

Decision records, the reasoning behind design choices, and handover material are complete and follow Ascend's documentation standards.

6.   Demonstrates behaviors aligned with the organization's values.

Feedback from leadership, team members, and clients confirms that the individual consistently demonstrates actions aligned with Ascend's values.

7.   Commits to ongoing professional development.

Holds the Pigment Modeling Fundamentals certification, has completed or is working through the Pigment AI learning tracks in Pigment Academy, and keeps certifications current as new ones are released.

Qualifications, Skills, and Competencies

Qualifications

•    Pigment Modeling Fundamentals certification required
•    Has completed, or is working through, the Pigment AI learning tracks in Pigment Academy (Modeler, Analyst, and Custom Agents)
•    Pigment Pro Training (partner track) completed, or willing to complete it before starting
•    2 or more years hands-on in Pigment, with at least 2 to 3 full implementations built personally
•    5 or more years in EPM/planning
•    Strong FP&A background, including driver-based P&L, opex, rolling forecasts, and budget cycles
•    Experience in at least 2 of the following: workforce/headcount, revenue/ARR (SaaS), sales capacity and quota, three-statement modeling, supply chain/S&OP

Skills

•    Strong modeling in Pigment: Metrics, Lists and dimensions, Tables and Transaction Lists, including choosing granularity and keeping data sparse
•    Fluent in Pigment's formula language (BY and modifiers, FILTER, SELECT, PREVIOUS, ITEM) and in tuning model performance
•    Boards and Views for both input and reporting
•    Scenarios, versions, and snapshots
•    Data integration, including native connectors (ERP, CRM, HRIS, data warehouses), imports, the API, and automated data loads
•    Security, including roles, access rights, and row-level access, with an understanding of how AI agents inherit the running user's permissions and how to use AI data access settings to keep sensitive data (for example, salaries) away from agents
•    Hands-on with the Modeler Agent, and working knowledge of the Analyst, Custom, and Documentation Agents
•    Familiar with Pigment Frames, and able to judge when a Frame is a better fit than a Board
•    Solution architecture, including splitting the work into Applications and applying Pigment best practices for scale
•    Experience with Claude Code or a similar agentic AI tool, ideally connected to Pigment through the Pigment MCP Server, is preferred
•    Background in Anaplan, Adaptive, OneStream, or Hyperion/EPBCS, including experience migrating clients to Pigment, is preferred
•    Experience delivering Pigment projects through a Pigment partner or with Pigment's services team is preferred
•    SQL and data warehouse skills are preferred
•    Experience with Pigment Predictions (machine-learning forecasting) is preferred

Competencies

•    Agile and iterative working style, comfortable with scope changing as the project progresses
•    Collaborative, building with the client rather than for the client
•    Able to work independently with end-to-end ownership
•    Able to support two or more clients at once, each at a different stageThis is a contract role for a Pigment Consultant. The Pigment Consultant is responsible for delivering Pigment solutions for Ascend clients from design through handover, including running workshops, writing requirements, overseeing the model build, testing, and handing the model over to the client. Pigment projects are delivered in short, Agile cycles, and AI does a growing share of the model build, so the Pigment Consultant reviews and approves what the AI builds.
• The Pigment Consultant works directly with client finance users and administrators, builds with the client, and transfers knowledge throughout the engagement so the client is able to run the model. The Pigment Consultant is expected to be senior in Pigment, to work independently, and to support more than one client at a time.

Our commitment

Ascend Partners is an equal opportunity employer. We do not discriminate against applicants or employees on the basis of race, creed, color, age, religion, gender, disability, sexual orientation, marital status, military status, national origin, or ancestry. We are committed to fostering an inclusive and equitable workplace where all employees and partners are valued, respected, and supported.