Sr Snowflake Consultant

As a Sr Snowflake Consultant/Architect, you will collaborate with cross-functional teams to modernize data environments and translate business requirements into scalable, secure, and resilient data solutions. This role demands a balance of advanced technical data engineering skills and consultative client-facing abilities. Key Responsibilities: - Architecture & Solution Design: Design secure, scalable data warehouses, data lakes, and data mesh architectures tailored to specific client needs. - Data Pipelines & Integration: Build and optimize ELT/ETL data pipelines using Python, SQL, Snowpark, and modern transformation tools like dbt. - Migration & Upgrades: Lead the migration of legacy on-premises or cloud databases (e.g., Oracle, Teradata, AWS Redshift) into the Snowflake environment. - Performance & Cost Optimization: Monitor database performance, right-size virtual warehouses, utilize micro-partitioning, and enforce cost-guardrails (auto-suspend targets, query tagging). - Security & Governance: Configure Role-Based Access Control (RBAC), row/column-level security, data masking, and secure data sharing. - Client Engagement: Lead client workshops, document technical specifications, and provide strategic recommendations to both technical teams and executive stakeholders. Required Qualifications & Tech Stack: - Education: Bachelors Degree in Computer Science, Information Systems, Engineering, or a related field. - Experience: 6+ years of experience in data warehousing, data engineering, or data architecture. - Core Competencies: Advanced SQL fluency, dimensional data modeling (Star/Snowflake schemas), and database optimization. - Languages: Proficiency in Python and SnowSQL. - Tooling: Familiarity with data build tool (dbt), CI/CD pipelines (Git), and cloud environments (AWS, Azure, or GCP). - Soft Skills: Excellent written and verbal communication, analytical problem solving, and the ability to work in Agile/Scrum environments. In addition, Preferred Certifications include: - SnowPro Core Certification - SnowPro Advanced certifications (e.g., Architect, Data Engineer) As a Sr Snowflake Consultant/Architect, you will collaborate with cross-functional teams to modernize data environments and translate business requirements into scalable, secure, and resilient data solutions. This role demands a balance of advanced technical data engineering skills and consultative client-facing abilities. Key Responsibilities: - Architecture & Solution Design: Design secure, scalable data warehouses, data lakes, and data mesh architectures tailored to specific client needs. - Data Pipelines & Integration: Build and optimize ELT/ETL data pipelines using Python, SQL, Snowpark, and modern transformation tools like dbt. - Migration & Upgrades: Lead the migration of legacy on-premises or cloud databases (e.g., Oracle, Teradata, AWS Redshift) into the Snowflake environment. - Performance & Cost Optimization: Monitor database performance, right-size virtual warehouses, utilize micro-partitioning, and enforce cost-guardrails (auto-suspend targets, query tagging). - Security & Governance: Configure Role-Based Access Control (RBAC), row/column-level security, data masking, and secure data sharing. - Client Engagement: Lead client workshops, document technical specifications, and provide strategic recommendations to both technical teams and executive stakeholders. Required Qualifications & Tech Stack: - Education: Bachelors Degree in Computer Science, Information Systems, Engineering, or a related field. - Experience: 6+ years of experience in data warehousing, data engineering, or data architecture. - Core Competencies: Advanced SQL fluency, dimensional data modeling (Star/Snowflake schemas), and database optimization. - Languages: Proficiency in Python and SnowSQL. - Tooling: Familiarity with data build tool (dbt), CI/CD pipelines (Git), and cloud environments (AWS, Azure, or GCP). - Soft Skills: Excellent written and verbal communication, analytical problem solving, and the ability to work in Agile/Scrum environments. In addition, Preferred Certifications include: - SnowPro Core Certification - SnowPro Advanced certifications (e.g., Architect, Data Engineer)