Model Builder - Pigment, Finance Transformation

At Prologis, we don’t just lead the industry—we define it with a 1.3 billion square foot portfolio and an annual throughput of approximately $3.2 trillion. We create the intelligent infrastructure that powers global commerce, seamlessly connecting the digital and physical worlds. From agile supply chains to energy solutions, our ecosystems help your business move faster, operate smarter and grow sustainably. With unmatched scale, innovation and expertise, Prologis is a category of one—not just shaping the future of logistics but building what comes next.Job Title:Model Builder - Pigment, Finance TransformationCompany:PrologisPigment Model Builder, Finance Transformation – San Francisco, CA or Denver, COA day in the lifeWe 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.This is a hands-on role at the intersection of finance, technology, data, and process improvement. The Pigment Model Builder will gather requirements from FP&A and cross-functional finance partners, translate those requirements into scalable Pigment designs, and build models, calculations, boards, workflows, reporting views, integrations, and controls that are intuitive, reliable, and aligned with platform best practices.As Prologis continues to modernize its financial planning capabilities, this person will help establish the model architecture, governance, documentation, testing, and support processes that allow Pigment to scale across the organization. The role will partner closely with FP&A, Accounting, Treasury, Tax and Technology counterparts to align assumptions, data structures, and business logic across planning processes.The ideal candidate combines deep Pigment or enterprise planning platform experience with strong finance acumen and a builder’s mindset. They should be comfortable moving between stakeholder conversations, solution design, model build, data validation, issue resolution, and user enablement. They should also be curious and practical in applying Pigment AI and other approved AI tools to accelerate model development, testing, documentation, and continuous improvement while maintaining appropriate review, control, and business ownership.This role offers meaningful responsibility, significant cross-functional exposure, and the opportunity to shape the future state of Prologis’ finance planning and modeling environment.Key responsibilities include: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.Building blocks for successRequired: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 EPMStrong 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 weekDemonstrates willingness and capability to leverage emerging technology, automation, and AI tools to improve efficiency, quality, and speed. Exercises sound judgment, creative thinking, and accountability for outcomes.Preferred: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.Hiring Salary Range of: $140k - $170k. Salary and whole compensation package (bonus target) to be determined by the candidate’s location, education, experience, knowledge, skills, and abilities, as well as internal equity and alignment with market data.#LI-AN1People FirstEach of us working at Prologis plays an essential role in the enduring success of our company. We value people who are decisive, courageous and adaptable. While we are one company, locations and departments operate with autonomy and accountability. Individuals take the initiative here.When you join Prologis, you work shoulder to shoulder with some of the top talent in the industry to do the best work of your career. Every employee belongs. Every employee contributes. Employees advance their careers here.As a successful global enterprise, Prologis has never lost sight of what matters most, our strong belief that our people are the most important part of our business. And because of that, we provide a generous total rewards package and take a lot of time to focus on quality management and leadership development. People come first here.All full-time roles in the US come with a robust benefits package which includes healthcare, dental, and vision insurance for employees and eligible dependents. Prologis also offers several other wellness, financial, and work/lifestyle-specific benefits. Our 401(k) retirement plan has a company match of 50% up to 12% of eligible compensation. We also offer generous PTO with a starting accrual of 22 days a year in addition to paid holidays and volunteer time. All job offers are contingent upon successful completion of background verification. Prologis is an Equal Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religions, sex, national origin, sexual orientation, gender identity, disability status, protected veteran status, or any other characteristic protected by law.Employment Type:Full timeLocation:Denver, ColoradoAdditional Locations:San Francisco, CaliforniaSummaryLocation: Denver, Colorado; San Francisco, CaliforniaType: Full time