Data Management Analyst

Overview 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 Compensation Range: $69,544 to $86,930/annualy, based on experience. 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 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. Mental Requirements Ability to be creative, original, intuitive, and perceptive. Ability to think logically and critically. Ability to envision a project from beginning to end. Ability to solve complex problems, make appropriate judgments and decisions. Travel Travel, including overnight and weekends, will occasionally be required. Working Conditions Full-time position; may require some weekend and evening work. #J-18808-Ljbffr The Salvation Army North & Central Illinois Division