Capstone Community Action, Inc. is seeking a professional Data Manager. This newly created position will design systems to streamline data collection and reporting, oversee data quality and be part of implementing a data culture.

Capstone is responsible for timely report out on who we serve, how we serve our clients and when we serve them to multiple, diverse funding sources. The right person will have the ability to understand these changing needs and craft effective and efficient systems to meet these needs.

The essential functions for the Data Manager are reporting of data and progress on action plans and Goals, developing systems to track and report out programmatic and contract outcomes, supporting the grant application process with data and oversight, supporting agency strategic planning and supporting internal and external communications with data and analysis.

Essential Skills for a data manager include familiarity with data warehousing, SQL, report writer tools (Microsoft Report Writer / Power BI), advance excel functionality (Power Query, DAX) and Share Point. They must be able to communicate technical details to non-technical staff, be analytic and strategic in their planning.

Does this sound like you? You can find more details about Capstone, the formal job description and details on how to apply below: 

Overview

• DATES OF POSTING: 4.20.23 – 4.28.23, opened until filled
• NUMBER OF POSITIONS: 1
• POSITION: Data Manager
• BARGAINING UNIT POSITION: No
• LOCATION(S): Gable Place, Barre, Vermont
• PROGRAM: Administration
• SCHEDULE: Full-time regular/40 hours per week
• CLASSIFICATION: Non-Exempt (hourly)
• WAGE: $28.84
• MINIMUM QUALIFICATIONS: See Job Description

Capstone Community Action is an Equal Opportunity Employer and Provider. Applications from women, individuals with disabilities, veterans, and people from diverse cultural backgrounds are encouraged.

Only those applicants selected for an interview will be contacted.

Send cover letter and resume to: jobs@capstonevt.org

JOB DESCRIPTION

• Program: Administration
• Reports To: Chief of Programs & Advancement (COPA)
• Job Title: Data Manager 
• Pay Grade: $60,000 (non-exempt $28.00 per hour range)
• Last Review Date/Update/Change of Job Description:  February 8, 2023

General Statement

The Data Manager supports data compliance and attainment of programmatic and contractual outcomes across all Capstone programs. Supports database development and produces routine and new reporting as required for operations, grants and supports tracking and achievement of strategic planning and grant goals in a ROMA driven environment.

Essential Functions

1. Reporting of Data and Progress on Action Plans and Goals
   1. Part of a team identifying indicators to meet Strategic Goals
   2. Works with Senior Management / Board to identify, form and frequency of reporting of indicators, Works with Program Managers to identify how their work integrates with indicators defined by Board and how to capture the data accurately, timely and efficiently.
2. Programmatic and Contract Outcomes
   1. With Program Managers, Reviews reporting requirements of Grants and Contracts to best determine how to efficiently and effectively capture and report out required information.
3. Support Grant applications
   1. Prepares historical reports and information needed to prepare grant applications
   2. Works with grant writers and programs to determine where and how information will be generated/collected for grant proposals.
   3. Is a resource to mine external information
4. Planning Support
   1. Works with Senior Management, Development, Program Directors to evaluate impact of programmatic changes on meeting expectations in Grant, Contract and Strategic Plan. 
5. Data selection and implementation
6. Support Internal and External communication with data and analysis.

Other Duties:

1. Oversee Agency Client Management Systems (including GoEngage CAP, Head Start)
2. Vendor Relationship: Manages relationship with software vendors.
   1. Program upgrades, updates, customizations, reporting needs.
3. Evaluates, Documents and Trains on the best way to use Client Management Systems to meet reporting needs, streamlined operations, data quality
4. Establishes, monitors and maintains set up data systems
   1. To assure accurate and timely reporting
   2. To make the system as easy to use as possible
   3. Reduce/eliminate redundancy
5. Works with Programs to create systems to assure data quality and timeliness
   1. Establish data checks/ verifications
   2. Evaluates data – seeks clarification and corrections
   3. Certifies accuracy of data Monthly/quarterly/annually
6. Prepares canned and custom reports
7. Reviews proposals and awards to assure programmatic reporting is in place (Grants and Contracts)
8. Meets with programs to evaluate and update data entry procedures.
9. Meets with Program Directors, Managers and Funders to assure reporting needs and definitions are in place.
10. Evaluates business processes to identify opportunities where automation may streamline routine and clerical processes
11. Design, implement, maintain responsive reporting systems
12. Design and report out periodic outcome and status reports for Development and Program managers for internal and external use

Qualifications:

1. Ability to effectively communicate technical details to non-technical managers
2. Analytical, strategic Thinker
3. Ability to visualize and present analytical data in an organized, graphically pleasing and clear manner
4. Current on software technology, methods and trends
5. Software Technical ability including
   1. Advanced Excel skills
      1. Data consolidation
         1. Pivot Tables
         2. DAX
      2. Report Formatting
      3. Excel formulas 
   2. Able to design and write SQL queries in an existing database
   3. Power BI
   4. Microsoft Report Writer
   5. Commitment to social justice a must.
6. Ability to be flexible with tasks and projects, work as part of a team, and under direction.
7. Occasional work outside of regular office hours may be required.

Location: Barre, VT