Donor System Analyst

Andrew Wommack Ministries; Woodland Park (CO); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Paid time off

Paid holidays

401(k) retirement plan

Flexible spending account

Job summary

Andrew Wommack Ministries is seeking a Donor System Analyst to manage donor management and CRM, streaming and digital commerce integrations, and data reporting. The role emphasizes reliability, data accuracy, and cross-system troubleshooting in a cloud-based environment.

You will build and optimize ETL processes, create SQL reports, and partner with teams to translate business needs into technical data solutions. A strong emphasis on data integrity and auditable changes is required.

Qualifications

• Experience with Microsoft SQL Server environments and SQL queries/stored procedures.
• Experience building and supporting reporting, dashboards, and analytics solutions.
• Experience with system integrations and automated data workflows using low-code or SaaS-based tools.

Responsibilities

• Support and administer donor management, CRM, digital content delivery, eCommerce, and marketplaces.
• Develop, monitor, and troubleshoot automated data workflows and integrations.
• Design and maintain SQL queries, scripts, and stored procedures for reporting and reconciliation.
• Analyze data discrepancies and implement auditable corrections across systems.
• Create datasets and dashboards for technical and non-technical stakeholders.

Skills

SQL

SSMS/SSRS

ETL tools

Data analysis

Data integration

Low-code platforms

SaaS

Communication

Education

High school diploma

Charis Bible College student/grad preferred

Tools

MS SQL Server

DonorDirect Studio Enterprise

Job description

Position Purpose:The Donor System Analyst is an excellent communicator, personable, and able to work independently as well as collaboratively within a team. This role takes ownership of assigned tasks and works within defined scopes to help the organization effectively manage and optimize its donor, customer, and digital commerce ecosystem.This position is responsible for supporting and administering a portfolio of cloud-based platforms, including donor management systems, customer relationship management systems, digital content and streaming platforms, eCommerce and marketplace integrations, and video distribution channels. The role ensures reliable system integrations, automated data flows, and accurate reporting across platforms using low-code integration tools, relational databases, and enterprise analytics solutions. Responsibilities include data analysis, SQL development, integration support, reporting, and cross-system troubleshooting to enable operational efficiency and data-driven decision-making.Essential Duties:Support, maintain, and enhance donor management, CRM, digital content delivery, eCommerce, and online marketplace platforms to ensure system stability, data accuracy, and operational effectiveness.Manage and support system integrations across internal and external platforms, including donor systems, CRM, streaming/content delivery services, online storefronts, marketing channels, and video distribution platforms.Develop, monitor, and troubleshoot automated workflows using cloud-based, low-code integration platforms, ensuring reliable data synchronization, event processing, and error handling across systems.Develop, test, and maintain custom SQL queries, scripts, and stored procedures to support 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 to support operational processes, analytics, and reporting needs.Support integrations related to digital commerce and online marketplaces, including product data, transactions, subscriptions, and fulfillment-related data flows.Support integrations related to digital video platforms, 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 to provide insights to technical and non-technical stakeholders.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, ensuring data integrity and compliance with internal controls.Document system configurations, integration logic, data flows, and reporting definitions to support operational continuity and knowledge sharing.Participate in testing, validation, and rollout of system changes, new integrations, and platform enhancements.Serve as a technical resource and liaison between business teams and IT, helping stakeholders understand system behavior and data dependencies.Other duties as assigned.Knowledge, Skills, and Abilities:Good verbal and written communication skills.Strong analytical and problem-solving skills, with a high level of accuracy and attention to detail.Advanced SQL skills to write and debug SQL queries and stored procedures, and a solid understanding of relational database design and logic.Experience working 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.Highly self-motivated with the ability to work independently and manage multiple priorities in a fast-paced environment.Detail-oriented with strong organizational skills and a commitment to excellence and service in all tasks.Very self-directed – The ability to handle a wide variety of tasks with minimal supervision.Ability to communicate with a wide variety of people, including technology vendors.Requirements:Must have a personal relationship with Jesus Christ.Must sign the Statement of Faith.Minimum 2 years of work experience in a Microsoft SQL Server environment.Ability to write and debug SQL queries and stored procedures.A high school diploma or equivalent education is required.A Charis Bible College student or graduate is preferred.Must pass all required checks.Experience:Proven work experience in a Microsoft SQL Server environment.Experience working with MS SQL Server 2014-2022.Experience working with DonorDirect Studio Enterprise or other donor management systems is a plus.Experience working with ETL tools is a plus.Experience building or supporting reporting, dashboards, or analytics solutions using business intelligence platforms is preferred.Compensation is commensurate with experience.We offer a comprehensive benefits package for full-time employees to include the following: Medical, Dental, Vision, Paid Time Off (PTO), Paid Holidays per year (10), Flexible Spending Account (FSA)-Medical/Dependent Care, Health Savings Account (HSA), Voluntary Life and AD&D, Short Term Disability, Long Term Disability, 403(b) Retirement Plan, Life Assistance Program, Accident/Hospital, ID Shield/Legal Shield and TelehealthAbout Us: Andrew Wommack Ministries (AWM) is a teaching ministry of unconditional love and the balance between grace and faith. For over forty years, Andrew and Jamie have been teaching the truth of the Gospel to the body of Christ by teaching at seminars, in churches, on radio and television, by training others at Charis Bible College, and by developing ministry materials designed to help you in your relationship with the Lord. We are a family here at AWM, we like to have fun, and we love Jesus. You will find that our culture reflects just that. Our core values demonstrate that we serve God’s people with Excellence, Faithfulness, and Integrity.Are you interested in helping Andrew fulfill his vision to reach as far and as deep with the Gospel as possible?If so, we are looking for someone faithful, available, willing to learn; and passionate about taking the Gospel Truth to the world.Application Tips:Use a computer, not a hand-held device to applyUse Chrome as your browserAlways Sign Into the portal or create an account first before trying to fill out an applicationUse the NEXT and PREVIOUS buttons on the bottom of the application to navigate instead of the back button on your browser.Select an option for each drop-down questionIf you SAVE and want to come back later, use the NEXT and PREVIOUS buttons on the bottom of the page to navigate instead of the tabs on top.