Snowflake Architect / Implementation Consultant

Job Info

• Employment Type: Fractional / Contract (Remote)

What you'll do

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

What we're looking for

• 3+ years working directly with Snowflake as a 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.
• Comfort partnering with a consultancy: we own the client relationship and business context; you own deep Snowflake execution and architectural guidance.

Nice to have (not required):

• Experience with dbt, Fivetran/other ELT tools, and modern BI tools (e.g., Sigma, Power BI, Tableau).
• Exposure to AI/LLM use cases on top of Snowflake (Cortex, semantic layers, etc.).

The Role

• Fractional / contract role – remote.
• Initial engagement focused on architecture review and migration planning for one client, with option to extend into ongoing implementation support.
• Expected cadence: 5-20 hours per week during active phases; flexible based on project demand.

What we want from you

• A short summary of 2-3 Snowflake projects you’ve worked on (source systems, scale, your role, biggest challenges).
• A brief description of how you typically structure a Snowflake migration.
• Your hourly or day rate and preferred engagement model (e.g., fixed-scope vs. hourly).
• Your availability over the next 2-3 months.

About BrainDo

We are a Philadelphia-based team of digital marketing experts who partner with our clients to create meaningful experiences with data-driven results.

BrainDo is an equal opportunity employer committed to fostering a culture of equality, inclusion, and fairness each foundational to our core values. We strive to create a diverse environment where each employee is encouraged to bring their unique ideas, backgrounds, and experiences to the workplace.

If you think you’re the right person for the position, we’d love to hear from you! Send your resume to [email protected].