Senior Data Engineer

SUMMARY

The Senior Data Engineer supports the Foundation’s data, reporting, and analytics ecosystem by designing, building, and maintaining secure, scalable, and high-quality data solutions. This role leads in the development and optimization of the Foundation’s data warehouse, ETL/ELT pipelines, data models, and data quality frameworks to ensure trusted, timely data for fundraising, financial, and operational decisions. The Senior Data Engineer collaborates closely with cross-functional teams – including Financial Services, IT, and external partners – to integrate new data sources, streamline data movement, and support enterprise reporting and innovation.

BEHAVIORAL EXPECTATIONS:

• Follows the principles of the Foundation’s core values:

Trust

Respect

Integrity

Commitment

•  Motivated to value-add to the success of the Foundation
•  Effective communicator
• Collaborative
• Dependable
• Detail-oriented
• Adaptable, receptive to change
• Teach through example and service
• Practice professional curiosity and desire to learn
• Excellent interpersonal skills and ability to work with a diverse constituency 
• Maintain confidentiality 
• Work safely

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Data Engineering & Warehousing

• Design, implement, test, deploy, and maintain scalable data engineering solutions and pipelines
• Build and manage data warehouse structures, including tables, views, routines (stored procedures, functions), and metadata documentation
• Integrate new internal and external data sources and optimize existing data models
• Ensure reliable, secure data flows between systems, applications, and affiliates

ETL/ELT Development

• Build, optimize, and monitor automated ETL/ELT processes
• Produce efficient, replicable, version-controlled code to automate repetitive data management tasks
• Troubleshoot and resolve pipeline failures and performance bottlenecks 

Data Quality & Governance

• Establish and maintain data quality checks, validation routines, and exception handling
• Improve data accuracy, completeness, and consistency across systems
• Support data governance, documentation, and compliance standards

Database & Platform Management

• Manage relational database environments (Postgres, Oracle, SQL Server) housed on AWS
• Optimize database performance, resource allocation, indexing, and storage strategies
• Support security, access control, and backup/restoration processes

Analytics & Reporting Support

• Build and support datasets, views, and queries needed for enterprise reports and dashboards
• Partner with business analysts and report developers to deliver accurate, timely reporting
• Provide troubleshooting and technical guidance for data consumers across the Foundation

Collaboration & Leadership 

• Serve as a senior technical resource to cross-functional teams
• Participate in code reviews and ensure best practices in GitHub/version control 
• Mentor junior data engineers or analysts (if applicable) 
• Recommend and introduce innovative data engineering tools and methods

OTHER DUTIES AND RESPONSIBILITIES:

• Projects
• Participates in on-going training, education, and staff meetings
• Other duties as assigned

Requirements

COMPETENCIES AND EXPERIENCE:

• Minimum 5 years of professional experience in data engineering or database development
• Strong expertise in data warehousing, relational database design, and SQL 
• Hands-on experience with Postgres, Oracle, and/or SQL Server, ideally hosted on AWS
• Advanced skills in ETL/ELT development, job orchestration, and data pipeline automation
• Demonstrated ability to manage data quality processes and performance tuning
• Experience using GitHub or similar tools for version control 
• Strong analytical skills and ability to translate business needs into technical solutions
• Effective communicator with proven success collaborating across teams

PREFERRED QUALIFICATIONS:

• Understanding of fundraising, advancement, and accounting/finance data
• Exposure to Salesforce, MuleSoft, Python, Advancement RM, Apsona, or Tableau
• Experience supporting analytics/reporting environments
• Prior mentorship or coaching experience

PHYSICAL DEMANDS AND WORK ENVIRONMENT:

• This job is conducted in an office work environment, sitting much of the time
• This position’s duties require use of a computer
• Must be able to exert up to 20 lbs. of force occasionally
• Some travel may be required