Direct Marketing Database Developer

Department: Analytics & Optimization

Location: Remote or Hybrid, US

Compensation: $90,000 - $100,000 / year

Description

Allegiance Group + Pursuant is a direct marketing agency that helps nonprofits across the U.S. deliver customized fundraising campaigns that inspire action and improve donor relationships. We exist to help our clients unlock the joy of giving for their support base.

Regardless of the fundraising strategy or channel, data insights are central to our approach and critical for fundraising success. As the only firm to serve every donor segment across communication channels, our clients experience the impact of strategic insights and recommendations in dramatic fundraising results that help them make a greater impact every day.

The Direct Marketing Database Developer will be working with clients and internal teams to:

• Create, automate and maintain data ingestion processes for client data.
• Prepare client data to power reports, ad-hoc analysis and segmentation.
• Enable regular direct marketing communications through timely delivery of segmented data files.

We’re looking for data-driven teammates who can take raw data and turn it into clear, actionable insights. At AGP, we share a commitment to delivering fundraising success for our clients. We value passion, drive, integrity, and attention to detail - and we believe the best teammates are humble, hungry, and smart.

Key Responsibilities

• Partner with data analysts, account teams and client resources to understand the scope of work, priorities, and requirements for the client’s fundraising solution
• Load, cleanse and summarize client data according to internal standard data load processes
• Understand and work with data in varying degrees of complexity and scale
• Customize data mappings and translations according to the unique business rules of your client portfolio
• Devise data ingestion validation strategies for ensuring accurate and timely availability of client data
• Prepare data files needed for direct marketing communications adhering to the client approved business rules
• Participate in desk-checks and reviews of team members client deliverables as experience warrants
• Support the data analyst team’s needs for reporting, analysis, visualization and dashboards.
• Contribute to defining timelines, milestones, and project plans

The Direct Marketing Database Developer will live and breathe SQL in this role. Competence in this area must be demonstrated.

Skills, Knowledge & Expertise

The ideal candidate will have:

• Experience in direct marketing whether non-profit (preferred) or commercial.
• Strong T-SQL or other SQL variant.
• Experience developing stored procedures, database triggers, views and other database objects as necessary.
• Strong experience in at least one relational database platform such as Microsoft SQL Server (preferred), MySQL, Oracle, or PostgreSQL
• Bachelor's degree in Computer Science, Information Systems, and/or direct related experience
• Three to five year’s experience in database developer roles
• Knowledge of reporting technologies (e.g., SSRS, Power BI, Tableau, etc.) preferred
• Strong technical problem-solving skills
• Ability to adhere to work plans and track assignments with minimal guidance
• Solid oral and written communication skills including the ability to communicate effectively with both technical and non-technical stakeholders
• Skills in Microsoft Office suite including PowerPoint, Word and Excel
• Understanding of modern AI tools and how to leverage them in day to day work
• Experience with version control software such as TFVC, git or SVN a plus.

Other desired skills:

• Ability to adapt to an evolving technology and process landscape
• Excellent communicator/information sharer
• Reliable work ethic demonstrating personal initiative and ownership to deliver high quality products
• Effectively manages multiple activities of varying complexities while following all processes
• Time/prioritization management skills
• Adept at managing expectations
• Attention to detail

Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At Allegiance Group + Pursuant we are striving 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 (really!) + Casual work environment
• 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.