Modelling And Simulation Jobs in Chicago, IL (NOW HIRING)

Compensation Range:

$65,000 - $95,000

Compensation Disclaimer:
The salary range listed reflects the base pay for this role at Altus Group and is provided where required by local regulations. Actual offers may differ based on experience, market conditions, and other relevant factors. The range does not include additional compensation such as bonuses, equity, benefits, or other incentives.

Job Summary:

Altus Group is currently looking for a new Real Estate Valuation Consultant to join our Atlanta office in our Advisory, Altus Analytics division. In this position, the Consultant will be responsible for managing the daily workflow through interaction with clients, subordinates and supervisors. Responsibility includes the quarterly valuation process of institutional real estate funds, which includes managing all aspects of the appraisal management process & real estate investment vehicles.

Key Responsibilities:

• Requires advanced working knowledge of complex Excel tasks like VBA (Visual Basic for Applications) programming, data simulation, analytics, and advanced formula usage (such as Macros, Power Query, Pivot Tables, Power Pivot, Dynamic Name Range, etc.).

• Improve client deliverables through data visualization. Includes presenting sets of primarily quantitative raw data in a schematic form. The visuals used are formats tables, charts and graphs, diagrams, plots, geospatial maps, figures, and correlation matrices, which sometimes will be combined in a dashboard.

• Interpreting client requests and communicating/delegating requests to team

• Managing projects/engagements to ensure delivery on time and on budget

• Review all work by junior staff before sending to clients or 3rd parties, coaching and mentoring junior staff

• Review third party appraisal reports as part of the valuation management process, discuss and resolve any concerns with the client and/or the 3rd party appraiser

• Review appraisal reports for compliance with USPAP and State regulations

• Manage client communications throughout the valuation management engagement; create or review portfolio metric presentations

• Develops relationships with equivalent level individuals in client firms

• Delivers the highest quality of service and technical excellence

Key Qualifications:

• A university or college degree from an accredited university in Finance, Statistics, Data/Computer Science, Mathematics, or related field.

• Must have strong Excel proficiency and the ability to complete complex Excel tasks and experience with VBA (knowledge of the following is a plus: R or Python Statistical Programming, Structured Query Language (SQL), Tableau/Power BI, Snowflake)

• Experience in Commercial Real Estate Valuation, Asset Management, Acquisitions, or Underwriting

• Expertise in financial analysist and experience with financial modelling for commercial property types (office, industrial, retail and/or multifamily) in ARGUS

• Proficiency in Excel

• Strong communication skills

• Strong project management skills: managing deadlines, creating plans and evaluating results, communicating at-risk tasks

• Experience with client deliverable life cycle and proven record of successful management of client deliverables

Unlock your Altus Experience!

If you're looking to advance your career in in an industry that is transitioning for greatness, there's no better place than Altus Group.

Our high trust, high performance culture prioritizes progressive programs that empower you to deliver your greatest performance while promoting collective success where everyone is recognized and connected.

Weoffer boundless opportunities in a rapidly growing global business:mentorship from the best and brightest in CRE,access to our Altus Intelligence Academy, and the chance to work with the best data sets, tools and technology in the industry.

What Altus Group offers:

• Rewarding performance: competitive compensation, incentive and bonus plans, and a total rewards package prioritizing mental, physical, and financial well-being.

• Growth and development: we invest in your professional learning. Our Altus Intelligence Academy offers over 150,000 hours of learning content.

• Flexible work model: our Activity-Based Work model provides flexibility to align your work location to the needs of the work - use the office for collaboration and remote work for focused tasks.

Inclusivity & Accessibility

Altus Group is committed to fostering an inclusive work environment where all clients and employees feel welcomed, accepted and valued. We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.
Applicants with disabilities may contact Altus Group to request and arrange for accommodations. If you need accommodation, pleasecontactusataccessibilityusa@altusgroup.com or +1 888 692 7487.

Use of Artificial Intelligence

AI tools may be used to support the initial stages of screening for this role; however, all assessments and final hiring decisions are reviewed and made by an Altus Group hiring professional.

Background Checks

Please note that as part of our commitment to maintaining a safe and secure workplace, Altus Group may conduct background checks on candidates who receive a conditional offer of employment. These checks may include, but are not limited to, verification of employment history, education credentials, criminal records, credit history (where relevant), and reference checks. The scope and nature of background checks may vary depending on the role, location, and applicable laws. All background checks will be conducted in compliance with local laws and regulations, and candidates will be informed of any checks required as part of the recruitment process.

Other Notes / Application Process

We appreciate all applicants; however, only those selected to move forward will be contacted. Thank you for your interest in Altus Group.