Data Engineer; Snowflake​/AWS

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.

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

Other relevant essential functions may be required.

• 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, Dev Ops practices, and version control tools.

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

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 U.S. are eligible for medical, dental, and vision insurance, as well as 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 U.S. 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 U.S. 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 is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other applicable characteristics protected by law. We will consider qualified applicants with arrest or conviction records in accordance with state and local laws and "fair chance" ordinances.

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