Data Operations Coordinator- Consulting Division

Responsibilities

• Process, clean, standardize, and organize donor and campaign data from multiple client and internal systems.
• Document assumptions, validation steps, and issue resolutions to support repeatable and auditable processes.
• Perform quality control checks on campaign files, reports, and data outputs, including record counts, field formatting, coding accuracy, and reconciliation against source files.
• Handle sensitive client and donor data with discretion, following internal data security, privacy, and file transfer procedures.
• Prepare, document, and transfer data files to and from production vendors, ensuring accuracy and timeliness.
• Ensure data integrity and troubleshoot discrepancies between client and internal databases.
• Use tools such as Azure, Fabric, SSMS, Power BI, and Excel to organize, transform, and visualize data.
• Maintain internal and client reporting templates.

• Process, clean, standardize, and organize donor and campaign data from multiple client and internal systems.
• Document assumptions, validation steps, and issue resolutions to support repeatable and auditable processes.
• Perform quality control checks on campaign files, reports, and data outputs, including record counts, field formatting, coding accuracy, and reconciliation against source files.
• Handle sensitive client and donor data with discretion, following internal data security, privacy, and file transfer procedures.
• Prepare, document, and transfer data files to and from production vendors, ensuring accuracy and timeliness.
• Ensure data integrity and troubleshoot discrepancies between client and internal databases.
• Use tools such as Azure, Fabric, SSMS, Power BI, and Excel to organize, transform, and visualize data.
• Maintain internal and client reporting templates.

• Manage and track data requests and internal team projects, ensuring all deliverables related to data and reporting are met on schedule.
• Monitor status updates, escalate bottlenecks, and proactively identify process improvements.
• Work with client services, data operations, and other internal team members to clarify data requests, confirm requirements, and communicate timelines, questions, and risks.
• Ensure version control and documentation for data processes, reports, and team deliverables.
• Maintain organized project records and assist with vendor coordination as needed.

• Participate in structured training in data tools (Azure, Fabric, SQL, Power BI), reporting workflows, and campaign data production, as well as direct response marketing principles.
• Gradually take ownership of data processing and analytical tasks — creating mail files for campaigns, updating weekly reporting, identifying trends, contributing insights, and evaluating test results.
• Proactively seek opportunities to improve data workflows and streamline production processes.

• Bachelor’s degree, equivalent coursework, certification, or relevant professional experience in data, analytics, marketing operations, information systems, or a related area.
• 0–2 years of experience in data operations, marketing operations, analytics, reporting, or a related field; internships, coursework, volunteer work, or project experience will be considered.
• Proficiency in Excel (pivot tables, formulas, data cleaning) and other Microsoft 365 applications.
• Interest in learning SQL, data transformation tools, and business intelligence platforms such as Power BI; prior experience is helpful but not required.
• Strong project management skills — detail-oriented and highly organized, adept at planning and prioritizing multiple projects and deadlines.
• Comfortable performing recurring, detail-oriented data tasks while looking for opportunities to improve and automate repeatable processes.
• Strong written and verbal communication skills, including the ability to ask clear questions, document processes, and collaborate with both technical and non-technical colleagues.
• Able to manage multiple priorities, stay organized, communicate when timelines or requirements are unclear, and meet deadlines with support from the team.

• Experience with nonprofit CRMs (e.g., Salesforce NPSP, Raiser’s Edge, Every Action).
• Knowledge of direct mail and digital fundraising metrics and integrated multi-channel campaign reporting.

Salary Range: $58,000- $68,000 annually