EA-Database Developer

Bonterra

8d•$85,800 - $120,000

About The Position

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. About the Role The EA – Data Engineer supports the design, implementation, and maintenance of Bonterra’s EveryAction and NGP VAN database infrastructure for enterprise analytics systems. This role ensures reliable, scalable, and secure storage and access to structured and unstructured data used in analytics and reporting. They contribute to schema optimization, performance tuning, backup strategies, and integration with modern data platforms. This role spends more than 40% of its time supporting products designed for union and labor organizations and is therefore classified as a union position.

Requirements

Proficiency in SQL and one database platform (e.g., BigQuery, PostgreSQL, MySQL, SQL Server, or Oracle)
Experience implementing and managing relational database structures
Experience building out ETL or ELT systems
Familiarity with scripting for automation (e.g., Bash, Python) and database monitoring tools
Understanding of backup, restore, and high-availability practices
Ability to troubleshoot complex issues and implement corrective actions
Strong documentation and configuration management habits

Nice To Haves

1–3 years of experience managing databases in analytics or software engineering environments
Exposure to cloud-based databases and tools (e.g., AWS RDS, Azure SQL, Google Cloud SQL, Google BigQuery, Snowflake)
Experience integrating databases with analytics platforms or AI models
Familiarity with data warehousing tools (e.g., BigQuery, Snowflake, Redshift)
Previous experience supporting union or public sector data systems
Bachelor’s degree in a technical field or equivalent work experience

Responsibilities

Develop, maintain, and optimize databases supporting enterprise analytics workloads across cloud and on-premise environments
Implement data storage solutions that align with data modeling and AI integration needs, including relational and non-relational structures
Monitor database performance, execute tuning procedures, and resolve bottlenecks or failures proactively
Design and maintain database schemas, indexes, and partitioning strategies to support query efficiency and AI-driven analytics
Support data access, backup, and recovery strategies in accordance with organizational standards and compliance requirements
Ensure data integrity and security by applying role-based access controls, encryption standards, and audit logging
Collaborate with analytics engineers and platform teams to streamline data ingestion and integration into analytics environments
Participate in capacity planning and forecast database infrastructure needs based on product roadmaps
Document database configurations, operational procedures, and change management logs
Conduct root cause analysis and propose structural changes to improve system reliability
Support release management for changes impacting database environments across staging and production