Grants and Data Coordinator

Summary of the Role

The Data Systems Administrator oversees and maintains HMIS, Resident Tracker, and Power BI systems to support organizational data needs. This role ensures data accuracy, prepares weekly quality reports, and generates ad hoc reports for leadership. The Administrator collaborates with programming teams to improve data collection and maintains dashboards in Power BI.

Additional responsibilities include managing data and reporting for various grants (Emergency Shelter, Long-Term Storage, FHLB), submitting monthly reports, and supporting audits. The ideal candidate is highly organized, technically skilled, and capable of working independently across multiple projects.

Mel Trotter Ministries Staff Attributes

We expect all staff to project and exemplify passion to a faith-based approach to advocacy for the guests, to be humble, supportive team players, who acknowledge their own gifts and those of others, are truthfully transparent, seek input from others, admit and learn from mistakes, are highly coachable and approachable. We expect a hungry, innovative, goal-oriented, eager contributor, who shows a dedicated work ethic. We expect our staff to exhibit empathy, compassion, active listening, to be self-aware, sensitive across racial, class and cultural lines, ethical, and approachable. We look for work habits of punctuality, dependability, accountability, responsibility, cooperation, team participation, integrity, problem solving, and overall positivity.

These attributes, combined with the performance of one's duties and achievement of goals, will be equated with the quality of one's overall job performance. Please refer to them often and feel free to ask for feedback on these areas regularly.

Manage Data Quality

• Manage and oversee as an administrator and maintain : HMIS-Homeless Management Information System, Resident Tracker and Microsoft Power BI.
• Between the systems, regularly prepare weekly reports for data quality checks across the organization.
• When requested, prepare ad hoc reports for leadership.

Grants and Data Coordinator

Classification : Full-Time Salary Exempt

Reports to : Chief Financial Officer

Effective Date : 2020

Facilitating Data Process Improvements

Prepare Data and Grant Reports

1. Emergency Shelter Program Grant

o Import overnight shelter data on a weekly basis.

o Update core stat elements to HMIS profiles.

o Prepare and submit monthly reimbursement reports.

2. Long Term Storage Grant

o Prepare and submit monthly reimbursement and performance reports.

o Participate in annual audit.

3. Federal Home Loan Bank Grants

o Monitor ongoing data collection to ensure smooth annual audit process.

4. Other Grants

o In alignment with sections above, ensure the highest degree of accuracy and completeness of key data collection elements to facilitate smooth grant writing and reporting.

Qualifications

Working Conditions