Vice President, Asset Management - CRE Modeling

Situs

AMC is where the best and most passionate people come to transform our client’s businesses and their own careers. Whether you’re a real estate veteran, a passionate technologist, or looking to get your start, join us as we work together to realize opportunities for everyone, we proudly serve.

At Situs

AMC, we are looking to match your unique experience with one of our amazing careers, so that we can help you realize your potential and career growth within the Real Estate Industry. If you are someone who can be yourself, advocate for others, stay nimble, dream big, own every outcome, and think global but act local – come join our team!

Pelium Real Estate Asset Management, LLC (“Pelium”) is a best-in-class commercial real estate (CRE) asset management platform, delivering seamless, integrated solutions exclusively for Apollo Global Management, Inc.

• Leads Excel model creation for underwriting and analytics for all data within Asset Management driven by client needs and expectations
• Understands the CRE business and information needs of the client and translates those needs into analytics and data integration requirements
• Supports the design, development, and maintenance of ongoing metrics, reports, data mining, analytics, dashboards, presentations, etc. that drive meaningful, timely, and actionable insights and can be easily interpreted by users
• Recommends process improvement opportunities – document current state process and create future state process documentation
• Maintains and supports databases, including inputting and correcting data, determining formats, researching data conversions, establishing data specifications, configuration/integration, updating sources and ensuring data integrity
• Teaches business users how to interact with the Excel models and interpret the results, and develop reference materials
• Develops training programs and communication plans to improve user adoption and effectiveness of new and existing features
• Advanced knowledge of MS Excel programming using languages such as VBA and Python

• 4-year college degree in computer science, information technology/system or related field preferred
• MBA or equivalent experience preferred
• 5+ years' experience in financial services, commercial real estate finance highly preferred
• 5+ years' experience building commercial real estate models in Excel or other platforms
• Experience with bilateral integration of Excel models and SQL databases
• Comprehension of business processes
• Ability to find solutions to business problems from data-driven insights
• Strong working knowledge of data management best practices and experience implementing and maintaining them
• Ability to define problems, collect data, establish facts, and to draw valid conclusions
• Solid business judgment, collaboration, and critical thinking skills
• Must be able to be able to explain technical concepts and procedures to non-technical users
• Strong interpersonal skills
• Good communication and customer service skills are required

• Office environment with frequent computer, mouse, keyboard use
• Alternating between sitting or standing as needed
• Hearing, talking, reaching, grasping

Note:

This job description is not intended to be all inclusive or exclusive. At any time, employees may perform other related duties as required to meet the ongoing needs of the organization and participate in additional trainings.

Situs

AMC is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

The annual full time base salary range for this role is $ - $. Specific compensation is determined through interviews and a review of relevant education, experience, training, skills, geographic location and alignment with market data. Additionally, certain positions may be eligible to receive a discretionary bonus as determined by bonus program guidelines, position eligibility and Situs

AMC Senior Management approval. Situs

AMC offers PTO and paid holidays, the terms of which are set forth in the program policies. All full time employees also are eligible to participate in various benefit plans, including medical, dental, vision, life, disability insurance and 401K; in each case in accordance with the terms of the applicable plans.