Job Summary
The Snowflake Data Architect will design, develop, and implement enterprise data engineering and analytics architectures, with a focus on building scalable Snowflake solutions from the ground up. The role requires strong expertise in Snowflake, cloud data services, ELT pipeline development, modern data architecture, governance, and performance optimization. The architect will lead solution design and implementation, collaborate with stakeholders, define technical roadmaps, and deliver enterprise data solutions.
Key Responsibilities
• Lead greenfield Snowflake implementations and build enterprise data platforms from the ground up.
• Design and deploy scalable Snowflake solutions to support enterprise data engineering and analytics requirements.
• Design and implement ELT pipelines using SQL and cloud-native tools.
• Leverage cloud services that complement Snowflake, including Azure Data Factory, AWS Glue, and GCP Dataflow.
• Establish modern data architecture patterns, including Medallion lakehouse models, Data Vault, and dimensional modeling using Inmon and Kimball methodologies.
• Implement data governance and security best practices, including Snowflake role-based access control (RBAC), masking policies, and compliance controls.
• Optimize Snowflake environments using clustering keys, materialized views, and query performance tuning.
• Evaluate and support streaming architectures and real-time data processing solutions.
• Lead teams through solution design, implementation, and deployment in Agile delivery environments.
• Engage with stakeholders to define technical roadmaps and deliver high-impact data solutions.
• Support DataOps practices and CI/CD processes for Snowflake deployments.
• Contribute to machine learning and AI pipeline development using Snowpark and external ML platforms.
Required Qualifications
• 7+ years of experience in enterprise data engineering and analytics architecture.
• 3+ years of hands-on experience designing and deploying Snowflake solutions.
• Proven experience leading greenfield Snowflake implementations and building enterprise data platforms from the ground up.
• Deep expertise in cloud services that complement Snowflake, such as Azure Data Factory, AWS Glue, and GCP Dataflow.
• Extensive experience designing and implementing ELT pipelines using SQL and cloud-native tools.
• Strong understanding of modern data architectures, including Medallion lakehouse models, Data Vault, and dimensional modeling using Inmon and Kimball methodologies.
• Proficiency in data governance and security best practices, including Snowflake RBAC, masking policies, and compliance controls.
• Hands-on experience optimizing Snowflake environments through clustering keys, materialized views, and query performance tuning.
• Experience working in Agile delivery environments and leading teams through solution design, implementation, and deployment.
• Strong consultative skills with the ability to engage stakeholders, define technical roadmaps, and deliver enterprise solutions.
• Bachelor's degree in Management Information Systems, Computer Information Systems, Computer Science, or a related field, or equivalent applicable education and experience.
Preferred Qualifications
• Experience with streaming architectures and real-time data processing technologies such as Kafka and Snowpipe Streaming.
• Prior experience working at Snowflake or directly with Snowflake Professional Services.
• Snowflake technical certifications, such as SnowPro Advanced Architect or SnowPro Core.
• Exposure to IDMC (Informatica Intelligent Data Management Cloud), Fivetran, or Matillion.
• Experience with DataOps concepts and CI/CD pipelines for Snowflake deployments.
• Knowledge of machine learning and AI pipelines using Snowflake Snowpark and external ML platforms.
• Master's degree in a quantitative or related discipline, or equivalent applicable experience.