Role description

Data Engineer (Snowflake / AWS)

Data Architect I

We are seeking a highly skilled Data Engineer with 7+ years of experience in designing and delivering scalable data solutions using Snowflake and AWS cloud platforms. The ideal candidate will play a key role in building robust data pipelines, optimizing data architectures, and enabling advanced analytics across enterprise systems.

The opportunity:
• Design, develop, and maintain scalable data pipelines and workflows using Snowflake and AWS services.
• Implement data ingestion, transformation, and integration processes for structured and unstructured data.
• Develop optimized Snowflake objects (tables, views, streams, tasks, stored procedures).
• Build and manage ELT pipelines using tools such as AWS Glue, Airflow, or other orchestration frameworks.
• Collaborate with data analysts, architects, and business stakeholders to gather data requirements and deliver high-quality solutions.
• Perform data modeling (dimensional & warehouse modeling) to support reporting and analytics use cases.
• Optimize data processes for performance, scalability, and cost-efficiency in Snowflake.
• Implement data governance, security, and compliance best practices.

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:
• 7+ years of experience in Data Engineering or related roles
• Strong hands-on experience with Snowflake (SnowSQL, Snowpipe, Streams, Tasks, Data Sharing)
• Experience in AWS ecosystem (S3, Redshift, Glue, Lambda, EMR)
• Proficiency in SQL and one programming language (Python / PySpark preferred)
• Experience in ETL/ELT tools and data integration frameworks
• Strong knowledge of data warehousing concepts and dimensional modeling
• Experience with big data technologies (Spark, Hadoop, Databricks - optional but preferred)
• Familiarity with CI/CD, DevOps practices, and version control tools
• Preferred Qualifications:
• Experience with real-time data ingestion and streaming pipelines
• Exposure to data orchestration tools (Airflow, Step Functions, etc.)
• Knowledge of data visualization tools (Power BI, Tableau)
• Experience in US healthcare domain

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: Remote-US

Compensation Range: $140,000-$210,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.

What we believe:

We proudly embrace the values that have shaped UST since day one. We build our culture of Humility, Humanity, and Integrity. These values inspire us to nurture a people-first, human centric culture that fosters diversity, prioritizes sustainable solutions, and keeps our people and clients at the forefront of all decisions.

Humility:

We will listen, learn, be empathetic and help selflessly in our interactions with everyone.

Humanity:

Through business, we will better the lives of those less fortunate than ourselves.

Integrity:

We honor our commitments and act with responsibility in all our relationships.

UST reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance.

#UST

#CB

#LI-VK5

#LI-Remote