Data Management Analyst

The Salvation Army USA Central Territory; Hoffman Estates (IL); Hybrid; USD 69,544 - 86,930; Full time

Benefits offered by this job

Hybrid work model

Job summary

The Salvation Army USA Central Territory is seeking a Data Management Analyst to turn data into impact through analytics that support program outcomes and grant reporting.

Based in Hoffman Estates, IL, this hybrid role combines data analysis with collaboration across territorial and divisional teams to improve services and drive mission-focused decision-making. The position requires strong SQL, WellSky, and Power BI skills, and a commitment to data governance in a nonprofit setting.

Qualifications

• Bachelor's degree required; Master's preferred in research, program evaluation, or statistics.
• Two years of relevant data management experience using SQL, WellSky, SAP, or Access.
• Strong analytic background with emphasis on quantitative analyses.
• Experience with non-profit/social service organizations and grant reporting.

Responsibilities

• Manage internal and external data for SIMS-based programs and WellSky.
• Develop and deliver program outcome reports for territorial and divisional teams.
• Collaborate with CMSA and program staff to optimize data collection and interpretation.
• Design and implement data extraction methods for outcome measurement (e.g., Pathway of Hope).
• Support grant reporting through data synthesis and reporting to stakeholders.
• Ensure data quality, consistency, and readiness for analysis and reporting.

Skills

SQL

Data analysis

Power BI

Microsoft Excel

Report writing

Education

Bachelor's degree

Master's degree preferred

Tools

WellSky Community Services

SAP Business Objects

Access

SAP

Job description

Please note this position does not include relocation, support sponsorship, or a fully remote option. The position is hybrid in nature, two remote days and three in-office days, so candidates must reside within a reasonable commuting distance from Hoffman Estates

Turn data into impact. Join The Salvation Army as a Data Management Analyst and help drive mission-focused decision making through meaningful data insights. In this role, you'll analyze program outcomes, support grant reporting, and help strengthen services that impact communities across the territory. If you're passionate about data, problem-solving, and using analytics to support programs that change lives, we'd love to hear from you.

Compensation Range: $69,544 to $86,930/annually, based on experience.

The Salvation Army Mission:

The Salvation Army, an international movement, is an evangelical part of the universal Christian church. Its message is based on the Bible. Its ministry is motivated by the love of God. Its mission is to preach the gospel of Jesus Christ and to meet human needs in His name without discrimination.

Job Objective:

The Data Management Analyst is responsible for managing, analyzing, and reporting of outcome data to the territorial and divisional teams in support of organizational functions including operational, strategic decision-making, and grant funding analysis/reporting.

Essential Functions:

The Data Management Analyst works within the Territorial Social Services Department and is responsible for providing internal and external data management and analysis for social service programs utilizing Salvation Army Information Management System (SIMS) including Pathway of Hope, Housing, Case Management, Material Assistance, Seasonal Assistance, Adult Rehabilitation Centers, Anti-Trafficking, Program Evaluation, and Emergency Disaster Services. SIMS is the primary system utilized to manage client information, supported by WellSky Community Services. The Data Management Analyst contributes to strategic decision making, programmatic outcomes, contract compliance, and grant funding reporting. This job description is not all inclusive. Other job-related responsibilities and tasks may be assigned.

Development of Systems for Data Management and Analysis

• Work collaboratively with the Client Management Systems Administrators (CMSA) to ensure that The Salvation Army Information Management System (herein called "SIMS") to ensure that its architecture and functionality facilitates the information needs of the organization and the accessibility by end uses.
• Function as the primary report writer using WellSky Community Services and SAP Business Objects for territorial level reporting. Provide report writing assistance to divisional social services staff.
• Consult with both Territorial and Divisional program directors to support the full implementation of SIMS and ensure that it addresses and supports programmatic goals and quality assurance functions.
• Work collaboratively with the CMSA's and program personnel to facilitate the collection, analysis, and interpretation of quantitative and qualitative data.
• Design and execute data extraction methodologies in support of outcomes measurement of assigned projects, including Pathway of Hope (POH).
• Develop, organize, and manage client indicators utilizing Excel, WellSky Community Services, SurveyMonkey, MS Office Forms, SA National Statistical System and other data management systems.
• Review data for accuracy in preparation for conducting analysis of data for client and programmatic outcomes measurements and reporting.
• Promote consistency in use of data across the organization to ensure consistent and accurate management analyses and reports.
• Support the development of interpretation and summarization of outcome results including synthesizing information from multiple sources, creating succinct, clear, and actionable summaries in order to improve the quality and performance.
• Assist Territorial and Divisional teams with data implications and utility in order to build capacity to utilize data for program management and improvements.
• Develop and generate summaries that meet requested reporting criteria for both internal and external requirement in a timely, accurate and consistent manner.
• Develop and maintain management reports in support of any type of program\'s evaluation and operational performance as requested.
• Support the training and staff development plan to ensure use of SIMS in an accurate manner by end users.
• Work collaboratively with the SIMS Committee and Divisional System Administrators to address systems wide quality improvements and additional data needs.
• Work collaboratively with national and other territorial System Administrators to address systems wide quality improvements and additional data needs.
• Communicate clearly and concisely through both written and verbal reporting of data implications, trends, and results tied to established outcome measures.
• Assist territorial and divisional grant writing staff to mine specific data for new social services grant proposals.
• Assist divisional staff with program evaluation and the DHQ/THQ review processes.
• Maintain an active relationship with the Territorial Statistical Bureau.
• Maintain a thorough knowledge of the WellSky Community Services and other approved internal and external systems, upgrades, and version releases.
• Attend educational opportunities when appropriate.
• Other duties as assigned.

Minimum Qualifications:

The requirements listed below are representative of the minimal education, experience, knowledge, skills, and/or abilities required for this position.

Education: Bachelor\'s degree required along with applicable work experience. Master\'s degree preferred in research, program evaluation, and statistics.

Experience:

• Two of relevant experience, including at least two years conducting data management using a variety of software required (e.g., SQL, WellSky Community Services, SAP, or Access).
• Strong analytic background; at least 2 years conducting and interpreting quantitative analyses.
• Experience with non-profit/social service organizations
• Familiarity with planning, generating and collating survey results utilizing SurveyMonkey or other survey tools.

Certifications: No specific certification required.

Skills:

• Ability to speak, write and understand English in a manner sufficient for effective communication with leadership and field personnel.
• Excellent computer skills to include: Microsoft 365: Excel, Access, PowerPoint and other applications in the office suite; SQL, SPSS or SAS, and Power BI
• Previous completion of SIMS Community Services Systems Administrator Training and SAP Business Objects Reporting highly desired.
• Excellent data management skills
• Experienced and skilled in using a variety of techniques ranging from simple data aggregation to complex data mining.
• Advanced knowledge of research methodology
• Excellent data interpretation skills as well as report development and presentation of information.
• Strong interpersonal and collaboration skills; able to act in a professional and effective way with internal and external teams.
• Excellent written and verbal communication skills.
• Ability to organize and prioritize work.
• Must be able to work with others to anticipate, identify and solve problems related to individual database use or system-wide issues.
• Understands program evaluation processes and techniques, and best practices regarding evaluative research.

Supervisory Responsibility: None

Physical Requirements:

Physical requirements include:

• Sit, walk, stand, bend, squat, climb, kneel, and twist on an intermittent or occasional continuous basis.
• Grasp, push, pull objects such as reference materials, files, file cabinet drawers, and reach overhead.
• Ability to load and to change settings, devices, fixtures, on various equipment used in and around an office environment.
• Operate telephone and other electronic communication devices.
• Operate various other office equipment including personal computers, copiers, fax machines, and scanning equipment.
• Ability to lift up to 25 lbs. occasionally.
• Ability to travel throughout the territory via car, train or airplane.

Travel:

Travel, including overnight and weekends, will occasionally be required.

Working Conditions:

Full-time position; may require some weekend and evening work.