Analyst, Asset Management Operations Database

Asset Management Operations Database Analyst - Cleveland, OH

What is the opportunity?

RBC Capital Markets - RBC Community Investments (www.rbccm.com/communityinvestments), part of the Royal Bank of Canada (RBC) firm, is a leading syndicator of State and Federal Low Income Housing Tax Credits (LIHTCs), Historic Rehabilitation Tax Credits (HRTCs), and New Markets Tax Credits (NMTCs). The Asset Management Operations Database Analyst is responsible for the following:

What will you do?

*Responsible for the co-ordination, tracking and input of the initial set up of new property information into the asset management database as well as analysis of property projections.

• Responsible for the analyzation and creation of annual budgets based upon projections for all initial lease up year projects.
• Responsible for the set up and maintenance of all quarterly reporting and budget system notifications to our partners including late reporting notices.
• Responsible for the monitoring of project transaction status to confirm proper notifications are sent throughout the projects' lifecycle.
• Assist the VP-Database Integrity in the creation, implementation and testing of custom Asset and Fund Management reports from the database.
• Performs quality control audits and consistently maintains integrity of the asset management database and other electronic systems.
• Responsible for maintaining property files for the AMO group on the Community Investments shared server, in addition to upload and input of data into the asset management database.
• Assumes special projects as assigned.
• Proactively identify operational risks/ control deficiencies in the business
• Review and comply with Firm Policies applicable to your business activities
• Escalate operational risk loss events, control deficiencies and risks that you identify to your line manager and the relevant risk and control functions on a timely basis.

What do you need to succeed?

Must-have:

• Associate's degree in business, plus a minimum of two years' experience in multi-family real estate finance/rent-restricted multifamily asset database management skills including systems/software experience.

-OR-

• Five to seven years' experience in multi-family real estate finance/rent-restricted multifamily asset database management skills including systems/software experience.
• Proficiency in MS-Outlook and MS-Office applications
• Strong organizational skills with the ability to coordinate complex activities, prioritize conflicting demands and meet deadlines
• Keen analytical skills and attention to detail
• Strong interpersonal skills, highly motivated and able to work independently
• Excellent verbal and written communication skills

Nice-to-have

• Working knowledge of the LIHTC program and the IRS 8823 Guide
• Tax Credit Certification from a recognized and reputable agency

What's in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable
• Leaders who support your development through coaching and managing opportunities
• Ability to make a difference and lasting impact
• Work in a dynamic, collaborative, progressive, and high-performing team
• Opportunities to do challenging work
• Opportunities to building close relationships with clients

The good-faith expected salary range for the above position is $60,000 - $85,000 depending on factors including but not limited to the candidate's experience, skills, registration status; market conditions; and business needs.This salary range does not include other elements of total compensation, including a discretionary bonus and benefits such as a 401(k) program with company-matching contributions; health, dental, vision, life and disability insurance; and paid time-off plan.

RBC's compensation philosophy and principles recognize the importance of a highly qualified global workforce and plays a critical role in attracting, engaging and retaining talent that:

• Drives RBC's high-performance culture
• Enables collective achievement of our strategic goals
• Generates sustainable shareholder returns and above market shareholder value

Job Skills

Additional Job Details

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.