Data Engineer
Job Description
Hybrid flexibility in Knoxville, comprehensive benefits, and the chance to strengthen data operations that support reporting, analytics, dashboards, and business processes across the UT System. The University of Tennessee Foundation, Inc. is a not-for-profit 501(c)3 serving as a preferred channel for private contributions benefiting students and faculty within the UT System, and this role helps ensure enterprise data pipelines run reliably across cloud and on-premise environments.
What you will do
Implement, maintain, monitor, and optimize enterprise ETL and data transformation solutions spanning cloud and on-premise systems. You will ensure timely, reliable movement of data across platforms including Salesforce, Microsoft Fabric, Azure Data Factory, and SFTP to support reporting, analytics, dashboards, and operational needs.
- Implement, monitor, maintain, and troubleshoot enterprise ETL and data pipelines connecting Salesforce, cloud platforms, SFTP environments, Tableau, and enterprise data warehouse solutions.
- Rerun failed ETL jobs, reporting tables, and scheduled integration processes to keep reporting and operational data available on time.
- Support daily data processing and time-sensitive reporting requirements.
- Monitor pipeline execution and tune existing integrations to catch issues early and improve reliability for downstream analytics.
- Develop and maintain reporting views, transformation logic, curated datasets, and semantic-layer objects used in business intelligence and analytics initiatives.
- Translate business and reporting needs into reporting-ready datasets and reusable transformation processes.
- Create and update data warehouse objects (tables, views, stored procedures), and onboard new Salesforce fields and data sources into enterprise reporting environments.
- Standardize business logic, KPI calculations, and reporting definitions, and optimize query and semantic-layer performance across analytics platforms.
- Collaborate with BI analysts, CRM administrators, and Data Platform teams to meet dashboarding and operational data needs.
- Prepare and curate datasets that support Data Science, predictive modeling, and AI initiatives.
- Discuss business requirements, reporting structures, and analytics solutions with stakeholders.
- Communicate technical issues, integration impacts, and implementation updates clearly to technical and non-technical stakeholders, including troubleshooting support for reporting and data integration issues.
- Maintain technical documentation for ETL pipelines, workflows, transformation logic, semantic-layer objects, configurations, and support procedures.
- Follow established standards and best practices for data governance, security, and change management.
- Research emerging cloud, ETL, semantic modeling, and data engineering technologies to improve efficiency and reporting capabilities.
- Participate in training and professional development in data engineering, cloud data platforms, and analytics engineering practices.
Requirements
- Bachelor’s degree
- 5+ years of progressively responsible experience in business intelligence, enterprise data engineering, CRM technologies, analytics, business systems, or related technical disciplines
- Demonstrated experience designing enterprise data architecture
- Experience developing enterprise ETL/ELT initiatives
- Experience supporting enterprise CRM platforms, preferably Salesforce
- Experience developing enterprise reporting and analytics solutions
- Experience managing cloud-based data environments, preferably Fabric and/or Azure
- A valid driver’s license with an acceptable driving record is required due to travel responsibilities
Preferred
- Master’s degree in Computer Science, Information Systems, Data Science, Analytics, or a related field
- Experience with enterprise UT systems, including DASH, Marketing Cloud, and Salesforce
- Experience leading enterprise cloud modernization initiatives
- Experience with fundraising CRMs
Technologies
- Salesforce, Microsoft Fabric, Azure Data Factory, SFTP, Tableau
- Enterprise data warehouse solutions
- Stored procedures
Benefits
- Generous paid leave: up to 24 days of vacation and 12 days of sick leave annually, plus 14 paid holidays and administrative closing days
- Hybrid work schedule to most team members
- Education benefits for employees and their dependents at UT System campuses
- Retirement and deferred compensation plans, including 401(k) and 403(b)
- Comprehensive medical, dental, and vision insurance plans
- Employee discounts to attractions, services, and goods
Application process
Priority will be given to applications received on or before October 26 via the DASH application system. Applications must include a completed candidate profile, cover letter, resume, and contact information for three professional references. References will not be contacted without explicit permission from the candidate.
Please ensure your candidate profile is completed in its entirety as it relates to qualifying education and work experience.
Additional details
- Location: Knoxville, TN (hybrid)
- Target start date: December 2026
- Minimum experience: 5 years
The Foundation: The University of Tennessee Foundation, Inc. is a not-for-profit 501(c)3 organization that serves as the preferred channel for private contributions benefiting students and faculty within the UT System. With a vision of being one of the top-performing advancement organizations in higher education, UTFI is committed to enhancing the educational landscape across the University of Tennessee campuses.
The UT System: The University of Tennessee System includes campuses at Knoxville, Chattanooga, Pulaski, Martin, and the Health Science Center at Memphis, plus the Institute of Agriculture and the Institute for Public Service.