Data Engineer (Snowflake / AWS)

UST is a mission-driven company that transforms lives through technology, seeking a highly skilled Data Engineer with expertise in Snowflake and AWS. The role involves designing and delivering scalable data solutions, building robust data pipelines, and optimizing data architectures for advanced analytics.

Responsibilities:

• 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

Requirements:

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