Press ENTER to learn more about SitusAMC Press ENTER to search jobs

CRE - Data & Reporting Analyst - Remote US in US - Remote (JR01468)

Job DescriptionJob Attributes+

  • Job ID

    JR01468

  • Job Category

    Platforms Management

  • Business Unit

    Unspecified

  • Job Location

    US - Remote

Overview

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!

Pelium Real Estate Asset Management, LLC (“Pelium”) is a leading asset management platform fully dedicated to supporting Apollo’s commercial real estate financing business in the United States.

This role is responsible for providing data reporting and analytical assistance to our Asset Management team who oversees a client’s portfolio of highly structured commercial real estate loans. This role will lead the creation and maintenance of various reports, analysis, presentations, data models, and analytical tools. They will partner closely with other data, reporting, and asset management teams to insure the efficient, accurate and relevant presentation of information.

Essential Job Functions:

  • Works with internal stakeholders and clients to understand business needs and translate how technology can be applied for data collection, transformation, analysis, and presentation
  • Analyzes, interprets, and presents data using industry relevant commercial real estate asset management software such as RealINSIGHT
  • 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
  • Builds data collection process, enriches existing in-house data, and works to ensure data quality and completeness.
  • Teaches business users how to interact with the visualizations 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
  • Coordinates with other stakeholders to resolve any issues related to report generation ensuring that all reports are created using efficient processes
  • Ability to proactively work in a fast-paced environment and take initiative to complete multiple tasks under tight deadlines
  • Ability to communicate effectively both written and verbal
  • Advanced knowledge of MS Office Suite including Outlook, Excel, Power Point and Word
  • Identifies business process improvements to be made as a result of analytical insights
  • Other activities as may be assigned by your manager

Qualifications/ Requirements:

  • Bachelor’s degree in related field or equivalent combination of education and experience
  • Entry level professional with 0-2 years of industry and/or relevant experience, typically at an Analyst level role or external equivalent.
  • Advanced Excel skills required with ability to join data across workbooks, transform data, and familiarity with Excel functions VLOOKUP, INDEX, MATCH, PivotTables, etc.
  • Experience in Financial Services, Real Estate Finance highly preferred
  • Experience with SQL and relational databases a plus
  • Experience with commercial real estate asset management or servicing/special servicing systems such as RealINSIGHT, CAMs, Enterprise! or equivalent a plus
  • Experience with any enterprise reporting tool such as Power BI, Tableau, or equivalent a plus
  • 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
  • Strong time management and communication skills (written and oral).

#LI-MS1 #LI-REMOTE

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

$75,000.00 - $85,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

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.

Our Benefits

Icon representing the concept of powerful futures

Powerful futures

- Annual compensation reviews
- Retirement benefits
- Education allowance program
- Matching gifts program
- Employee referral bonus programs
- Other region-specific incentives

Learn More
Icon representing the concept of peace of mind

Powerful peace of mind

- Competitive vacation policies, holidays & other paid leaves
- Family-friendly leave policies, including maternity, - paternity & other family situations
- Employee wellness platform
- Employee assistance program
- Employee discount program
- Commuter benefits & travel assistance
- Volunteer program

Learn More
Icon representing the concept of strong health

Powerful health

- Robust medical & other insurance plans
- Personal & family wellness benefits
- Savings programs & discounts for health expenses
- Disability, accident & life insurance

Learn More
Part of a global team

Our US offices

Whether you’re working in one of our Real Estate businesses, or in Technology or a Corporate function, you’ll have plentiful learning opportunities and be greeted by a team who values your contribution. And, when it comes to benefits, you can expect above-and-beyond offerings supporting your emotional, physical and financial wellness.
US - Remote
CRE - Data & Reporting Analyst - Remote US

“I look forward to team meetings, training, development and coaching opportunities. It gives me the interaction with people that I need and appreciate. The more I learn, the more I feel like I can grow with the company. I enjoy coaching others, sharing knowledge gained and finding ways to make our job more efficient.”

Cindy Buchanan

QC Specialist II

“You must treat each client like they are your only client. We put customer service at the forefront of our service offering.”

John Wadle

Director of Servicing Quality Control

“Try to be present and remember that not everyone has it all figured out. Your mental and physical health is the most important thing in your life, because without it you can’t do anything.”

Fawzat Trabilsy

Analyst, Asset Management

SitusAMC

Who we are

SitusAMC is a leading independent provider of technology, strategic outsourcing, talent and advisory solutions to the commercial and residential real estate finance industries. We help clients identify and capture opportunities in their real estate businesses through industry-leading services and innovative technologies that drive operational efficiency, increase business effectiveness, and improve market agility across the entire lifecycle of their global real estate activity.

Working among the best talent in real estate, you’ll be a part of some of the most relevant things happening in the industry and engage in interesting and exciting work. You’ll be embraced by a culture that celebrates innovative thinking and empowers you to get the job done. Come join us in Powering Opportunity for those we proudly serve.

30+
Years of delivering results
5000+
Professionals
600+
Technologists
25+
Global Offices
1500+
Clients
US - Remote
CRE - Data & Reporting Analyst - Remote US