Overview

The Systems Analyst position is primarily responsible for managing the integrity and integration of the various systems utilized for internal organizational process support including CRM (database administration), document imaging, digital gateway merchant processing, reporting, etc. for the purpose of strengthening relationships with donors, volunteers and friends of Portland Rescue Mission.

The Systems Analyst will provide overall administration of CRM and auxiliary systems, specifically the (open source) CRM donor management system CiviCRM. The ideal candidate knows their way around relational databases and has deep familiarity with structured data, SQL, and (UNIX based) scripting. The Systems Analyst excels in owning the donor engagement lifecycle. This person will thrive in a multidisciplinary role, assisting staff in finance, contribution processing, engagement, marketing, donor relations, as well as a host of external vendors and suppliers that work in orchestra to cultivate existing donors and acquire new partnerships. The Systems Analyst embraces trouble-shooting to optimize the functionality and application of the various software systems that support the Portland Rescue Mission and has a passion for efficiency and problem solving. Our organization relies upon technology that facilitates daily workflow, and the Systems Analyst will be keen to improve efficiency and automation wherever possible.

The proper candidate will have a true can-do attitude, a warm and hospitable demeanor, an intuition for order and organization, an adaptable temperament, and love of applied technology. They will operate in a highly creative, fast paced, deadline driven environment that seeks deepen connection, engagement, and stewardship with diverse audiences.

Essential Functions

  • Responsible for internal systems integrity, quality, and practical use to support organizational processes
  • Serves as the primary person for all things pertaining to CRM, including data I/O, ETL, reporting, and analysis
  • Takes data quality seriously and works to maintain a clean, hygienic, RDBMS system
  • Leverages and champions the various interdepartmental systems that assist in organizational process
  • Provides support and training to staff in all areas pertaining to system management
  • Continuously explores emerging tools and technologies for the purpose of optimizing back office processes and functions
  • Produces timely reports and analysis for various (print, digital, etc.) campaigns as well as other recurring (weekly, monthly, annually, etc.) performance results
  • Advises the organization on ongoing technology projects
  • Ability to simultaneously manage and implement multiple projects in various phases
  • Acts as primary technical contact and manages relationship with a host of external vendors (primarily for print and digital initiatives)
  • Attends regular meetings with support staff and various other team members to review upcoming projects, trainings, progress, workload, etc.

Qualifications

  • Has operational experience with relational databases, preferably MySQL
  • Well versed in optimizing structured data and writing SQL queries
  • Customer service focused
  • The ability and willingness to work harmoniously with diverse temperaments and talents
  • Creativity, initiative, excitement about utilizing systems to make strategic, data driven decisions
  • Knowledge of CRMs; familiarity with CiviCRM useful
  • Linux, Apache, MySQL, PHP familiarity preferred
  • Basic *NIX scripting (bash, tcsh, etc.) preferred
  • Strong Microsoft Excel skills
  • Excellent business analysis and problem-solving skills
  • Interpersonal skills including a consistently kind, warm, friendly disposition and attitude toward staff and clients
  • Ability to support people of varying technical skills
  • Previous experience in an end-user technical support role preferred
  • A quick, responsive, analytical mind
  • Ability to effectively communicate complex concepts in a concise, digestible fashion
  • Drupal/WordPress CMS experience is a plus
  • Familiarity with Microsoft Access preferred

Other Duties as Assigned:

In this and any position with Portland Rescue Mission, it is impossible to predict the many requests and assignments that can and will be made of an employee. Flexibility, responsiveness, and a cooperative spirit are crucial characteristics of the person who holds this important position and for the successful operation of Portland Rescue Mission services.

Knowledge, Skills, and Abilities

  • Multi-tasker, self-starter, deadline-driven. Plans ahead to meet production timelines.
  • “Customer-service” mentality
  • Prompt and thorough in job performance.
  • Analytical thinker and logical problem solver.
  • Highly detail-oriented. Thoroughly cares about work quality.
  • Demonstrated ability to be a team player.
  • Strong written and verbal communication
  • Proficient in Microsoft Productivity Suite (Excel, Word, Access)
  • Experience with project management software preferred.
  • Previous experience in nonprofit fundraising and direct mail preferred

Personal Attributes & Values

  • A personal relationship with Jesus Christ as Savior and a testimony of continued growth in faith
  • Spiritual maturity as defined by traditional Biblical Standards and growing in it through the regular practice of the spiritual disciplines
  • Adheres to Portland Rescue Mission’s Statement of Faith and Code of Ethics
  • Desire to serve God in the ministry to hurting men, women and children
  • A pleasant, gentle, grace filled manner and servant’s heart toward others
  • Genuine acceptance of constructive feedback with a “can do” attitude
  • Demonstration of excellent integrity
  • Composed and professional demeanor
  • Ability to effectively handle multiple tasks as assigned
  • Ability to lift at least 50 lbs. unassisted

Benefits

  • Lunch, drinks, coffee, etc. provided at no cost to employees most weekdays
  • Up to 2 hours weekly paid volunteer/service opportunities in the area of your choice (examples: running team, music ministry, teaching, art classes, dance classes, etc.)
  • Medical, Dental, Optical
  • Matching retirement contributions
  • Positive, congenial, purposeful and supportive work environment
  • Healthy work-life balance

Equipment Used:

  • Telephone, fax and voice mail
  • Computer (Apple or PC, your preference)
  • Copier and related office equipment

Mission Statement:

We share the Word of God and demonstrate the love of Christ to transform the lives of people experiencing homelessness or addiction.

About Portland Rescue Mission

Founded in 1949 by John Van Diest Sr., Portland Rescue Mission opened its doors as the “John 3:16 Mission.” From its earliest days of ministry, the words of that verse of salvation and hope have been at the heart and soul of our motivation for service: “For God so loved the world that He gave His only Son…”

John Van Diest Sr. started humbly serving with the limited resources he had, purchasing groceries himself to make a pot of soup to share with hungry men. Afterwards, he would share with them about God’s love.

Since then, the Portland Rescue Mission has had a tireless commitment to breaking the cycle of homelessness, addiction and despair in the lives of hurting people in need.

Today, we still offer emergency services of food and shelter at our original downtown location at the Burnside Shelter. And we’ve expanded those services to include 24/7 restrooms, showers, clothing, mail service, referrals and community activities in the Guest Care Center.

Thanks to generous community support, we’ve expanded our ministry to include a wide range of programs designed to meet a hurting person at their point of need and help them toward their journey home. This includes our 3-month Connect program for men and women, and our New Life Ministries for men and women at The Harbor and Shepherd’s Door, respectively.

Portland Rescue Mission also includes our Drive Away Hunger car sales and donations program and Mission Bar-B-Que catering. Proceeds support all of our programs to give hope and restore life to hurting people in need.