Lead I - Data Engineering

Who We Are

At UST, we help the world’s best organizations grow and succeed through transformation. Bringing together the right talent, tools, and ideas, we work with our clients to co-create lasting change. Together, with over 30,000 employees in 30+ countries, we build for boundless impact, touching billions of lives in the process. Visit us at www.ust.com.

Summary

UST is seeking an experienced Snowflake Data Engineer with strong expertise in Snowflake Data Warehousing, Salesforce Data Cloud (Data 360), SQL Development, ETL/ELT Processes, and Cloud Data Integration. The ideal candidate will be responsible for building scalable data solutions, supporting Customer 360 initiatives, implementing Salesforce Data Cloud capabilities, and developing enterprise-grade data pipelines for analytics and business intelligence solutions.

The Opportunity

As a Snowflake Data Engineer, you will play a critical role in designing, developing, and supporting modern cloud-based data platforms. You will work closely with business stakeholders, architects, and engineering teams to deliver Snowflake and Salesforce Data Cloud solutions while ensuring high standards of data quality, scalability, performance, and governance.

Key Roles & Responsibilities

Analyze and develop a deep understanding of existing Snowflake data models, ETL/ELT processes, Salesforce Data Cloud structures, and enterprise integrations.

Support Redshift-to-Snowflake migration initiatives, including assessment, architecture planning, schema conversion, data migration, testing, performance tuning, and production deployment.

Design, develop, and maintain Snowflake database objects including tables, views, streams, tasks, stored procedures, and data pipelines.

Build and manage Salesforce Data Cloud (Data 360) components including:

• Data Streams
• Data Lake Objects (DLOs)
• Data Model Objects (DMOs)
• Identity Resolution
• Calculated Insights
• Customer 360 Profiles

Develop scalable ETL/ELT pipelines supporting enterprise reporting and analytics initiatives.

Create and optimize complex SQL queries for reporting, transformation, reconciliation, and analytical workloads.

Design and support integrations between:

• Snowflake
• Salesforce Data Cloud
• Salesforce CRM
• AWS Services
• Enterprise Applications

Validate data migrations, data loads, and transformations to ensure completeness, consistency, and accuracy.

Monitor and optimize Snowflake performance, including:

• Query tuning
• Warehouse sizing
• Workload management
• Storage optimization

Support User Acceptance Testing (UAT), release activities, and post-production support.

Troubleshoot and resolve production incidents, data discrepancies, and integration failures.

Develop technical documentation for data models, mappings, ETL workflows, integrations, and operational procedures.

Implement data governance, security, compliance, and privacy controls.

Collaborate with business stakeholders and technical teams to deliver scalable Customer 360 and analytics solutions.

Ensure adherence to SLAs, operational standards, and enterprise best practices.

What You Need

Requirements

Strong experience in Snowflake Data Warehousing and Data Engineering.

Hands-on expertise in Salesforce Data Cloud (Data 360) implementation and administration.

Experience supporting Redshift-to-Snowflake migrations.

Strong SQL development, optimization, and performance tuning skills.

Experience designing and maintaining ETL/ELT pipelines.

Strong understanding of enterprise data architecture and cloud data ecosystems.

Experience implementing Customer 360 solutions and identity resolution frameworks.

Understanding of data governance, security, privacy, and compliance practices.

Excellent analytical, troubleshooting, and problem-solving abilities.

Ability to work independently and drive technical solutions.

Strong communication and stakeholder management skills.

Required Skills

Data Engineering

Snowflake Data Warehouse

Data Modeling

ETL/ELT Development

Data Integration

Data Migration

Data Validation

Data Governance

Data Quality Management

Salesforce Data Cloud

Salesforce Data Cloud (Data 360)

Data Streams

Data Lake Objects (DLOs)

Data Model Objects (DMOs)

Identity Resolution

Calculated Insights

Customer 360

Salesforce CRM Integration

Database & Development

SQL

Advanced Query Optimization

Stored Procedures

Streams & Tasks

Data Reconciliation

Performance Tuning

Cloud & Integration

AWS S3

AWS Glue

AWS AppFlow

Cloud Data Integration

API Integration

Testing & Support

UAT Support

Production Support

RCA (Root Cause Analysis)

Incident Resolution

Desired Skills

Python Programming

Advanced AWS Services

Redshift Administration

Data Lake Architecture

Data Mesh Concepts

Customer Analytics Platforms

AI-Driven Analytics

CI/CD for Data Engineering

DevOps Practices

Agile Delivery Methodologies

Healthcare Data Platforms

Qualification

Bachelor's Degree in Computer Engineering, Computer Science, Information Technology, or a related discipline.

Experience

5+ Years

Domain Expertise

Candidates with US Healthcare domain experience will be highly preferred.

Preferred Healthcare Knowledge

Healthcare Analytics

Claims Processing

Member Management

Provider Data Management

Customer 360 Solutions

Healthcare Data Integration

Regulatory and Compliance Requirements

Technology Stack

Snowflake

Salesforce Data Cloud (Data 360)

SQL

AWS S3

AWS Glue

AWS AppFlow

Python (Preferred)

Salesforce CRM

ETL/ELT Frameworks

Redshift Migration

What We Believe

We're proud to embrace the same values that have shaped UST since the beginning. Since day one, we've been building enduring relationships and a culture of integrity. Today, those same values inspire us to encourage innovation, champion diversity and inclusion, and place people at the center of everything we do.

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.

Equal Employment Opportunity Statement

UST is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation.

All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status, or any other basis protected by applicable law.

UST reserves the right to periodically redefine roles and responsibilities based on organizational requirements and/or employee performance.

Support and promote the values of UST.

Comply with all Company policies and procedures.