Senior Data Engineer
Job Type
Full-time
Description

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:
  1. Trust
  2. Respect
  3. Integrity
  4. 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
Salary Description
$130,000