Job ID: TN-59680 (96091215)
Hybrid/Local Data Analyst with CRM, grants, KPIs, Formstack, SharePoint, and Edison experience
Location: Nashville TN (ECD)
Duration: 6 months
Good Afternoon, The applications currently used by the department for the purposes of these job duties include Formstack, SharePoint, Customer Relationship Manager (CRM), and Edison.
Qualifications
Type Category Qualification Description Competency Required
Skills Others Payment Data Novice (1-3 Years) No
Skills Others Program Data Novice (1-3 Years) No
– Reviewing data integrity in the recording of grant information in the department’s Customer Relationship Manager (CRM) system and other databases in the department, for the following programs: Placemakers, ThreeStar, TN Downtowns, TN Mainstreets, Historic Development Grants, Infrastructure Planning, PEP, Site Development, Certified Sites, ARC, CDBG and SSBCI Debt Programming.
– Reviewing CRM data entries for quality control and ensuring RD reports, KPIs and dashboards all align with up-to-date program administration grant awards, reimbursement amounts, monthly report details and program closeouts.
– Complete desk review, phone call and site visit monitoring for 40 RD grants for RD programs and upload monitoring checklists into CRM – compiling information for the ECD Monitoring Implementation Plan.
– Gather program data, outputs, outcomes to track performance metrics, taking data from program folders inputting into CRM tables for all RD programs. This will then be added to program one pagers.
– Create a list of monthly program announcements and track entry into CRM, this includes reconciliation, and compilation of lists of outstanding grants management information for each program each month, for regular catch-up meetings with RD directors.
– Input payment data into CRM every Monday totaling around 25-40 payments per week.
– Audit contact information to CRM for RD active grant records and add any missing by program.
– Help with data migration between IT systems, CRM maintenance and data entry as needed to assist with grants administration.
– Complete RD programming updates to all Formstack forms during application and reporting cycles, or as requested.