Model Builder – Pigment, Finance Transformation

Prologis

Pigment Model Builder for Prologis focusing on finance transformation and model building. Collaborating with FP&A and other finance teams to enhance and maintain financial planning models.

Posted 7/16/2026full-timeDenver • California, Colorado • 🇺🇸 United StatesMid-LevelSenior💰 $140,000 - $170,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and maintaining Pigment applications and financial planning models, with a strong focus on data quality, governance, and user adoption. Proficient in translating business requirements into scalable model designs while leveraging AI tools for optimization and efficiency.

Highest-signal resume keywords

Pigment Application DevelopmentFinancial Planning & Analysis (FP&A)Data Integration & MappingModel Architecture DesignDocumentation & Change Management

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

EPM Model BuildingFinancial Statement AnalysisDriver-Based ModelingData ValidationForecastingBudgetingProblem-SolvingUser Acceptance TestingModel OptimizationAI Tool Utilization

Soft Skills

Interpersonal CommunicationAttention to DetailOrganizational SkillsCuriosityJudgment

Tools & Technologies

PigmentAnaplanOracle EPMAI Tools

Industry Keywords

Finance TransformationCorporate FinanceData AnalyticsManagement ReportingGovernance Processes

Tech Stack

Tools & technologies

Oracle

About the role

Key responsibilities & impact

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.
Monitor 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

What you’ll need

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.
Demonstrates willingness and capability to leverage emerging technology, automation, and AI tools to improve efficiency, quality, and speed.

Benefits

Comp & perks

Health insurance
Dental insurance
Vision insurance
401(k) retirement plan with 50% company match up to 12%
Generous PTO with 22 days a year plus paid holidays and volunteer time