Data Analyst

Goodwill-Easter-Seals-Miami-Valley-3; Dayton (OH); On-site; USD 65,000 - 90,000; Full time

Job summary

Goodwill-Easter-Seals-Miami-Valley-3 seeks a data analytics specialist to transform complex datasets into actionable KPIs and reports. The role supports IT leadership and program staff by running reports, validating data, and delivering dashboards across agency systems.

Strong Excel and BI skills are essential, with experience in Salesforce, Counterpoint, Kronos, or Sage valued. You will work fully on-site in Dayton, collaborating with stakeholders to ensure timely, accurate data insights for

Qualifications

• Associate’s degree preferred.
• Experience with Excel and reporting tools required.
• Ability to consolidate data from multiple systems for analysis.
• Strong communication and organizational skills.
• Experience with BI/reporting tools like Power BI beneficial.

Responsibilities

• Run and monitor ongoing and recurring reports and dashboards per contract requirements.
• Maintain monthly, quarterly, and annual reports (census, outcomes, annual reports).
• Ensure accuracy of data in BI systems and program records.
• Prepare KPI information and BI reports for staff and leadership.

Skills

Excel

Power BI

Data analysis

Communication

Attention to detail

Teamwork

Microsoft Office

Education

Associate’s degree in data analytics or CIS

Tools

Salesforce

Counterpoint

Kronos

Sage

Job description

This is a 100% on-site position

Summary

This position exists to facilitate data extraction from multiple agency software systems and transforms large, complex datasets into meaningful and actionable insights for various organizational stakeholders in the form of KPIs, business analytics, and other reports.

Essential Duties & Responsibilities

• Manages/completes special projects delegated by the Director of Information Technology as required with a wide variety of non-routine tasks.
• Run and monitor ongoing and recurring reports and dashboards in accordance with contract requirements.
• Maintain various monthly, quarterly, and annual report processing, ensuring accuracy and timeliness. Including, but not limited to, census reporting, outcome measurement and tabulation reports, annual reports and more.
• Ensure accuracy of all information being captured by BI or any other daily reporting system.
• Ensure accuracy of data collected and maintained in all program systems or BI systems for persons referred for services, program new starts, all unduplicated program customers and their disabilities, program dates, placement activity, exit interviews, survey information, and all follow-up information.
• Communicate and post Key Performance Indicator (KPI) information and other BI reports to staff; post relevant and up-to-date material on identified boards and
• Ability to combine and consolidate data from multiple systems to perform analysis and suggest system improvements.
• Development and maintenance of data source configurations used in BI and other reports.
• Prepare other miscellaneous reports ensuring accuracy and timely completion.
• Maintain strictest confidence regarding reports and confidential material.
• Provide technical support for existing reports, spreadsheets, dashboards, and other tools. Including demoing and training end-users on data solutions.
• Maintain an effective and efficient data management system for the Transportation Department.
• Comply with all Agency policies, procedures, and safety standards throughout work areas and maintain the same to meet CARF, Department of Labor and other regulatory standards.
• Other duties as assigned.

Supervisory Responsibilities

None

Education Requirements

Associate’s degree in data analytics or computer information systems is preferred.

Experience Requirements

• Microsoft Excel experience required.
• Experience with the following systems is a plus: Salesforce (CRM), Counterpoint (POS), Kronos (HCMS), Sage (Finance), Power BI (BI).

Qualifications

• To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. 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 functions.
• Employee must maintain a valid driver’s license and a driving record acceptable to Goodwill’s liability insurance provider. If at any time the employee is unable to maintain a valid driver’s license and a driving record acceptable to GESMV’s liability insurance provider, they must immediately notify Human Resources.
• Must maintain the ability to pass a criminal background check and random drug screens.

Skills & Abilities

• Must have a strong understanding of the application software and tools by which to extract or interface with other software applications to generate meaningful data for management use.
• Must be able to quickly shift priorities.
• Must be detail-oriented and have strong organizational skills.
• Ability to communicate effectively.
• Proficient in Microsoft Office suite.
• The ability to work semi-independently, as well as have the ability to work cooperatively as a team member.

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 functions.
• While performing the duties of this job, the employee is regularly required to stand and walk; use hands to finger, handle, or feel objects, tools, or controls; reach with hands and arms; and talk or hear.
• The employee is occasionally required to climb or balance; stoop, kneel, crouch, or crawl; and taste or smell.
• The employee must regularly lift and/or move up to 10 pounds, frequently lift and/or move up to 25 pounds, and occasionally lift and/or move up to 50 pounds.
• Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust 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 functions.
• While performing the duties of this job, the employee occasionally works in outside weather conditions and is occasionally exposed to risk of electrical shock.
• The noise level in the work environment is usually moderate.