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