> Markdown version of [/jobs/ext/1911587-snowflake-architect-implementation-consultant](https://www.wearedevelopers.com/jobs/ext/1911587-snowflake-architect-implementation-consultant). 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 Architect / Implementation Consultant

- **Company:** BRAINDO LLC
- **Location:** Philadelphia, PA, United States (Remote available)
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Artificial Intelligence, Data Analysis, ARM Architecture, Code Review, Databases, Extract Transform Load (ETL), Data Structures, Data Warehousing, Microsoft SQL Server, Performance Tuning, Role-Based Access Control, Power BI, Standard Sql, Tableau (Software), Large Language Models, Snowflake, Data Layers, Core Data, Star Schema, Data Pipelines
- **Published:** August 4, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=68c7fa0185bf15c7

## About the Role

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

## Description

BrainDo is expanding our data and analytics practice and needs an experienced Snowflake specialist to guide and lead migrations. The focus is on architecture, migration planning, and hands-on implementation support for client projects., * 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., * 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.


## Related Videos

- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one)
- [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers)
- [Dev Digest 132 - Binging WADFlix?](https://www.wearedevelopers.com/magazine/473-dev-digest-132-binging-wadflix)
- [Dev Digest 162: AI careers, MCP, AWS best practices & floppy sweaters](https://www.wearedevelopers.com/magazine/571-dev-digest-162-ai-careers-mcp-aws-best-practices-floppy-sweaters)