Overview
Skills
Job Details
Title: Analyst III (Data Analyst)
Need Locals Only BayArea
Work: Hybrid/Onsite
Location: San Francisco or Sacramento location.
Note: Need W2 ONLY
Position duties and responsibilities include:
- Analyze current grant timesheet structure (Adobe PDF) and database structure (Microsoft Excel).
- Develop a plan to convert monthly grant timesheets into a survey application including drop down entries to cover the different grants and fiscal years, internal logic to assist in completing the survey, and a means for editing and regenerating incorrect entries.
- Develop an output protocol so monthly grant timesheets in the form required by Branch Accounting and Procurement can be produced out of the database for signature and submission.
- Develop an analysis dashboard in Power BI or or application for grant managers and Senior Budget Analyst to use in grant budgeting and management
- Document system for users
Desirable experience and skills include:
-- Ability to analyze existing systems and automate applications for personnel and grants management
-- Experience in creating, testing and documenting on-line surveys, databases and dashboards
-- Experience in survey applications including Microsoft Forms or Qualtrics
-- Experience in reporting and analysis applications including Microsoft PowerBI