Direct Response Database Developer

Summary

AGP (Allegiance Group & Pursuant) is seeking a Direct Response Database Developer to support direct response fundraising through reliable, automated, and AI-enabled data pipelines. The role manages donor and marketing data ingestion, cleansing, transformation, validation, campaign preparation, database development, troubleshooting, and data quality assurance while partnering with analysts, clients, and stakeholders.

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

Skills

• 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
• 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
• 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

Qualifications

Must Haves

• 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
• 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

Nice to Haves

• 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

Benefits

• Quarterly recognition program
• 100% remote workforce
• Health, Dental, and Vision plans
• Disability and Company Paid Life Insurance
• Flexible PTO Policy
• Paid Parental Leave
• 401k and company match
• Working with clients who are making a positive difference in the world