Direct Response Database Developer

Description The Direct Response Database Developer is a data operations engineer responsible for developing, maintaining, and optimizing reliable, automated, and AI-enabled data pipelines that support direct response fundraising performance. This role ensures that client donor and marketing data moves accurately from ingestion through campaign execution, reporting, and analysis by managing data cleansing, transformation, mapping, validation, and preparation to create timely, trusted, and campaign-ready data assets. Working within the Campaign Operations function of Data Solutions, the Direct Response Database Developer partners closely with Data Analysts, client teams, and other stakeholders to translate fundraising and direct marketing requirements into scalable data solutions. The role requires strong SQL and relational database expertise, rigorous attention to data quality, and the ability to build increasingly automated processes that power audience segmentation, personalized direct marketing communications, campaign execution, analytics, and actionable fundraising insight. Key Responsibilities Partner with Data Analysts, client teams, and client stakeholders to understand business requirements, campaign objectives, priorities, and data specifications. Load, cleanse, transform, and summarize client donor and marketing data in accordance with established data processing standards. Develop and maintain SQL queries, stored procedures, views, triggers, and other database objects necessary to support campaign operations and data delivery. Customize data mappings, transformations, and business rules based on client requirements and campaign specifications. Develop and execute data ingestion and validation processes to ensure client data is complete, accurate, and available according to established timelines. Prepare and validate data files used for direct marketing communications, audience segmentation, campaign execution, and other client deliverables. Work with complex and large-scale datasets across multiple client environments and data sources. Troubleshoot data processing, database, mapping, and file-related issues and implement appropriate resolutions. Perform quality assurance and validation of data outputs to ensure adherence to client-approved business rules and internal standards. Participate in peer reviews and desk checks of client deliverables to support data quality and accuracy. Support Data Analysts with data preparation for reporting, analysis, visualization, dashboards, and fundraising insights. Contribute to project planning by identifying data requirements, dependencies, timelines, milestones, and potential delivery risks. Identify opportunities to automate and optimize recurring data processes to improve accuracy, efficiency, scalability, and turnaround times. Utilize AI and emerging technologies, where appropriate, to improve data processing, quality assurance, troubleshooting, documentation, and workflow efficiency. Maintain appropriate documentation of data processes, mappings, business rules, and technical solutions. Qualifications Education & Experience: Bachelor’s Degree (BA or BS) in Computer Science, Information Systems, Data Management, or a related field. 3–5+ years of experience in database development, data processing, data operations, or a related field, or an equivalent combination of education and experience. Preferred experience includes: Experience supporting direct marketing, fundraising, nonprofit, agency, or other data-intensive campaign environments. Strong experience with Microsoft SQL Server or another relational database platform such as MySQL, Oracle, or PostgreSQL. Experience developing stored procedures, database triggers, views, queries, and other database objects. Experience with data ingestion, cleansing, transformation, mapping, segmentation, and validation. Experience working with large and complex donor, constituent, customer, or marketing datasets. Experience with reporting and visualization technologies such as Power BI, SSRS, or Tableau. Experience with version control tools such as Git, TFVC, SVN, or similar platforms. Knowledge, Skills & Abilities: Strong understanding of relational database concepts, structures, and data processing methodologies. Ability to develop and maintain stored procedures, database triggers, views, queries, and other database objects. Strong knowledge of data ingestion, transformation, mapping, cleansing, validation, and quality assurance practices. Ability to understand and apply complex client-specific business rules to data processing and campaign execution. Strong technical troubleshooting and problem-solving skills. Ability to work effectively with datasets of varying size, complexity, structure, and quality. Understanding of reporting, analytics, and data visualization requirements. Ability to identify opportunities for process automation and workflow optimization. Understanding of modern AI tools and the ability to appropriately leverage them in day-to-day work. Ability to work independently, manage priorities, and deliver assignments with minimal guidance. Strong organizational and time-management skills with the ability to manage multiple assignments of varying complexity. Effective written and verbal communication skills, including the ability to communicate technical information to non-technical stakeholders. Strong attention to detail and commitment to data accuracy and quality. Demonstrates initiative, accountability, adaptability, and ownership of assigned work. Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At AGP we strive to build a diverse, inclusive, and equitable workplace. If you think this role sounds like you, but your experience doesn’t align perfectly with every single qualification or skill in the description, please apply! You could be just the person we are looking for to fill this, or other, roles! Benefits, Rewards & Perks We are friendly, smart, curious and passionate about what we do! Working here, you will also enjoy: Competitive salaries + quarterly recognition program Work-life balance + 100% remote workforce Excellent benefits including Health, Dental, and Vision plans, Disability and Company Paid Life Insurance! Flexible PTO Policy + Paid Parental Leave 401k and company match Oh, and don’t forget - You're working with clients who are making a positive difference in the world. About AGP AGP partners with nonprofits and mission-driven organizations to inspire action, deepen relationships, and grow with confidence. As a fully integrated growth partner, we bring together strategy, fundraising, marketing, technology, and analytics to build momentum that lasts. Our team of more than 170 strategists, fundraisers, developers, creatives, analytics, and technologists works collaboratively to deliver integrated direct mail and digital campaigns, brand and donor experience strategy, high-performing websites and applications, and advanced data and technology solutions. Our culture – with clients and with each other – is grounded in three core values: Diversity, Equality, and Inclusivity Accessibility Respect We believe great work happens when people feel valued, supported, and empowered to grow. A few things to know: We have physical offices in Dallas, TX, and Fargo, ND. However, unless otherwise specified, our positions are 100% remote with the option to work at any of our offices, if desired. Candidates must be legally able to work in the United States and maintain proper work authorization throughout employment with AGP. Candidates must be able to meet the physical requirements of the job presented in a typical office environment. AGP offers a competitive salary commensurate with experience and excellent benefits. AGP is an equal opportunity employer. All applicants will receive consideration for employment without regard to race, color, religion, gender identity, sexual orientation, national origin, veteran status, disability or any other characteristic protected by state, federal, or local law.