Senior Associate, Valuation Management Data Reporting

SitusAMC 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 SitusAMC, 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!

This role will be responsible for assisting with the reporting features of our proprietary Valuation Management System (VMS). The VMS manages the quarterly commercial valuation management process for SitusAMC's institutional consulting engagements. This role provides support to our Real Estate Valuation Services (REVS) division, which involves assisting in a wide range of activities, including translating stakeholder questions into reporting requirements, building out reporting metrics and filter criteria, writing clear report definitions and acceptance criteria, assisting with automated test cases, maintaining data dictionaries, and source-to-target mappings. This role will validate numbers against source systems, reconcile totals, perform edge-case testing and regression checks. Design and build of reporting features will be in Excel and/or via business intelligence dashboards. In addition, the role involves running requirements workshops, constructive discussions and explaining trade-offs in system decisions and communicating that to the business and IT side. This role will assist with the technology roadmap, ad-hoc tasks and set expectations on data availability and refresh cycles.

Essential Job Functions:

• Efficiently manage the reporting developments for Valuation Management System
• Proactive monitoring and responding to incidents
• Supervise workflow to produce on time deliveries
• Help execute new reporting and fixing reporting through implementation of organizational and technical skills
• Communication/coordinate with co-workers
• Resolve non-compliant issues through verbal and written communication with client or other involved parties
• Work independently on projects and also collaborate ‘face to face’ as a team player
• Other activities as may be assigned by your manager

Qualifications/ Requirements:

• Bachelor’s Degree – preferred fields of study include Data Analytics, Data Science, Real Estate, Finance or equivalent combination of education and experience
• Experienced professional with 5+ years of industry and/or relevant experience, typically with 1+ years in an Associate level role or external equivalent.
• Experience in PowerBI and/or Tableau is required
• MS Office Suite including Outlook, Excel, Power Point and Word; specifically advanced Excel skills are required
• Experience with analyzing and understanding NCREIF data is a plus.
• Working knowledge of SQL and basic understanding of Entity Relationship Diagrams (ERDs)
• Intermediate understanding of Commercial Real Estate and Reporting
• Excellent communication and teamwork skills
• Ability to meet deadlines, self-motivated, and execute at a high level

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. SitusAMC does not accept unsolicited resumes from staffing agencies, search firms or any third parties. Any unsolicited resume submitted to SitusAMC in any manner will be considered SitusAMC property, and SitusAMC will not pay a fee for any placement resulting from the receipt of an unsolicited resume.

The annual full time base salary range for this role is

$80,000.00 - $95,000.00

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 SitusAMC Senior Management approval. SitusAMC 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.

Pay Transparency Nondiscrimination Provision

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

Know Your Rights, Workplace Discrimination is Illegal