Snowflake Developer/Architect

*Job Title: Snowflake Developer/Architect* *Location: Remote * *Duration: 6+ Months * *Pay Range: $60/hour to $70/hour on W2* *Role Overview:* *We are seeking an experienced Snowflake Developer/Architect to design, implement, and optimize scalable data solutions on the Snowflake Data Cloud platform. The ideal candidate will have deep expertise in cloud data architecture, data warehousing, ELT/ETL pipelines, and performance tuning, along with strong business acumen to translate data requirements into robust solutions.* *Key Responsibilities*

• Design and architect end-to-end data solutions leveraging Snowflake, ensuring scalability, performance, and security
• Define and implement data models (dimensional & normalized) optimized for analytics and reporting
• Build and optimize data ingestion and transformation pipelines using tools such as Snowpipe, dbt, Informatica, or similar
• Lead Snowflake platform setup, including
• Account structure
• Role-based access control (RBAC) Security & governance
• Optimize query performance, cost management, and warehouse sizing within Snowflake
• Establish data governance, data quality, and metadata management frameworks
• Collaborate with business stakeholders, data engineers, and BI teams to deliver data-driven solutions

*Provide guidance and best practices on:*

• Data architecture
• Data integration
• Data lifecycle management
• Monitor system performance and troubleshoot data-related issues
• Stay updated with Snowflake features and recommend improvement

*Required Skills & Qualifications* *Technical Skill*

• Strong expertise in Snowflake Data Cloud architecture and administration
• Must have DBT
• Experience with cloud platforms: AWS / Azure / GC
• Proficiency in SQL and advanced query optimization technique
• Hands-on experience with ETL/ELT tools (Informatica, Talend, dbt, Matillion, Azure Data Factory, etc.)
• Knowledge of data modeling techniques (Star Schema, Snowflake Schema, Data Vault)
• Experience with data lakes and hybrid architectures
• Familiarity with data governance, security, and compliance frameworks
• Experience with CI/CD pipelines and DevOps practices in data environments

*Preferred Skills*

• Snowflake certifications (e.g., SnowPro Advanced Architect)
• Experience with streaming technologies (Kafka, Kinesis)
• Knowledge of Python / PySpark / Scala
• Exposure to BI tools such as Power BI, Tableau, Looker
• Experience working in Agile/Scrum environments

*Soft Skills*

• Strong problem-solving and analytical skills
• Excellent communication and stakeholder management
• Ability to lead architectural discussions and mentor teams
• Strategic thinking with attention to detail

*“We are an equal opportunity employer. It is our policy to provide employment, compensation, and other benefits related to employment without regard to race, color, religion, sex, gender, national or ethnic origin, disability, veteran status, age, genetic information, citizenship, or any other basis prohibited by applicable federal, state, or local law.”* COM1