Snowflake Migration Architect Technical Lead Senior Developer

BUGENDAITECH US LLC

Scottsdale (AZ)

Remote

USD 150,000 - 220,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Employee discounts
Health insurance
Paid time off
Bonus based on performance
Competitive salary
Dental insurance
Flexible schedule
Opportunity for advancement
Training & development

Job summary

BUGENDAITECH US LLC is seeking a senior Snowflake Migration Architect / Technical Lead to drive large-scale migrations from on-premises databases to the Snowflake Cloud Data Platform. You will own architecture, design, development, migration planning, performance tuning, testing and post-production stabilization.

The ideal candidate will have hands-on Snowflake expertise, experience with healthcare data domains (PHI/PII, HIPAA) and a proven ability to lead cross-functional teams through complex

Qualifications

  • 5+ years of experience in data engineering or data architecture roles.
  • Hands-on Snowflake experience including migrations, performance tuning and administration.
  • Experience leading technical teams in an Agile environment.
  • Snowflake SnowPro certification is a plus.
  • Strong communication skills with ability to present complex concepts to non-technical stakeholders.

Responsibilities

  • Lead end-to-end migration of on-premises databases/data warehouses to Snowflake.
  • Assess existing on-prem environment, objects, schemas, ETL, dependencies, data volumes, interfaces, workloads.
  • Define Snowflake target architecture and migration strategy, including waves and cutover plan.
  • Design scalable Snowflake architecture: databases, schemas, warehouses, storage, compute, roles, security, access controls.
  • Develop using Snowflake SQL, SnowSQL, stored procedures, streams, tasks, dynamic tables, Snowpipe, and related features.
  • Migrate large volumes of historical and incremental data to Snowflake.
  • Modernize ETL/ELT pipelines for Snowflake platform.
  • Design data ingestion patterns: batch, CDC, near-real-time as needed.
  • Perform source-to-target mapping, data reconciliation, validation, and migration testing.
  • Optimize Snowflake workloads for performance, utilization, scalability and cost.
  • Identify and remediate SQL/query/ pipeline performance bottlenecks.
  • Design data security, RBAC, masking, encryption, auditing and governance controls.
  • Ensure healthcare data security/privacy requirements are met.
  • Collaborate with application, infrastructure, security, data engineering and business teams.
  • 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 specs, runbooks and docs.

Skills

Data engineering
Data architecture
Team leadership
Agile

Tools

Snowflake

Job description

Benefits:

Employee discounts

Health insurance

Paid time off

Bonus based on performance

Competitive salary

Dental insurance

Flexible schedule

Opportunity for advancement

Training & development

About the Role:

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

Key Responsibilities
  • 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.
Requirements:
  • 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
About Us:

BUGENDAITECH US LLC is a forward-thinking technology solutions company dedicated to delivering innovative data and cloud transformation services to clients across industries. Our team is built on a culture of collaboration, continuous learning, and technical excellence, making it a place where top talent can truly thrive. We are committed to empowering our employees with the tools, support, and opportunities they need to grow their careers and drive meaningful results.

This is a remote position.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Snowflake Migration Architect / Technical Lead / Senior Developer
Snowflake Migration Architect / Technical Lead / Senior Developer

BUGENDAITECH US LLC • United States

Remote
USD 150,000 - 190,000
Employee discounts
Health insurance
Paid time off
+6
Remote Snowflake Migration Lead & Data Platform Architect
Remote Snowflake Migration Lead & Data Platform Architect

BUGENDAITECH US LLC • United States

Remote
USD 150,000 - 190,000
Employee discounts
Health insurance
Paid time off
+6
Remote Snowflake Migration Architect & Lead
Remote Snowflake Migration Architect & Lead

BUGENDAITECH US LLC • Scottsdale (AZ)

Remote
USD 150,000 - 220,000
Employee discounts
Health insurance
Paid time off
+6
Snowflake Solution Architect
Snowflake Solution Architect

Causeway Bridge to Innovation LLC • Tampa (FL)

On-site
USD 140,000 - 180,000
Snowflake Solution Architect
Snowflake Solution Architect

Staffingine LLC • Peoria (IL)

On-site
USD 165,000 - 248,000
Senior Snowflake Engineer
Senior Snowflake Engineer

Jobgether • United States

Remote
USD 150,000 - 210,000
Remote work within US
3-month contract
Tech Lead / Senior Architect – Data Engineering
Tech Lead / Senior Architect – Data Engineering

Virtusa Corporation • United States

Remote
USD 180,000 - 240,000
Key Skills: Senior Snowflake Data Architect
Key Skills: Senior Snowflake Data Architect

Datavail • Boulder (CO)

Remote
USD 170,000 - 240,000
Senior Snowflake Developer
Senior Snowflake Developer

DataArt • United States

Hybrid
USD 120,000 - 210,000
Vacation days
Illness days
Health insurance
+4
Snowflake Data Engineer
Snowflake Data Engineer

Liberty Personnel Services, Inc. • Harmonville (PA)

Hybrid
USD 120,000 - 170,000