Data Analyst

Description

Purpose, Vision, and Value Statement

The Tacoma Rescue Mission (TRM) is a faith-based nonprofit organization whose mission is to offer God’s help, hope, and healing to our neighbors in need. We are proud to have served the Tacoma and Pierce County communities since 1912. For over 100 years we have continued to serve in the name of Christ, while emphasizing the dignity of each person who enters our doors. We value the needs of our immediate community, and continually adapt to the changing needs of those who come to us for help.

We strive to cultivate a culture built on love and truth, where our integrity is never compromised. Our services and programs are continually measured for efficiency and effectiveness, are committed to quality, and operate through a trauma-informed, person-first, and grace-based approach.

Job Purpose

Helps manage TRM’s data systems and other support operations by assisting the Data Manager with organization-wide data management including HMIS (Homeless Management Information System) and TRM client database (Apricot) and other operations-related reporting needs. Primary responsibility of monitoring and maintaining data quality.

Tacoma Rescue Mission Competencies

Client Relationships and Interactions: Connect clients, volunteers, donors, team members, and guests to the mission and vision of The Tacoma Rescue Mission and its programs. Establish rapport and build relationships through effective communication, making all feel understood and valued. Assess needs and share appropriate resources, boosting client confidence in The Tacoma Rescue Mission and its team members.

Creativity and Expansion: Cultivate an environment that constantly seeks growth and adaptation, enhancing services offered. Research and develop new insights and strategies that improve Mission functionality and performance. Embrace the unknown and uncharted territory, pushing limits to increase skill, knowledge, and resources.

Leadership and Culture: Champions the Tacoma Rescue Mission’s core values and pillars, ensuring a high level of service with a commitment to changing lives. Creates a platform that empowers those within the Mission and the community to establish and take ownership of a culture founded on team, trust, and truth.

Professionalism: Carries the current knowledge and operational skills required to perform well, utilizing best practices and demonstrates the desire to grow professionally. Helps create a safe space for Team Members to hold others accountable for behavior and performance, empathetically listens and communicates for understanding when negotiating and dealing with conflict. Setting the standard of quality, providing staff with feedback, coaching, guidance, and support.

Requirements

 Essential Duties & Responsibilities

· Maintains a thorough understanding of the organization’s mission, vision, and values, industry best practices, and all government and other funding requirements.

· Serves as database administrator for HMIS and Apricot; designs and performs data clean-up and migration procedures.

· Monitors quality of staff data entry and identifies areas for data quality improvement.

· Develops and modifies reporting processes using database reports, dashboards, and advanced Excel formulas.

· Maintains and clarifies Standard Operating Procedures documentation.

· Trains staff in best practices concerning data collection, data entry, and using databases; provides ongoing database support.

· Coaches staff to learn and improve from data quality errors; provides feedback in a constructive way to encourage growth.

· Manages Apricot database, keeping it current with staff and program changes.

· Creates and revises database forms as needed.

· Collects, analyzes, and reports data from multiple sources in numbers, pivot tables, charts, or in narrative form as requested.

· Performs ad hoc reporting using a variety of data processing tools with little supervision.

· Troubleshoots complex and ambiguous data issues and explores and tests solutions.

· Collaborates with government and other organizations to resolve data-sharing issues as requested.

 · Enters data; validates and submits online reports to funders as requested. 

 · Performs other duties as assigned to support others and ensure an efficient and effective work environment.

Working Conditions

Long periods of working at a computer. Some local travel to various TRM sites. Some work interfacing with clients from diverse backgrounds.

Schedule:

Normal business hours with some flexibility.

Primary Location of Work:

Adams Street Family Campus

2909 S. Adams St., Tacoma, WA 98409

Minimum Qualifications

· Bachelor’s Degree in related field or equivalent experience.

· Advanced proficiency in MS Excel.

· Experience working with relational databases.

· Highly attentive to detail.

· Able to work independently with limited supervision.

· Understanding of exception reporting to improve data accuracy.

· Experience troubleshooting complex data issues and exploring and testing solutions.

· Skilled in clear and effective written, verbal, and electronic communication.

· Ability to establish and maintain effective working relationships and foster teamwork in a diverse environment using effective and thoughtful interactions and communication.

· Access to a vehicle for travel throughout Pierce County and TRM locations.

Preferred Qualifications

· Experience in data, Information Technology, Computer Science, Finance, or contract compliance.

· Hands-on experience with design, development, and support of data analysis.

· Adept at learning technical programs and skills.

· Master Proficiency in MS Excel.

· Skilled in writing SQL queries.

· Experience with database development and design including creating database forms and queries.

· Experience creating dashboards in Power BI or other BI/visualization tool.

· Skilled in identifying areas for process improvement.

Certificates & Licenses

HMIS Certification required, available upon hire.

Physical Requirements

· Stationary position 90% of the time.

· Occasionally moves about inside the office to access file cabinets, office machinery, etc.

· Frequently operates a computer and other office productivity machinery, such as a calculator, copy machine, and computer printer.

· Communicates information and ideas so others will understand. Exchanges accurate information in these situations.

· Observes details at close range (within a few feet of the observer).

· Access to a vehicle for frequent travel throughout the region.