Data Operations Coordinator- Consulting Division
A.B. Data is a consulting company seeking a Data Operations Coordinator to manage and analyze donor and campaign data. The role involves data management, project coordination, and participation in learning opportunities to enhance data workflows and processes.
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
- 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
Skills
- 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, EveryAction)
- Knowledge of direct mail and digital fundraising metrics and integrated multi-channel campaign reporting
Company Overview