EA - Database Architect

NGP VAN is the winningest technology platform in the history of democratic and progressive causes, working tirelessly to innovate and advance the technology our clients rely on to bolster our democracy. We help power the trailblazers, campaigners, and advocates fighting up and down the ticket for equality, racial justice, reproductive freedom, democracy, climate reform, and more— including the national Democratic committees and progressive organizations, thousands of Democratic campaigns, hundreds of labor unions, advocacy organizations, progressive and non-partisan PACs, and other organizations.

Position Summary:

The Database Architect is a senior individual contributor and technical mentor who leads high-impact data operations across voter file updates and client services. This role combines deep technical ownership with informal leadership responsibilities, including mentorship, process optimization, and contributions to long-term architectural improvements. The Database Architect also helps bridge the gap between the Data Engineering team and Database Development by guiding workflows and contributing to advanced SQL and stored procedure logic.

Essential Position Duties and Responsibilities:

• Design, implement, and troubleshoot complex ETL workflows for voter file updates and custom data services.

• Write and maintain dynamic SQL, service broker queues, stored procedures, and SQL server jobs to support high-volume, multi-state data processes.

• Lead quality assurance efforts and contribute to automated validation frameworks.

• Mentor junior Data Engineers and provide peer reviews for SQL logic, process design, and performance optimization.

• Analyze and optimize data workflows for scalability, consistency, and long-term maintainability.

• Collaborate with Senior Database Developers on schema design discussions and contribute to stored procedure development.

• Respond to complex internal and external data requests, including client-specific formatting and transformation needs.

• Use version control tools (e.g., Git) to manage SQL and deployment processes.

• Coordinate with cross-functional teams (Product, Engineering, Client Services) to manage project goals and technical priorities.

• Support knowledge-sharing and documentation to enhance team effectiveness and readiness for database developer-level work.

Required Skills/Abilities:

• Expert-level SQL proficiency, including query tuning, indexing strategies, and dynamic SQL.

• Strong understanding of data modeling, normalization, and OLTP database design principles.

• Experience designing and optimizing ETL workflows and reusable transformation logic, with strong opinions on tracking and problem solving.

• Skilled in mentoring others and providing structured feedback on technical work.

• Familiarity with schema architecture and readiness to contribute to stored procedure development.

• Comfortable working in cloud-based data environments (e.g., Azure SQL, AWS RDS).

• Excellent problem-solving, documentation, and communication skills.

Education and Experience:

• 10+ years of experience in data engineering, database development, or large-scale data operations.

• Experience mentoring technical peers or leading technical projects.

• Bachelor’s degree in Computer Science, Data Science, or a related field—or equivalent professional experience.

• Experience with political data systems or nonprofit CRMs is a plus.

Compensation

The range displayed on this job posting reflects the minimum and maximum target for new hire salaries for the position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training. 

At this time, we are unable to consider candidates who require current or future sponsorship for employment authorization.

Our Culture:

Our team is made up of industry experts and advocates who are 100% committed to supporting the doers of social good. We are currently undergoing an effort to create the vision and values that embody our collective organization and embrace the individuals who make up our community.

Our comprehensive and competitive benefits include:

• Generous Flexible Time Off (FTO) Policy

• Up to 15 paid company holidays including some commemorating social justice events and self-care

• Paid volunteer time

• Resources for savings and investments

• Paid parental leave

• Paid sick leave

• Health, vision, dental, and life insurance with additional access to health and wellness programs.

• Opportunities to learn, develop, network, and connect

Please note the benefits specified on this page are applicable to full-time employees based in the United States. For international employees, actual benefits may vary based on local standards and regulations and will be determined in accordance with regional considerations, including but not limited to applicable laws and industry norms.

We are committed to being an equal opportunity employer and evaluate qualified applicants without regard to race, color, religion, sex, pregnancy (including childbirth, lactation and related medical conditions), national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military and veteran status, diversity of thought and any other characteristic protected by applicable law.