Data Operations Coordinator

Japan Society•New York, NY

19h•$65,000 - $74,000•Hybrid

About The Position

The Data Operations Coordinator manages Japan Society’s constituent data, ensuring the seamless flow of reliable information to our Development, Finance, and Operations teams. This role oversees the day-to-day architecture where Raiser’s Edge NXT serves as the central hub for related systems, including ticketing and marketing platforms. The position requires technical precision to handle intricate integrations using tools like ImportOmatic and Power BI, as well as ongoing data quality work that balances automation with high-volume, hands-on validation and manual cleanup. You will serve as the bridge between raw data and actionable insights, ensuring that our fundraising and box office teams have the accurate information they need to succeed.

Requirements

Bachelor’s degree (or applicable technical certification) plus 1–3 years of experience in data operations or database administration.
Strong command of Raiser’s Edge NXT backend architecture and ImportOmatic profiles is required.
Proven ability to execute high-volume manual data processes with a high degree of accuracy, discipline, and attention to detail.
Ability to troubleshoot technical issues and explain them clearly to non-technical stakeholders.

Nice To Haves

Familiarity with ticketing platforms (e.g., Ticketure, SRO4, Tessitura).
Experience with data visualization tools like Power BI or Microsoft Access .
Experience with Kibana/Elastic (KQL/ES|QL) query languages.
Experience managing Stripe payment integrations.

Responsibilities

Data Integration & Integrity
Daily Integrations: Manage and oversee recurring data imports from Ticketure and other external systems into Raiser’s Edge NXT using ImportOmatic.
Exception Handling: Serve as the first line of defense for data quality by manually verifying and resolving data exceptions, including duplicate records, address verification issues, and coding errors. Proactively identify recurring data issues and implement process to reduce manual remediation over time.
Payment Reconciliation: Oversee payment processing integrations (Stripe) and collaborate with Finance to ensure accurate reconciliation between fundraising, ticketing, and the general ledger.
Reporting, Analytics & Visualization
Dashboards & Queries: Design, build, and maintain queries and dashboards in Raiser’s Edge NXT to support fundraising, ticketing, and program evaluation. Ensure reporting structures are scalable, consistent, and aligned with organizational metrics and goals.
Advanced Analytics: Develop and maintain visual reports using Kibana and Power BI to analyze data trends and deliver insights across departments. Work closely with Development, Finance, Marketing, and program teams to translate business questions into meaningful analytics.
Marketing Support: Generate, validate, and cross-check Mailchimp lists based on the Marketing team’s audience segmentation criteria, ensuring data accuracy and adherence to constituent preferences.
Database Administration & Maintenance
System Integrity & Governance: Maintain and audit 220,000+ constituent records, enforce data entry standards, and ensure long-term data health and reporting reliability.
User Support & Knowledge: Act as the primary contact for database questions, train staff, and maintain documentation to preserve institutional knowledge.
Data Security & Compliance: Handle sensitive constituent and payment data according to organizational policies, privacy best practices, and PCI standards.
Operations Collaboration: Support IT and Operations teams on data initiatives and other duties as reasonably assigned to align systems and projects with organizational objectives.