Direct Marketing Database Developer

Job Description

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.

Full-time