Coburn Place is recruiting a Data Analyst and Evaluation Specialist (full-time, 40 hours/weekly, non-exempt) who is forward-thinking, self-motivated, and enthusiastic to join our team. The Data Analyst and Evaluation Specialist will manage the client database functions including data collection and mining, ensure data entry is accurate and compliant with reporting needs, analyze data points to tell the accurate story of services provided, and implement evaluation of programs.
This position, while representing the core values and mission of the organization, will fulfill and sustain the mission of Coburn Place by providing in-depth data analysis and evaluation in partnership with the Impact Department. Position requirements include experience and knowledge of databases, mining data, attention to detail, highly organized, database experience, excellent communication skills, and an eye for reviewing and editing.
Job Summary
The Data Analyst and Evaluation Specialist represents the core values and mission of the organization and ensures up-to-date, accurate, timely and confidential collection and reporting of program data. Executes secure and ample evaluation, outcome and monitoring plans and data strategies implemented to fulfill and sustain the mission.
Essential Duties and Responsibilities
(Other duties may be assigned.)
Data Collection
1. Create and update data collection tools centered on meaningful Key Performance Indicators (KPIs).
2. Identify gaps in the current data capture strategy and collaboratively implement enhancements.
3. Coordinate data collection processes.
4. Align measurement activities and data collection needs with logic models.
5. Incorporate Services Outcome Evaluation and other evaluation processes and analyze into reports which can highlight Coburn Place’s story. Updates processes accordingly to keep them relevant, meaningful and measurable.
6. Ensure seamless, inter-departmental arc of intention within the logic model and established outcomes.
7. Bases data collection on Standard Operating Procedures (SOP) to maintain the overall organization data strategy.
8. As directed by the CIIO, establishes and defines measurable data and metrics that allow for consistent trends to be tracked and analyzed; identifies data collection methods, analysis procedures, and uses which are relevant and meaningful to the overall Coburn Place strategic plan and direction.
Data Mining and Analysis
1. Support maintenance of centralized/hybrid data management systems to facilitate output, and outcome tracking for programmatic data.
2. Extract and clean large datasets (edit, recode, and clean for further processing and analysis) from various data collection systems.
3. Examine data sets for anomalies, patterns and correlations to inform program optimization and innovation.
4. Analyze data for programmatic insights to support decisions and deliver on improved client experience and organizational growth.
Reporting and Automation
1. Design and automate weekly, monthly and quarterly data reports and dashboards with meaningful Key Performance Indicators (KPIs), and program performance reports.
2. Assist in data preparation for grant reports, agency data report, training needs and any other needs identified by the CIIO.
3. Respond to customized and routine data requests in a timely manner, for various purposes including grant submissions, development/fundraising/communications, community relations/engagement, partnership development, etc.
4. Compiles timely and accurate data queries and reports for grant submissions and reports, development/fundraising/communications purposes, community relations/engagement, partnership development, etc. and at the request of the CEO, Board of Directors or Executive Leadership (Operations/Finance; Mission Impact; Development) team.
5. Apply design principles and data visualization techniques to present key data trends.
6. Format and proofread charts, graphs and other formats generated for reports.
7. Review written products & narratives for accuracy of analysis and interpretation.
Data Quality Maintenance
1. Ensure accuracy and quality of the data collected and reported in adherence with prevailing information quality frameworks.
2. Work collaboratively with team to train staff for consistency in data collection and entry.
3. Facilitate routine updates of defined outputs, outcomes and tools to mirror program innovations and improvements.
4. Work with grants management team to ensure the alignment of grant-related metrics with program activities and data collected.
Evaluation
1. Works with CIIO to implement and update established evaluation and monitoring plans according to evaluation and nonprofit industry standards and practices. Considers programmatic advancements to inform decisions and evaluation activities.
2. Other evaluation activities as needed.
Additional Duties
1. Represents Coburn Place on community and partner work groups and committees relative to data and technology (such as the Indy CoC HMIS work group and ICADV data monitoring group).
2. Identifies opportunities for volunteer, in-kind and financial resources and communicates these prospects to the Development Department.
Supervisory Responsibilities
This position supervises volunteers and interns as needed.
Qualifications
To perform this job successfully, an individual must be able to perform each essential duty according to the requirements of Coburn Place. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties and responsibilities.
• Experience and knowledge of data mining and analysis using excel or similar.
• Ability to plan and follow through on data analytics deliverables/reports from start to finish.
• Fundamental knowledge of evaluation models, principles, practices and procedures
• Work well with other staff, teams and departments.
• Experience interpreting evaluation plans and logic models to develop survey instruments.
• Experience and knowledge of data dashboards using software like Tableau.
• Ability to run simple quantitative analyses and interpret results using related software with guidance.
• Ability to program and administer web surveys on Microsoft forms/Google forms/Qualtrics, etc.
• Ability to manage multiple deliverables and meet deadlines
• Ability to assist with the finalization of reports, including copy editing, formatting, etc.
• Previous experience working in human services
• Proficiency with data analysis and data visualization software (e.g., SPSS, Tableau)
• Computer software skills required include database management, Microsoft Outlook, Word, Excel, Access, PowerPoint, Publisher and Adobe.
Organization-related Competencies – To perform this job successfully, all employees of Coburn Place should demonstrate the following competencies:
- Customer Service – Manages difficult or emotional customer situations; Responds promptly to customer needs; Solicits customer feedback to improve service; Responds to requests for service and assistance; Meets commitments.
- Teamwork – Balances team and individual responsibilities; Exhibits objectivity and openness to others’ views; Gives and welcomes feedback; Contributes to building a positive team spirit; Puts success of Coburn Place above own interests; Able to build morale and group commitments to goals and objectives; Supports everyone’s efforts to succeed.
- Organizational Support – Follows policies and procedures; Completes administrative tasks correctly and on time; Supports Coburn Place’s goals and values; Benefits Coburn Place through outside activities; Supports affirmative action and respects diversity.
- Oral/Written Communication – Speaks clearly and persuasively in positive or negative situations; Lists and gets clarification; Responds well to questions; Demonstrates group presentation skills and participates in meetings; Writes clearly and informatively; Edits work for spelling and grammar; Varies writing style to meet needs; Presents numerical data effectively; Able to read and interpret written information.
Job-related Competencies – To perform this job successfully, employees should demonstrate the following competencies:
- Analytical – Synthesizes complex or diverse information; Collects and researches data; Uses intuition and experience to complement data; Designs workflows and procedures. Broad knowledge of quantitative and qualitative research methods.
- Design – Generates creative solutions; Translates concepts and information into images; Uses feedback to modify designs; Applies design principles; Demonstrates attention to detail.
- Strategy – Identifies technological opportunities as well as short and long-term challenges that may further or hinder the mission of Coburn Place. Maintains up-to-date knowledge of the latest technology options, security and best practices.
- Judgment – Displays willingness to make decisions; Exhibits sound and accurate judgment; supports and explains reasoning for decisions; Includes appropriate people in decision-making process; Makes timely decisions.
- Planning/Organizing – Prioritizes and plans work activities; Uses time efficiently; Plans for additional resources; Sets goals and objectives; Organizes or schedules other people and their tasks; Develops realistic action plans.
- Dependability – Follows instructions, responds to management direction; Takes responsibility for own actions; Keeps commitments; Commits to long hours of work when necessary to reach goals. Completes tasks on time or notifies appropriate person with an alternate plan.
Education and/or Experience
Bachelor’s degree in Business Administration, Public Administration, Public Health, Social Work, or related field with two to three years of experience in program development and program evaluation or combination of experience and/or education from which comparable knowledge, skills and abilities have been achieved is required. Masters degree preferred. Nonprofit environment preferred.
LANGUAGE SKILLS: Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers and the general public.
MATHEMATICAL SKILLS: Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume. Ability to apply concepts of basic algebra, statistics and geometry. Ability to generate descriptive statistics and conduct basic tests of statistical significance.
REASONING ABILITY: Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.
CERTIFICATES, LICENSES, REGISTRATIONS: A valid Indiana driver’s license and a satisfactory MVR is required for this position. CPR and First Aid certification are required and training in bloodborne pathogens and universal precautions is required. A clear DCS history and clear criminal and sex offender background checks are required. E-Verify is required.
OTHER SKILLS AND ABILITIES: Computer software skills required include: Database management, Microsoft Outlook, Word, Excel, Access, PowerPoint, Publisher and Adobe. Proficiency with data analysis and data visualization software (e.g., SPSS, Tableau) a plus. Proficiency with program databases (e.g., Efforts to Outcomes, Community Tech Knowledge) a plus. Ability to operate a printer, copy machine, scanner and other office equipment is required. Incumbent must have the ability to adapt and conform to shifting priorities and demands and execute accordingly. In addition, this position requires an
understanding of information technology procedures and practices, translating and analyzing data, report writing, and graphics design, while paying close attention to detail and deadlines is essential. Comprehensive understanding of the use of the logic model and theory of change frameworks in the context of program development and program evaluation.
OTHER QUALIFICATIONS: Candidates must have general knowledge of personal computers, network servers, internet and telephone communications, and information equipment and applications.
PHYSICAL DEMANDS: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties and responsibilities.
While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms; and talk or hear. The employee frequently will stand; walk; and lift and/or move up to 25 pounds. The employee occasionally will climb or balance; stoop, kneel, crouch or crawl; and taste or smell.
Specific vision abilities required by this job include close vision (clear vision at 20 inches or less), distance vision (clear vision at 20 feet or more), color vision (ability to identify and distinguish colors), peripheral vision (ability to observe an area that can be seen up and down or to the left and right while eyes are fixed on a given point), depth perception (three-dimensional vision, ability to judge distances and spatial relationships), and the ability to adjust focus (ability to adjust the eye to bring an object into sharp focus).
WORK ENVIRONMENT: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties and responsibilities.
While performing the duties of this job, the employee occasionally is exposed to working near moving mechanical parts, the risk of electrical shock, fumes or airborne particles, toxic or caustic chemicals and outdoor weather conditions when traveling away from the office for meetings, seminars, etc. The noise level in the work environment is usually moderate.