Snowflake SME Location: Remote Employment Type: Contract or Full-Time Position Overview We are looking for a highly skilled and experienced Snowflake Data Engineer to join our growing data engineering team. The ideal candidate will possess deep hands-on expertise in Snowflake and a strong background in designing, building, and optimizing scalable data pipelines. This role plays a critical part in enabling enterprise-wide analytics by ensuring robust, high-performance data architecture. Key Responsibilities • Design and build scalable data pipelines leveraging SnowPipe, External Stages, and Kafka Connectors for Snowflake • Manage DDL/DML operations, execute database schema migrations, and maintain schema integrity • Develop and optimize ETL/ELT workflows using SQL and Python • Architect and maintain efficient data models to support business intelligence and operational workloads • Leverage Snowflake Time Travel and other advanced features for auditing, version control, and data recovery • Collaborate with stakeholders to gather data requirements and translate them into effective solutions • Monitor and enhance data pipeline performance and reliability • Implement and maintain Application Performance Monitoring (APM) to ensure smooth data operations Required Skills & Experience • Proven, hands-on expertise with the Snowflake Data Cloud • Strong proficiency with: • SnowPipe • External Stages • Kafka Connector for Snowflake • DDL/DML operations • Database schema design and migrations • Data modeling for analytics and operations • ETL/ELT design using SQL and Python • Snowflake Time Travel and advanced Snowflake features • Solid experience with APM tools for monitoring data pipelines and system performance Preferred Qualifications • Familiarity with CI/CD practices in a data engineering context • Experience working in cloud environments such as AWS, Azure, or Google Cloud Platform (GCP)