Analyst, Data Analytics and 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!

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.

Salary : $75,000 - $85,000