Job Description
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 solutionLoad, cleanse and summarize client data according to internal standard data load processesUnderstand and work with data in varying degrees of complexity and scaleCustomize data mappings and translations according to the unique business rules of your client portfolioDevise data ingestion validation strategies for ensuring accurate and timely availability of client dataPrepare data files needed for direct marketing communications adhering to the client approved business rulesParticipate in desk-checks and reviews of team members client deliverables as experience warrantsSupport the data analyst team’s needs for reporting, analysis, visualization and dashboards.Contribute to defining timelines, milestones, and project plansThe 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 PostgreSQLBachelor's degree in Computer Science, Information Systems, and / or direct related experienceThree to five year’s experience in database developer rolesKnowledge of reporting technologies (e.g., SSRS, Power BI, Tableau, etc.) preferredStrong technical problem-solving skillsAbility to adhere to work plans and track assignments with minimal guidanceSolid oral and written communication skills including the ability to communicate effectively with both technical and non-technical stakeholdersSkills in Microsoft Office suite including PowerPoint, Word and ExcelUnderstanding of modern AI tools and how to leverage them in day to day workExperience with version control software such as TFVC, git or SVN a plus.Other desired skills :
Ability to adapt to an evolving technology and process landscapeExcellent communicator / information sharerReliable work ethic demonstrating personal initiative and ownership to deliver high quality productsEffectively manages multiple activities of varying complexities while following all processesTime / prioritization management skillsAdept at managing expectationsAttention to detailStudies 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 programWork-life balance (really!) + Casual work environmentExcellent benefits including Health, Dental, and Vision plans, Disability and Company Paid Life Insurance!Flexible PTO Policy + Paid Parental Leave401k and company matchOh, and don’t forget - You're working with clients who are making a positive difference in the world.