Senior Developer

BUGENDAITECH US LLC

8d•Remote

About The Position

BUGENDAITECH US LLC is seeking a senior, hands-on Snowflake Migration Architect / Technical Lead / Senior Developer to lead the migration of large-scale on-premises databases and data warehouse platforms to the Snowflake Cloud Data Platform. The role covers architecture, design, development, migration planning, performance optimization, testing, cutover, and post-production stabilization. The successful candidate will bring strong Snowflake expertise, experience executing complex database or data warehouse migrations, and previous experience working with healthcare data or platforms. The position involves assessing existing environments and defining target architectures and migration strategies; developing and modernizing Snowflake data solutions and ingestion pipelines; validating and optimizing migrated workloads; and implementing security and governance controls. The role collaborates with technical, business, and healthcare teams and provides technical leadership, production support, and migration documentation. This is a remote position.

Requirements

At least 5 years of experience in data engineering, data architecture, or a related technical role.
Proven hands-on Snowflake experience, including migrations, performance tuning, and administration.
Experience leading technical teams and managing project deliverables in an Agile environment.
Strong communication skills and ability to present complex technical concepts to non-technical stakeholders.
Previous experience working with healthcare data or platforms.

Nice To Haves

Snowflake SnowPro certification.
Experience with healthcare data or platforms involving patient/member data, claims, providers, eligibility, clinical data, EHR/EMR, payer/provider systems, PHI/PII, HIPAA-controlled environments, HL7, or FHIR is highly preferred.

Responsibilities

Lead end-to-end migration of on-premises databases and data warehouses to Snowflake.
Assess existing environments, including database objects, schemas, ETL processes, dependencies, data volumes, interfaces, and workloads.
Define Snowflake target architecture and migration strategy, including migration waves, cutover, rollback, and production stabilization.
Design Snowflake databases, schemas, warehouses, storage, compute, roles, security, and access controls.
Develop with Snowflake SQL, SnowSQL, stored procedures, streams, tasks, dynamic tables, Snowpipe, and related capabilities.
Migrate historical and incremental data from legacy and on-premises databases into Snowflake.
Re-engineer or modernize ETL/ELT pipelines for Snowflake.
Design batch, incremental/CDC, and near-real-time data ingestion patterns 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 data security, RBAC, masking, encryption, auditing, and governance controls.
Ensure solutions meet applicable healthcare data security and privacy requirements.
Collaborate with application, infrastructure, security, data engineering, DBA, business, and healthcare teams.
Lead technical design reviews and guide developers and data engineers.
Support production cutover, troubleshooting, hypercare, and post-migration optimization.
Prepare architecture diagrams, migration plans, technical specifications, runbooks, and operational documentation.