Search for Data ETL Engineer roles in Texas with flexible work options, requiring a Bachelor's degree, at least 2 years of experience, and skills in SQL and Python.

Okay, I've searched for Data ETL Engineer roles in Texas that offer flexible work options, requiring a Bachelor's degree, at least 2 years of experience, and skills in SQL and Python. I have found 32 positions for you. You can review them now.

Data ETL Engineer

Texas

Bachelor

2 years + Experience

SQL

Python

Can you help me to analyze the job description and company culture?

Sure. Here's the analysis:

Job Analysis:

The Data ETL Engineer role at The University of Texas at Austin is fundamentally tasked with enhancing the usability and value of institutional data to support the university's mission of transforming lives through education and research. The core responsibilities include developing and maintaining ETL processes that integrate complex data models from diverse sources, thus ensuring data quality and readiness for analysis by stakeholders. Given the diverse and dynamic environment at a major research university, the engineer will navigate challenges involving evolving data requirements and stakeholder communication, necessitating a skill set that combines technical proficiency in Informatica, SQL, and Python with strong interpersonal skills. Successful performance will manifest in the timely delivery of robust ETL solutions that enable informed decision-making across various applications and contribute to impactful research and educational initiatives within a collaborative team context.

Company Analysis:

The University of Texas at Austin is a leading public research institution that emphasizes innovation and research-oriented approaches to education. Being one of the largest universities in the U.S., it enjoys a prominent market position which influences its data management and technological infrastructure significantly. The culture seems to prioritize collaboration, diversity, and a commitment to public service—values that resonate with a community-centric role like that of a Data ETL Engineer. This position falls within the Enterprise Technology department, which is likely to interact with various academic and administrative units, providing the individual with substantial visibility across the organization. This role not only supports the university’s operational goals but is strategically pivotal; it enhances data-driven decision-making supporting the overarching mission of impactful education and research. For a candidate considering this position, aligning with the university’s values and contributing to its mission will be crucial for success and growth.

Mock up some interview questions based on the job description.

Absolutely. Here are some mock interview questions that could come up:

Behavioral Questions:
1. Tell me about a time when you had to adapt an ETL program in response to changing data requirements. How did you approach this situation?
1. Describe an instance when you faced a significant data quality issue. What steps did you take to identify and resolve the problem?
1. Share an experience where you had to communicate complex technical concepts to non-technical stakeholders. How did you ensure understanding?
1. Give an example of a challenging project where you collaborated with cross-functional teams. What was your role and contribution?
Technical/Role-Specific Questions:
1. How would you design an ETL solution for integrating data from multiple sources using Informatica? Please outline your approach.
1. Describe your experience with AWS PostgreSQL. What are some best practices you follow when optimizing database performance?
1. What strategies do you implement for effective data cleansing and validation in ETL processes?
1. How do you ensure that ETL processes you develop are maintainable and adaptable to future needs?
Situational Questions:
1. Imagine you are faced with a major data discrepancy shortly before a critical reporting deadline. How would you handle this situation?
1. If you were tasked with developing an ETL solution for a new data source that you are not familiar with, what would be your first steps?
Company Fit/Motivation Questions:
1. Why are you interested in working at The University of Texas at Austin specifically as a Data ETL Engineer?
1. How do your professional values align with the University’s mission of transforming lives and advancing society through education and research?
Questions for the Candidate to Ask the Interviewer:
1. Can you describe the typical career progression for someone in the Data ETL Engineer role at UT Austin?
1. What are some immediate projects or challenges that the Data ETL team is currently facing?
1. How does the university support professional development and continuous learning for its technical staff?

Job Details

Overview Company

Data ETL Engineer

$110k/y-$124.968k/y

The University of Texas at Austin

3 days ago

Highlight

RemoteFull-time2+ yearsMid

Summary

The University of Texas at Austin is seeking a Data ETL Engineer to join their Enterprise Technology - Data to Insights (D2I) team in Austin, TX. The role involves developing ETL procedures to enhance the usability and value of institutional data.

About the Role

As a Data ETL Engineer, you will develop ETL programs for complex dimensional data models using modern data platforms such as AWS Aurora Postgres and Snowflake. You will design and automate ETL solutions for data cleansing, preparation, and validation. The role requires adapting ETL programs to evolving data models and business needs, and collaborating with key stakeholders to guide complex technical projects.

About You

Required:

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.
Experience with Oracle and AWS PostgreSQL database environments including schema architecture.
Strong communication and collaboration skills and good documentation habits.
Experience with orchestration and automation of database processes.
Strong aptitude for troubleshooting and problem solving.
Self-motivated and able to organize work independently in a rapidly changing environment.

Preferred:

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

Benefits

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

The University of Texas at Austin

At The University of Texas at Austin, we’re changing the world through education, research and public service. We’re on a mission to become the highest-impact public research university in the world, and we pride ourselves on the transformational student experiences and groundbreaking discoveries that happen on our campus every day.

Since our founding in 1883, UT has grown from a single building with eight teachers, two departments and 221 students to one of the largest public universities in the United States, serving almost 54,000 students and employing 18,500 faculty and staff. Our 431-acre main campus in the heart of Austin is home to 19 colleges and schools, which offer more than 150 undergraduate degree programs and 200 graduate programs. Our presence extends to local facilities like the J.J. Pickle Research Campus and the Lady Bird Johnson Wildflower Center, as well as to the McDonald Observatory in West Texas, the Marine Science Institute in Port Aransas and several cultural and historic sites across the state.

As one of largest employers in Central Texas, we know that our faculty and staff — together with our students, alumni, friends and fans — make Longhorn Nation a community worth joining. To start your Longhorn journey, visit https://www.utexas.edu/jobs for information on current openings.

Hook 'em!

Austin, TX