Model Builder - Pigment, Finance Transformation

About the role

We are seeking a Pigment Model Builder to play a key role in Prologis’ implementation and ongoing evolution of Pigment, the Finance organization’s enterprise planning and modeling platform. This position sits within the Finance Transformation team and partners closely with FP&A to design, build, improve, and maintain models that support forecasting, planning, scenario analysis, reporting, and strategic decision-making across the Finance organization.

Responsibilities

• Partner with FP&A and Finance Transformation leadership to understand business needs, gather requirements, define use cases, and translate requirements into scalable Pigment model designs.
• Build, enhance, and maintain Pigment applications, including dimensions, lists, metrics, formulas, data flows, boards, workflows, security, reporting views, and dashboards.
• Support the implementation and continuous improvement of corporate financial planning models, including P&L, balance sheet, cash flow, capital allocation, development activity, debt, FX, ownership structures, consolidated financial statements, and management reporting.
• Design and maintain model architecture aligned with Pigment best practices, including modularity, transparency, performance optimization, auditability, and ease of maintenance.
• Partner with Technology, Data, and business system owners to design, validate, and troubleshoot inbound and outbound data integrations between Pigment and enterprise source systems or data platforms.
• Maintain model health and data quality; identify and resolve issues related to calculations, mappings, hierarchies, metadata, access, data loads, and reporting outputs.
• Establish and support governance processes for model changes, testing, user acceptance, release management, access management, documentation, and production support.
• Create and maintain clear documentation, including data flow diagrams, model architecture, calculation logic, process flows, change logs, support runbooks, and user training materials.
• Support FP&A and finance user adoption by providing training, answering questions, gathering feedback, and translating user needs into future enhancements.
• Use Pigment AI and other approved AI tools to accelerate model design, build, documentation, testing, and optimization, while ensuring outputs are reviewed, explainable, and aligned with Prologis’ governance standards.
• Stay current on Pigment product capabilities, AI features, model-building best practices, and enterprise planning trends; proactively recommend enhancements that improve quality, efficiency, scalability, and user experience.
• Partner across FP&A, Accounting, Treasury, Real Estate, Strategic Capital, Energy Solutions, Operations, Data Center, Technology, and other teams to ensure planning models reflect accurate business logic, consistent assumptions, and aligned financial outputs.

Requirements

• 5+ years of experience in finance systems, FP&A, corporate finance, EPM model building, finance transformation, consulting, or a related role.
• Bachelor’s degree in finance, accounting, business administration, information systems, data analytics, or a related field.
• Hands-on experience designing, building, configuring, or supporting Pigment or comparable enterprise planning platforms such as Anaplan, Oracle EPM.
• Strong understanding of FP&A processes, forecasting, budgeting, financial statements, driver-based modeling, and management reporting.
• Demonstrated ability to gather business requirements and translate them into system designs, data structures, calculations, workflows, and user-facing reporting outputs.
• Strong analytical, data validation, and problem-solving skills, with the ability to investigate and resolve discrepancies across models, source data, and reporting outputs.
• Familiarity with data integrations, source system mapping, master data, hierarchies, access controls, and production support processes.
• Highly organized with strong attention to detail and the ability to manage multiple priorities in a fast-paced environment.
• Strong documentation, change management, and process improvement skills.
• Strong interpersonal and communication skills, with the ability to work effectively across technical and non-technical teams, cultures, and organizational levels.
• Curiosity and sound judgment in using AI-assisted tools to improve productivity while maintaining appropriate governance, validation, and control.
• Ability and willingness to work in the San Francisco or Denver office 2-3 days per week.
• Exercises sound judgment, creative thinking, and accountability for outcomes.

Qualifications

• Direct Pigment model-building experience, Pigment Academy training, or Pigment Model Builder certification.
• Experience supporting integrated financial models that include income statement, balance sheet, and cash flow forecasting.
• Experience modeling or forecasting financial impacts of complex ownership structures, capital structures, development activity, debt, FX, or consolidated financial statements.
• Experience in real estate, REITs, private capital, asset-level forecasting, or other complex, capital-intensive industries.
• Experience defining or supporting model governance, release management, user access, support operations, and documentation standards.
• Experience using AI capabilities within enterprise planning, analytics, documentation, testing, or model-building workflows.
• Consulting, product owner, or finance transformation experience.

Skills

• Strong analytical and problem-solving skills.
• Effective communication and collaboration skills.
• Proficiency in enterprise planning platforms like Pigment, Anaplan, or Oracle EPM.
• Experience with data integration and source system mapping.
• Knowledge of financial modeling techniques and principles.
• Ability to work independently and collaboratively.

Benefits

• Hiring Salary Range: $140k - $170k.
• Comprehensive benefits package including healthcare, dental, vision insurance, 401(k) retirement plan with company match, PTO, paid holidays, and volunteer time off.
• Flexible work arrangements, including the option to work 2-3 days per week in the San Francisco or Denver office.
• Equal opportunity and affirmative action employer.