Snowflake Architect & Migration Lead (Remote, Fractional)

BrainDo LLC; Philadelphia (Philadelphia County); On-site; USD 165,000 - 248,000; Part time

Job summary

BrainDo is expanding our data and analytics practice and seeks an experienced Snowflake specialist to guide migrations, focusing on architecture, migration planning, and hands-on support for client projects.

This fractional, remote consulting role is not a full-time staff position, with initial engagement on one client and flexible hours of 5-20 per week. You will lead design, optimization, and dialogue with analytics teams.

Qualifications

• 3+ years Snowflake as core data warehouse platform.
• 2+ end-to-end Snowflake implementation or migration projects (design through production cutover).
• Strong SQL and data modeling skills; comfortable with star/snowflake schemas and analytics-friendly design.
• Experience with role-based access control, security, and governance in Snowflake.
• Practical understanding of Snowflake cost drivers and performance optimization.

Responsibilities

• Design and review Snowflake environments (accounts, databases, schemas, warehouses, RBAC).
• Lead or advise on data warehouse migrations into Snowflake (especially from SQL Server or similar systems).
• Define migration phases: assessment, design, extraction/loading, validation, and cutover.
• Build or review ELT pipelines into Snowflake (staging, copy, merge, incremental loads).
• Advise on cost and performance tuning (warehouse sizing, query patterns, clustering, caching).
• Collaborate with BrainDo's analytics and business teams to align data structures with reporting and self-service needs.
• Provide architecture and code reviews, and occasional hands-on implementation support, during active client engagements.

Skills

Snowflake

SQL

Data modeling

RBAC & security

Cost & performance tuning

Migration planning

Architecture leadership

Tools

dbt

Fivetran

Power BI

Job description

BrainDo is expanding our data and analytics practice and seeks an experienced Snowflake specialist to guide migrations, focusing on architecture, migration planning, and hands-on support for client projects.

This fractional, remote consulting role is not a full-time staff position, with initial engagement on one client and flexible hours of 5-20 per week. You will lead design, optimization, and dialogue with analytics teams.