Data ETL Engineer

Job Posting Title:

Data ETL Engineer

----

Hiring Department:

Enterprise Technology - Data to Insights (D2I)

----

Position Open To:

All Applicants

----

Weekly Scheduled Hours:

40

----

FLSA Status:

Exempt

----

Earliest Start Date:

Immediately

----

Position Duration:

Expected to Continue Until Aug 31, 2026

----

Location:

Texas

----

Job Details:

General Notes

This is a fixed term position that is expected to continue until August 31, 2026.

Flexible work arrangements are available for this position, including the ability to work 100% remotely. Remote work for individuals who reside outside Texas but within the United States and its territories will be considered and requires Central Office approval.

This position provides life/work balance with typically a 40-hour work week and travel limited to training (e.g., conferences/courses).

Enterprise Technology is dedicated to supporting the mission of the University of Texas at Austin of unlocking potential and preparing future leaders of the state.

Your skills will make a difference.

You’ll be working for a university that is internationally recognized for research and the work you do will make a difference in the lives of our students, faculty and staff. If you’re the type of person that wants to know your work has meaning and impact, you’ll like working for our campus.

The University of Texas at Austin and Enterprise Technology provide an outstanding benefits package to our staff. Those benefits include:

• Competitive health benefits (Employee premiums covered at 100%; family premiums at 50%) 
• Vision, dental, life, and disability insurance options 
• Paid vacation, sick leave, and holidays 
• Teachers Retirement System of Texas (a defined benefit retirement plan) 
• Additional voluntary retirement programs: tax sheltered annuity 403(b) and a deferred compensation program 457(b) 
• Flexible spending account options for medical and childcare expenses 
• Training and conference opportunities 
• Tuition assistance 
• Athletic ticket discounts 
• Access to UT Austin's libraries and museums 
• Free rides on all UT Shuttle and Capital Metro buses with staff ID card 

For more details, please see: https://hr.utexas.edu/prospective/benefits and https://hr.utexas.edu/current/services/my-total-rewards 

Must be authorized to work in the United States on a full-time basis for any employer without sponsorship.

This position requires you to maintain internet service and a mobile phone with voice and data plans to be used when required for work.

Purpose

The Data ETL Engineer for the UT Data Hub improves university outcomes and advances the UT mission to transform lives for the benefit of society by increasing the usability and value of institutional data.

The Data ETL Engineer develops extract, transform, and load (ETL) procedures using integration tools such as Informatica for complex data models that reflect academic and administrative business processes at the University of Texas at Austin.  The Data ETL Engineer plays a critical part in establishing a valuable cloud data warehouse that supports critical business decisions and data analysis processes for the campus community. The Data ETL Engineer leverages their creativity to solve complex data and business problems and builds effective relationships through open communication.

Responsibilities

Development & Design:

• Develop ETL programs for complex dimensional data models within modern data platforms such as AWS Aurora Postgres, Snowflake, etc.
• Interpret and devise data mapping documents
• Design and automate ETL solutions for data cleansing, preparation, data validation and related processes

Adaptation & Maintenance:

• Adapt ETL programs to evolving data models and business needs
• Adapt ETL programs in response to data quality assurance findings

Communication & Collaboration:

• Partner with key stakeholders including enterprise data architect, subject matter experts (SMEs), data modelers, and teammates
• Guide complex technical projects, enabling effective communication and collaboration with project stakeholders
• Perform other related functions as assigned

Required Qualifications

• Bachelor’s degree in computer science, Information Systems, Engineering, or equivalent professional experience.
• 2 years of experience designing and implementing ETL technical solutions for complex data models using multiple data sources.
• 2 years of experience with Informatica, Python, SQL, and PL/SQL.
• Demonstrated expert judgment in selecting methods, techniques, and evaluation criteria for designing ETL solutions and optimizing ETL performance.
• 2 years of experience with Oracle and AWS PostgreSQL database environments including schema architecture. Strong communication and collaboration skills and good documentation habits.
• Demonstrated experience with orchestration and automation of database processes.
• Strong aptitude for troubleshooting and problem solving.
• Team player, comfortable communicating cross-functionally and across management levels.
• Self-motivated and able to organize work independently in a rapidly changing environment.

Equivalent combination of relevant education and experience may be substituted as appropriate.

Preferred Qualifications

• Graduate degree in computer Science or related field with five years of professional experience as an ETL Developer utilizing Informatica, IBM DataStage, SQL, PL/SQL, and Python.
• Three years of experience working in a cloud-based data warehouse environment.
• Experience with multiple types of databases.
• Experience with high availability database implementations.
• Basic networking knowledge as it relates to database systems.
• Informatica and AWS certifications.
• Strong knowledge of Quality Assurance processes, test case development and execution.
• Knowledge of Agile software development methodologies (Kanban, Scrum).
• Experience with issue tracking systems (JIRA).

Salary Range

$110,000 - $124,968

Working Conditions

• May work around standard office conditions
• Repetitive use of a keyboard at a workstation
• Use of manual dexterity (ex: using a mouse)

Work Shift

Monday – Friday 8am-5pm; Occasional nights or weekends may be required

Required Materials

• Resume/CV
• 3 work references with their contact information; at least one reference should be from a supervisor
• Letter of interest

Important for applicants who are NOT current university employees or contingent workers: You will be prompted to submit your resume the first time you apply, then you will be provided an option to upload a new Resume for subsequent applications. Any additional Required Materials (letter of interest, references, etc.) will be uploaded in the Application Questions section; you will be able to multi-select additional files. Before submitting your online job application, ensure that ALL Required Materials have been uploaded. Once your job application has been submitted, you cannot make changes.

Important for Current university employees and contingent workers: As a current university employee or contingent worker, you MUST apply within Workday by searching for Find UT Jobs. If you are a current University employee, log-in to Workday, navigate to your Worker Profile, click the Career link in the left hand navigation menu and then update the sections in your Professional Profile before you apply. This information will be pulled in to your application. The application is one page and you will be prompted to upload your resume. In addition, you must respond to the application questions presented to upload any additional Required Materials (letter of interest, references, etc.) that were noted above.

----

Employment Eligibility:

Regular staff who have been employed in their current position for the last six continuous months are eligible for openings being recruited for through University-Wide or Open Recruiting, to include both promotional opportunities and lateral transfers. Staff who are promotion/transfer eligible may apply for positions without supervisor approval.

----

Retirement Plan Eligibility:

The retirement plan for this position is Teacher Retirement System of Texas (TRS), subject to the position being at least 20 hours per week and at least 135 days in length.

----

Background Checks:

A criminal history background check will be required for finalist(s) under consideration for this position.

----

Equal Opportunity Employer:

The University of Texas at Austin, as an equal opportunity/affirmative action employer, complies with all applicable federal and state laws regarding nondiscrimination and affirmative action. The University is committed to a policy of equal opportunity for all persons and does not discriminate on the basis of race, color, national origin, age, marital status, sex, sexual orientation, gender identity, gender expression, disability, religion, or veteran status in employment, educational programs and activities, and admissions.

----

Pay Transparency:

The University of Texas at Austin will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information.

----

Employment Eligibility Verification:

If hired, you will be required to complete the federal Employment Eligibility Verification I-9 form.  You will be required to present acceptable and original documents to prove your identity and authorization to work in the United States.  Documents need to be presented no later than the third day of employment.  Failure to do so will result in loss of employment at the university.

----

E-Verify:

The University of Texas at Austin use E-Verify to check the work authorization of all new hires effective May 2015. The university’s company ID number for purposes of E-Verify is 854197. For more information about E-Verify, please see the following:

• E-Verify Poster (English) [PDF]
• E-Verify Poster (Spanish) [PDF]
• Right To Work Poster (English) [PDF]
• Right To Work Poster (Spanish) [PDF]

----

Compliance:

Employees may be required to report violations of law under Title IX and the Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act (Clery Act). If this position is identified a Campus Security Authority (Clery Act), you will be notified and provided resources for reporting. Responsible employees under Title IX are defined and outlined in HOP-3031.

The Clery Act requires all prospective employees be notified of the availability of the Annual Security and Fire Safety report. You may access the most recent report here or obtain a copy at University Compliance Services, 1616 Guadalupe Street, UTA 2.206, Austin, Texas 78701.