Data ETL Engineer
Austin, TX
Full Time Mid-level / Intermediate USD 110K - 125K
University of Texas at Austin
The University of Texas at Austin is a bold, ambitious leader, providing a first-class education and the tools of discovery to more than 51,000 students.R_00031892
Data ETL Engineer
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 ecosystem 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
Other duties as assigned.
Required Qualifications
- BS 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.
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 - $125,000
For a detailed description and to apply for this position, please visit our online job application system at:
https://utaustin.wd1.myworkdayjobs.com/en-US/UTstaff/details/Data-ETL-Engineer_R_00031892?q=data%20etl%20engineer
Tags: Agile Architecture AWS Computer Science Data analysis Data quality Data warehouse Engineering ETL Informatica Jira Kanban Oracle PostgreSQL Python Scrum Snowflake SQL
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open Data Engineer II jobs
- Open Senior Business Intelligence Analyst jobs
- Open Principal Data Engineer jobs
- Open MLOps Engineer jobs
- Open Data Analytics Engineer jobs
- Open Data Scientist II jobs
- Open Power BI Developer jobs
- Open Junior Data Scientist jobs
- Open Business Intelligence Developer jobs
- Open Product Data Analyst jobs
- Open Business Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Big Data Engineer jobs
- Open Research Scientist jobs
- Open Data Quality Analyst jobs
- Open Manager, Data Engineering jobs
- Open Azure Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Data Product Manager jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open NLP-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Hadoop-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open DevOps-related jobs