The EA - Data Engineer supports the design, implementation, and maintenance ofBonterra'sEveryActionand NGP VANdatabase 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.Theycontributeto 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.

Essential Functions

• Develop,maintain, andoptimizedatabases supporting enterprise analytics workloads across cloud andon-premiseenvironments

• 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 andmaintaindatabase schemas, indexes, and partitioning strategies to support query efficiency and AI-driven analytics

• Support data access, backup, and recovery strategiesin accordance withorganizational 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 releasemanagement forchangesimpactingdatabase environments across staging and production

Knowledge, Skills & Abilities

• LEADERSHIP & NAVIGATION EXPECTATIONS

• This position does not havepeoplemanagement responsibilities.

• Works independently within assigned projects and escalates blockers appropriately

• Supports team goals through consistent, high-quality contributions

KEY BEHAVIORS - THE "HOW"

• Follows structured documentation practices for all database operations

• Communicates technical decisions and risks clearly to peers and stakeholders

• Incorporates feedback and iterates database designs for improved performance

OUTCOME EXPECTATIONS - THE "IMPACT"

• Improves database reliability, scalability, and performance across analytics systems

• Supports data availability anduptimethrough resilient architecture and monitoring

• Enablesdownstream AI systems tooperateon optimized and secure data stores

Required Minimum Qualifications

• Proficiencyin 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

Preferred Qualifications

• 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, GoogleBigQuery, Snowflake)

• Experience integrating databases with analytics platforms or AI models

• Familiarity with data warehousing tools (e.g.,BigQuery,Snowflake, Redshift)

• Previousexperience supporting union or public sector data systems

• Bachelor's degree in a technical field or equivalent work experience

This position is a part of a bargaining union represented by CWA Local 1101, 1400, 2336, or 13000.