Senior Data Engineer

University of Oregon Foundation•Eugene, OR

just now

About The Position

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

Requirements

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

Nice To Haves

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

Responsibilities

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
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
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
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
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
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
Participates in on-going training, education, and staff meetings
Other duties as assigned