> Markdown version of [/jobs/ext/4354239-snowflake-migration-architect-technical-lead-senior-developer](https://www.wearedevelopers.com/jobs/ext/4354239-snowflake-migration-architect-technical-lead-senior-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Snowflake Migration Architect / Technical Lead / Senior Developer

- **Company:** BUGENDAITECH US LLC
- **Location:** United States (Remote available)
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Query Performance, Agile Methodology, Clinical Data Repository, Databases, Data Architecture, Information Engineering, Data Infrastructure, Extract Transform Load (ETL), Data Mapping, Data Migration, Data Security, Data Warehousing, Performance Tuning, Role-Based Access Control, Migration Manager, Runbook, SQL Stored Procedures, SQL Databases, Cloud Platform System, Data Ingestion, Fast Healthcare Interoperability Resources, Snowflake, Health Level Seven International, Data Pipelines
- **Published:** October 28, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=cc0d9f32e9a5a91b

## About the Role

This is an exciting opportunity to lead cutting-edge cloud data migration initiatives and make a significant impact on enterprise-level data architecture. If you're passionate about modern data platforms and thrive in a fast-paced tech environment, we want to hear from you!
The ideal candidate must have strong hands-on Snowflake expertise, experience designing and executing complex database/data warehouse migrations, and prior experience working within the Healthcare domain.
This is a senior hands-on role requiring the candidate to participate in architecture, design, development, migration planning, performance optimization, testing, cutover, and post-production stabilization.
Healthcare Experience
Candidates must have previous experience working with healthcare data/platforms. Experience with areas such as patient/member data, claims, providers, eligibility, clinical data, EHR/EMR, payer/provider systems, PHI/PII, HIPAA-controlled environments, HL7, or FHIR is highly preferred., * 5+ years of experience in data engineering, data architecture, or a related technical role

 * Proven hands-on experience with Snowflake, including migrations, performance tuning, and administration
 * Experience leading technical teams and managing project deliverables in an Agile environment
 * Snowflake SnowPro certification is a plus
 * Strong communication skills with the ability to present complex technical concepts to non-technical stakeholders

## Description

BUGENDAITECH US LLC is looking for a talented and driven Snowflake Migration Architect / Technical Lead / Senior Developer to lead the migration of large-scale on-premises databases and data warehouse platforms to Snowflake Cloud Data Platform., * Lead end-to-end migration of on-premises databases/data warehouses to Snowflake.

 * Assess the existing on-prem environment, database objects, schemas, ETL processes, dependencies, data volumes, interfaces, and workloads.
 * Define the Snowflake target architecture and migration strategy, including migration waves, cutover approach, rollback strategy, and production stabilization.
 * Design scalable Snowflake architecture including databases, schemas, warehouses, storage, compute, roles, security, and access controls.
 * Perform hands-on development using Snowflake SQL, SnowSQL, Stored Procedures, Streams, Tasks, Dynamic Tables, Snowpipe, and related Snowflake capabilities.
 * Migrate large volumes of historical and incremental data from legacy/on-prem databases into Snowflake.
 * Re-engineer or modernize existing ETL/ELT pipelines for the Snowflake platform.
 * Design data ingestion patterns including batch, incremental/CDC, and near-real-time processing where required.
 * Perform source-to-target mapping, data reconciliation, validation, and migration testing.
 * Optimize Snowflake workloads for query performance, warehouse utilization, scalability, and cost.
 * Identify and remediate performance bottlenecks in SQL queries, data models, pipelines, and warehouse configurations.
 * Design appropriate data security, RBAC, masking, encryption, auditing, and governance controls.
 * Ensure solutions meet applicable healthcare data security and privacy requirements.
 * Work with application, infrastructure, security, data engineering, DBA, business, and healthcare teams throughout the migration.
 * Lead technical design reviews and provide guidance to developers and data engineers.
 * Support production cutover, troubleshooting, hypercare, and post-migration optimization.
 * Prepare architecture diagrams, migration plans, technical specifications, runbooks, and operational documentation.