DHCD is seeking a Database and Program Monitoring Coordinator for the Division of Housing Development!
AGENCY MISSION:
DHCD is within the Housing and Economic Development Secretariat and its work touches the lives of all Massachusetts residents.
DHCD's mission is to strengthen cities, towns and neighborhoods to enhance the quality of life of Massachusetts residents by providing leadership, professional assistance and financial resources to promote safe, decent, affordable housing opportunities, economic vitality of communities and sound municipal management.
SUMMARY OF ROLE:
Assist in the implementation and ongoing coordination of the division’s web-based One-Stop+ application and integrated management information database, including staff training, and work with software provider to ensure the system is current and functional. Develop and prepare reports related to of all stages of housing development, geographic location, characteristics, etc., of projects. Assist in the administration of the tax credit and subsidy programs, including overseeing application intake, generating award letters, preparing contracts, and reviewing requisitions. Act as a resource for quasi-public housing agencies, non-profit and for-profit sponsors, constituents, and other local and federal organizations regarding the division’s funding resources. Compile reports for Director and Undersecretary regarding the division’s efforts and successes for use with a variety of audiences.
DUTIES AND RESPONSIBILITIES (NOT ALL INCLUSIVE):
Data Maintenance:
- Collaborate with the Database Coordinator in data entry/maintenance of Division’s One-Stop+, the division’s integrated database, and in the maintenance of data inventory.
- Participate, as directed, in the DHCD cross-divisional data sharing initiative, including active engagement with the Data Steering Committee, the Data Community of Practice, and Peer-to-Peer Help sessions. In addition, maintain and keep current DHCD’s Data Sources Inventory for the Housing Development Unit (HDU).
Tracking & Reporting:
- Assist in the tracking and reporting in both the database and MS Excel of all federal ARPA funds that fall under the purview of the HDU.
- Prepare and submit reports required by federal and state agencies, including the U.S. Treasury, U.S. Department of Housing and Urban Development (HUD), and the Massachusetts Legislature. Also, as requested, submit funding information to HUD through HUD/IDIS (Integrated Disbursement & Information System).
- Develop database reports as required/requested by division, department/administration/outside organizations; analyze data to evaluate various programmatic requirements, accomplishments and trends.
Technical Coordination & Training:
- As directed, and working with the Database Coordinator, serve as contact for Agate Software on all aspects of the IntelliGrants system, including updating, expansion, editing, and identifying problems/errors; troubleshoot as required. Coordinate with software developer(s) to build out additional functionality to systems.
- Serve as contact for users of IntelliGrants, both internal and external, and assist in training new users of the system.
- Coordinate training of division staff and external users in updates to database and software and/or recurring data entry errors. Prepare training materials, user guides, and standard operating procedures, as requested.
- Serve as primary contact for Housing Navigator users, including developers and property managers.
- Identify data entry errors and omissions; coordinate changes/updates of database with DHCD’s Information Technology staff and software providers.
Contracts & Awards:
As directed by the Director/Deputy Director, participate in:
- Pre-application and full application process of division’s funding competitions, including contact with the developers, preparation of intake and funding reports, etc.
- Preparation of award letters for division’s programs.
- Preparation of contracts and contract packages (including securing vendor codes) for both federal and state subsidy programs.
- Pre-application and full application process of division’s funding competitions, including contact with the developers, preparation of intake and funding reports, etc.
- Preparation of award letters for division’s programs.
- Preparation of contracts and contract packages (including securing vendor codes) for both federal and state subsidy programs.
- Confirmation of subsidy loans for project audits, in the review of project requisitions, and in other matters relative to subsidy and tax credit program administration
PREFERRED QUALIFICATIONS:
1. Excellent computer and data entry skills/knowledge of database performance/function; expert-level knowledge of Microsoft Excel, Access, PowerPoint, and Outlook.
2. Expert knowledge of database management, data manipulation, and report generation.
3. Knowledge of the factors, trends and problems associated with the development of affordable housing.
4. Ability to work both independently and with a team, and to take initiative while understanding/respecting boundaries.
5. Ability to provide technical assistance, training and instruction.
6. Excellent communication skills, including written and oral communication.
7. Ability to balance multiple priorities, to adjust to changing priorities, and to carry substantial responsibilities related to division priorities, the database and monitoring.
8. Ability to design and develop informational materials and to make public presentations to different audiences.
9. Excellent attention to detail.
COMMENTS:
Please upload resume and cover letter.
This position would be expected to follow a hybrid model of reporting to work that combines in-office workdays and work from home days, as needed.
Salary placement is determined by years of experience and education directly related to the position and the Human Resources Division’s Recruiting Guidelines. In the case of a promotional opportunity, the salary provisions of the applicable collective bargaining agreement will apply to placement within the appropriate salary range.
Education, licensure and certifications will be verified in accordance with the Human Resources Division’s Hiring Guidelines. Education and license/certification information provided by the selected candidate(s) is subject to the Massachusetts Public Records Law and may be published on the Commonwealth’s website.
QUALIFICATIONS:
First consideration will be given to those applicants that apply within the first 14 days.
MINIMUM ENTRANCE REQUIREMENTS: Applicants must have at least (A) three years of full time, or equivalent part-time, professional, administrative or managerial experience in business administration, business management or public administration the major duties of which involved program management, program administration, program coordination, program planning and/or program analysis, or (B) any equivalent combination of the required experience and the substitutions below.
Substitutions:
I. A Bachelor's degree with a major in business administration, business management or public administration may be substituted for a maximum of two years of the-required experience.*
II. A Graduate degree with a major in business administration, business management or public administration may be substituted for the required experience.*
III. A Bachelor's or higher degree with a major other than in business administration, business management or public administration may be substituted for a maximum of one year of the required experience.*
*Education toward such a degree will be prorated on the basis of the proportion of the requirements actually completed.
Official Title: Program Coordinator II
Functional Title: Database and Program Monitoring Coordinator
Primary Location: United States-Massachusetts-Boston-100 Cambridge Street
Job: Administrative Services
Agency: Department of Housing & Community Development
Schedule: Full-time
Shift: Day
Job Posting: Aug 11, 2022, 2:47:15 PM
Number of Openings: 1
Salary: $62,268.18 - $89,143.08 Yearly
Bargaining Unit: 06-NAGE - Professional Admin.
Confidential: No
If you have Diversity, Affirmative Action or Equal Employment Opportunity questions or need a Reasonable Accommodation, please contact Diversity Officer / ADA Coordinator: Marjie Lalli - 6175731254
Comprehensive Benefits
When you embark on a career with the Commonwealth, you are offered an outstanding suite of employee benefits that add to the overall value of your compensation package. We take pride in providing a work experience that supports you, your loved ones, and your future.
Want the specifics? Explore our Employee Benefits and Rewards! at https://www.mass.gov/commonwealth-employee-benefits-and-rewards
Executive Order #595: As a condition of employment, successful applicants will be required to have received COVID-19 vaccination or an approved exemption as of their start date. Details relating to demonstrating compliance with this requirement will be provided to applicants selected for employment. Applicants who receive an offer of employment who can provide documentation that the vaccine is medically contraindicated or who object to vaccination due to a sincerely held religious belief may make a request for exemption.
An Equal Opportunity / Affirmative Action Employer. Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.
The Commonwealth is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law. Research suggests that qualified women, Black, Indigenous, and Persons of Color (BIPOC) may self-select out of opportunities if they don't meet 100% of the job requirements. We encourage individuals who believe they have the skills necessary to thrive to apply for this role.