What are the responsibilities and job description for the Data Operations Coordinator- Consulting Division position at A.B. Data?
Key Responsibilities
Data Management & Production
Data Management & Production
- 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, EveryAction).
- Knowledge of direct mail and digital fundraising metrics and integrated multi-channel campaign reporting.
Salary : $58,000 - $68,000