Impact Support Specialist

Denver Rescue Mission; Denver (CO); On-site; USD 37,000 - 45,000; Full time

Benefits offered by this job

Health plans: medical, dental, vision

Paid time off and holidays

Tuition reimbursement

Life insurance

Health savings account

Flexible spending accounts

Parental and bereavement leave

401(k) with company match

DRM Benefits Guide

Job summary

Denver Rescue Mission seeks an Impact Systems Support Specialist to optimize systems measuring program impact and service quality. You will leverage SQL and SSRS to support CaseWorthy, Microsoft SQL Server databases, Salesforce, NetSmart, and related apps across departments.

The role emphasizes data integrity, security, and continuous improvement through reports and dashboards while collaborating with program staff and IT stakeholders.

Qualifications

• Bachelor's degree in information systems, computer science, or related field preferred.
• Experience working in CRM is required.
• Two years experience with SSRS and Microsoft SQL Server.

Responsibilities

• Provide technical support for impact systems and related applications, including issue tracking and root cause analysis.
• Build and maintain reports and dashboards in SSRS to inform decision-making.
• Support configuration and integration of CaseWorthy, Salesforce, and NetSmart EHR systems.
• Collaborate with departments to ensure data integrity, security, and alignment with goals.

Skills

SQL

SSRS

CRM knowledge

Education

Bachelor's degree

Tools

CaseWorthy

Salesforce

NetSmart

Job description

Description

Hiring Range: $27 - $33 hourly, based on qualifications and experience.

BENEFITS AND PERKS:

• Comprehensive health plans include medical, dental and vision benefits.
• Generous vacation, sick time, and holiday pay, plus paid birthday off and 'refreshment' day.
• Tuition reimbursement and child adoption benefits.
• Employer paid term life insurance, long-term disability, AD&D.
• Health savings account with generous employer contribution.
• Flexible spending accounts.
• Paid parental and bereavement leave.
• 401(k) with up to 5% company match.
• Denver Rescue Mission Benefits Guide

POSITION SUMMARY

The Impact Systems Support Specialist maintains and optimises systems that enable the organization to measure program impact and ensure high-quality service delivery. This position leverages expertise in SQL and SSRS to serve as critical support for DRMs Customer Relationship Management platforms such as CaseWorthy (DRMs primary CRM), Microsoft SQL Server databases, Salesforce, NetSmart (DRMs Electronic Health Record) and other key applications.

RESPONSIBILITIES

General Impact Systems Support

• Provides technical support for all impact systems and related applications, including issue tracking, troubleshooting, and root cause analysis.
• Performs quality assurance testing on all technical changes to ensure reliability, accuracy, and performance.
• Provides support for feature adds on all CRM, case management, and EHR databases.
• Builds and maintains actionable reports and dashboards in SSRS (SQL Server Reporting Services) and other platforms to inform decision-making.
• Collaborates with the Impact System Administrator to assess risk and support change-management processes.
• Participates in vendor and partner selection for future database enhancements and development projects.
• Coordinates and communicates regularly with the Program Department to ensure database integrity, security, and alignment with organizational objectives.
• Contributes to continuous improvement initiatives that use data and technology to improve operational efficiency and service outcomes.

EHR System Support

• Supports the configuration, maintenance, and optimization of the organization’s Electronic Health Record (EHR) system (Netsmart), including forms, workflows, user roles, and security permissions.
• Serves as a point of contact for clinical and program staff on EHR questions and provides end-user training and documentation.
• Supports data integrity and compliance with HIPAA, 42 CFR Part 2, and other applicable privacy and security regulations.
• Assists with EHR upgrades, release testing, and coordination with the vendor.
• Maintains the API connection between NetSmart and DRM internal forms.

Salesforce Support

• Supports with tier one, and eventually tier two, case submissions for Salesforce maintenance.
• Supports the Salesforce Administrator with Salesforce advancement by collaborating with appropriate teams.

CaseWorthy Support

• Supports with tier one, and eventually tier two, case submissions for CaseWorthy maintenance.
• Acts as a support to the Director of Impact and Compliance to support data integrity and compliance for governing contracts.
• Supports the Impact System Administrator with the case management system, including configuration and customization.

Professional Development

• Engages in ongoing DRM trainings, completing in a timely manner.
• Pursues appropriate credentials (SQL Server, Salesforce Administrator, PowerBI Data Analyst Associate, etc.).
• Complete a 2-hour volunteer shift in one of the DRM shelter locations each month.
• Regularly reflects on progress toward professional goals, both individually and with supervisor, identifying and following through on learning opportunities.?
• Identifies opportunities to mitigate stress and engages in sustainability and wellness check-ins.?
• Other duties as assigned.

Requirements

MINIMUM QUALIFICATIONS

• Bachelor's degree in information systems, computer science, or related field preferred.
• Experience working in CRM (Client Relationship Management) is required.
• Two years experience with SSRS/Microsoft SQL Server.
• Excellent computer and database knowledge.
• Excellent troubleshooting and problem-solving skills required.
• Strong interpersonal and communication skills with the ability to collaborate across departments.
• Active Driver's License and ability to meet DRM insurability standards, as a limited amount of work-related travel may be required.
• Must be a Christian holding to the beliefs set forth in the Statement of Faith, expressed by a personal testimony and Christian conduct.

Denver Rescue Mission is both an equal opportunity employer and a distinctly faith-based Christian organization. Denver Rescue Mission complies with applicable federal, state, and local employment laws, and strictly prohibits and does not tolerate discrimination against employees, applicants, or any other covered persons because of race, color, national origin or ancestry, ethnicity, sex, sexual orientation, gender identity, age, disability, citizenship, parental status, marital status, political ideology, or current or prospective service in the uniformed services. This policy applies to all terms, conditions, and privileges of employment including recruitment, employment, training, and promotion opportunities. Based upon Title VII of the Civil Rights Act of 1964, the Colorado Anti-Discrimination Act, and the U.S. Constitution, Denver Rescue Mission has the right to, and does, hire only candidates who agree with our Statement of Faith and align with our Christian mission.

Our organization uses E-Verify.

This posting is expected to close 1/1/2027 or when filled.