Donor System Analyst
Summary
Administers and supports Andrew Wommack Ministries' cloud ecosystem of donor management, CRM, streaming/content, and eCommerce platforms. Day to day involves SQL development, low-code integration workflows, ETL data flows, cross-system troubleshooting, and BI dashboards and reporting.
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.