EA-Database Developer
About The Position
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
1,001-5,000 employees
