Donor System Analyst

ANDREW WOMMACK MINISTRIES INC•Woodland Park, CO

2d•$24 - $28•Onsite

About The Position

The Donor System Analyst supports and administers a portfolio of cloud-based platforms, including donor management and CRM systems, digital content and streaming platforms, eCommerce and marketplace integrations, and video distribution channels. The role helps the organization manage and optimize its donor, customer, and digital commerce ecosystem by maintaining reliable integrations, automated data flows, and accurate reporting. It involves data analysis, SQL development, integration support, reporting, and cross-system troubleshooting to support operational efficiency and data-driven decisions. The analyst works independently and collaboratively, takes ownership of assigned tasks within defined scopes, and serves as a technical resource and liaison between business teams and IT. The position is based at AWM HQ in Woodland Park, Colorado, is full-time, and has a day shift. Compensation is listed as $24.04–$27.88 per hour and is commensurate with experience.

Requirements

At least 2 years of work experience in a Microsoft SQL Server environment.
Ability to write and debug SQL queries and stored procedures.
High school diploma or equivalent education.
Good verbal and written communication skills.
Strong analytical and problem-solving skills, accuracy, and attention to detail.
Advanced SQL skills and a solid understanding of relational database design and logic.
Experience with system integrations and automated data workflows using low-code or SaaS-based integration tools.
Experience with SSMS, SSRS, ETL tools, and data integration concepts.
Ability to work independently and manage multiple priorities in a fast-paced environment.
Strong organizational skills, self-direction, and ability to handle a wide variety of tasks with minimal supervision.
Ability to communicate with a wide variety of people, including technology vendors.
Personal relationship with Jesus Christ and willingness to sign the Statement of Faith.
Must pass all required checks.
Proven work experience in a Microsoft SQL Server environment, including experience with MS SQL Server 2014–2022.

Nice To Haves

Charis Bible College student or graduate.
Experience with DonorDirect Studio Enterprise or other donor management systems.
Experience working with ETL tools.
Experience building or supporting reporting, dashboards, or analytics solutions using business intelligence platforms.

Responsibilities

Support, maintain, and enhance donor management, CRM, digital content delivery, eCommerce, and online marketplace platforms.
Manage and support integrations between internal and external platforms, including donor systems, CRM, streaming and content delivery services, online storefronts, marketing channels, and video distribution platforms.
Develop, monitor, and troubleshoot automated workflows using cloud-based, low-code integration platforms, including data synchronization, event processing, and error handling.
Develop, test, and maintain custom SQL queries, scripts, and stored procedures for reporting, segmentation, reconciliation, and system enhancements.
Analyze and resolve data discrepancies across interconnected systems, identify root causes, and implement accurate, auditable data corrections.
Import, transform, validate, and manage data using ETL and integration tools for operational processes, analytics, and reporting.
Support digital commerce and online marketplace integrations, including product data, transactions, subscriptions, and fulfillment-related data flows.
Support digital video platform integrations, including content metadata, user access, entitlement data, and engagement metrics.
Build and maintain datasets, dashboards, and visual reports using enterprise business intelligence and analytics platforms.
Partner with internal teams to translate business needs into technical and data solutions.
Assist system administrators with database access, integration monitoring, reporting validation, and operations support.
Perform controlled mass updates and data fixes in production environments under supervision, maintaining data integrity and compliance with internal controls.
Document system configurations, integration logic, data flows, and reporting definitions.
Participate in testing, validation, and rollout of system changes, integrations, and platform enhancements.
Serve as a technical resource and liaison between business teams and IT, helping stakeholders understand system behavior and data dependencies.
Perform other duties as assigned.