Portfolio Analytics & Database Coordinator

About POAH: Preservation of Affordable Housing, Inc., or POAH, is a real estate developer committed to preserving and developing ‘at risk’ affordable rental housing around the country. Based in Boston, with branch offices in Chicago and Washington, DC, POAH currently owns and manages approximately 9,000 affordable rental homes for families, seniors and the working poor in nine states and the District of Columbia.

POAH’s reach is national in scope, and its pursuit of the preservation mission is empowered by a

focus on the business bottom line. Its strong reputation has resulted from a demonstrated ability

to craft complex financial transactions, tackle tough multi‐family projects, and close deals that

preserve the affordability of ‘at risk’ properties. The organization and its leaders are at the

forefront of policy and legislative discussions around housing preservation, affordable housing

finance and regulatory reform.

About the Opportunity:  POAH is seeking a Boston-based Portfolio Analytics & Information Coordinator to work within its Ownership & Operations department as a member of the Asset Management team.  In this dynamic role, the Coordinator will interact extensively with all staff throughout the organization (i.e. acquisitions, development, community impact, compliance, property management, legal, finance, human resources, information technology, communications, etc.)

The Asset Management team is responsible for monitoring POAH’s long-term owner interests and focuses on maintaining a healthy portfolio of housing communities by executing on financial, physical and policy opportunities for stewarding the portfolio.  This team works on property and portfolio level analytics, workouts, refinancings, restructurings, limited partner exits, site visiting, financial monitoring, real estate tax management, capital planning, lender/investor relations, and leveraging information technology to improve portfolio oversight, company operations and organizational capacity.

The Portfolio Analytics & Information Coordinator will primarily be tasked with project managing an enterprise-wide database system.

Some of the Coordinator’s specific and essential tasks may include:

• Project Managing POAH's enterprise wide MRI Integratec database system ("PI"), a system which houses hundreds of property level data points for acquisition prospects and POAH owned assets and serves as POAH’s key document repository and reporting/dashboard tool.
• Serving as the point person for database enhancement requests (i.e. new reports, dashboards, screens or revisions to existing reports, dashboards, screens)  and information requests from the corporate database, and diligently scrutinizing, documenting, facilitating and prioritizing such requests and then testing the functionality prior to ensure error free before rolling out the enhancement;
• Developing visually appealing mock-ups and detailed specifications for accurate and well thought out system enhancements;
• Developing and maintaining training manuals and procedure documents for POAH's Integratec database system (PI)    
• Conducting trainings on POAH's Integratec database and hosting office hours;
• As time permits, collecting and analyzing financial information about individual POAH properties or the portfolio as a whole, developing compelling analyses and presentations about the portfolio, completing excel models and helping to develop portfolio systems, procedures and templates and Drafting correspondence to internal and external parties;

Experience: Candidates for this position should possess a Bachelor’s Degree, preferably in accounting, information technology, real estate, business or another related field plus 2-10 years of relevant work experience.

Skills: Candidates should have demonstrated ability in some or all of the following areas:

• Database management experience (managing enhancement requests/backlog, system testing, writing specs, administering access, help desk, training, etc.)
• Analytical skills including advanced Excel skills
• Experience working with and reconciling data
• Project management experience
• Proficiency delivering effective training on new technologies.
• Affordable Housing experience
• Financial and accounting knowledge / experience (i.e. public accounting, audit and/or general ledger experience)
• Real Estate experience and/or degree
• Flexibility and ability to manage conflicting priorities and meet deadlines;
• Financial analysis and modeling proficiency;
• Scrupulous attention to detail;
• Effective communication in person and in writing;
• Excellent presentation skills, including developing and using PowerPoint, Excel Charts, Infographics, and other tools

Salaries are competitive and commensurate with experience.   Benefits include health and life insurance, generous earned leave program, and a 401k retirement plan with company match component.

POAH is an Equal Opportunity Employer.  Diverse candidates are encouraged to apply.