Role description

Data ETL / Data Engineer

Associate Data Architect I

UST is searching for a skilled Data ETL/Data Engineer with strong expertise in data integration, ETL development, data warehousing, and large-scale data processing.

The opportunity:
• Design, develop, test, and maintain ETL/data pipeline solutions.
• Build scalable data processing workflows using Python and PySpark.
• Develop and optimize SQL/PLSQL scripts for data extraction, transformation, and loading.
• Design and maintain data warehouse architectures and data models.
• Perform performance tuning and query optimization for large datasets.
• Work with Databricks, Snowflake, and PostgreSQL environments.
• Manage source code repositories using Bitbucket and follow CI/CD best practices.
• Leverage AI-powered development tools to improve productivity and code quality.
• Collaborate with business stakeholders, data analysts, and cross-functional teams to deliver data solutions.
• Create technical documentation and support production deployments.

This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.

What you need:
• Bachelor's degree in Computer Science, Engineering, Information Technology, or related field.
• Strong experience in ETL development and data engineering.
• Hands-on experience with SQL, Python, and PySpark.
• Experience in data warehousing and database performance tuning.
• Knowledge of cloud-based data platforms and modern data engineering practices.
• Strong analytical, troubleshooting, and problem-solving skills.
• Primary Skills
• SQL & PL/SQL Development
• Python Programming
• PySpark ETL Development and Data Integration
• Data Warehousing Concepts and Development
• Query Performance Tuning and Optimization
• Bitbucket/Git Version Control
• Experience leveraging AI tools such as GitHub Copilot and Windsurf
• Secondary Skills
• Databricks
• Snowflake
• PostgreSQL (AWS RDS PostgreSQL)
• Developing AI Agents and AI-driven solutions
• Shell Scripting
• Preferred Qualifications:
• Experience with Databricks and Snowflake.
• Exposure to AI Agent development and Generative AI technologies.
• Experience working in Agile development environments.
• Knowledge of AWS cloud services and PostgreSQL database administration.
• Primary Skillset(s) / Experience Needed:
• SQL, T-SQL, ETL, Database Development experience, performance tuning, bitbucket/git, leveraging AI tools like Copilot/Windsurf
• Postgres, shell scripts

Compensation can differ depending on factors including but not limited to the specific office location, role, skill set, education, and level of experience. UST provides a reasonable range of compensation for roles that may be hired in various U.S. markets as set forth below.

Role Location: Virginia

Compensation Range: $106,000-$159,000

Benefits

Full-time, regular employees accrue a minimum of 10 days of paid vacation per year, receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year), 10 paid holidays, and are eligible for paid bereavement leave and jury duty. They are eligible to participate in the Company's 401(k) Retirement Plan with employer matching. They and their dependents residing in the US are eligible for medical, dental, and vision insurance, as well as the following Company-paid Employee Only benefits: basic life insurance, accidental death and disability insurance, and short- and long-term disability benefits. Regular employees may purchase additional voluntary short-term disability benefits, and participate in a Health Savings Account (HSA) as well as a Flexible Spending Account (FSA) for healthcare, dependent child care, and/or commuting expenses as allowable under IRS guidelines. Benefits offerings vary in Puerto Rico.

Part-time employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year) and are eligible to participate in the Company's 401(k) Retirement Plan with employer matching.

Full-time temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year) and are eligible to participate in the Company's 401(k) program with employer matching. They and their dependents residing in the US are eligible for medical, dental, and vision insurance.

Part-time temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year).

All US employees who work in a state or locality with more generous paid sick leave benefits than specified here will receive the benefit of those sick leave laws.

#UST

#CB

#LI-AP6