Role: The Senior Snowflake Data and Platform Engineer at North Mark Strategies group would lead the design, development, and administration of our Snowflake ecosystem. This hybrid role blends deep platform administration with hands-on data engineering, enabling secure, scalable, and high-performance data solutions across the organization.
Key Responsibilities:
Snowflake Data Engineering:
Implement real-time and batch ingestion, transformation, and ETL pipelines using Snowpipe, Streams and Tasks
Develop stored procedures, functions, and views to support business intelligence and reporting
Configure and manage external storage integrations in a multi-cloud environment (e.g., Azure Blob, AWS S3, Google Cloud Platform)
Build and maintain logical and physical data models
Automate data quality checks, monitoring, and alerting using Python scripts and orchestration tools
Snowflake Platform Engineering:
Administer and optimize Snowflake environments, including warehouses, roles, network and security policies and performance tuning
Design and implement robust Business Continuity/Disaster Recovery process, including backup, failover, replication, and recovery procedures
Continuously track Snowflake enhancements and share relevant updates with the team to ensure the team remains informed
Partner with the Internal IT Security team to assess and remediate findings identified during security audits
Manage user provisioning, data security, roles, and access controls across multiple environments
Lead the team in adhering to established Snowflake best practices
Must-have Requirements:
Atleast 5 years of experience in Snowflake platform administration and data engineering
Strong skills in SQL, Change Data Capture, Snow Pipes, Streams, Tasks, Stored procedures, Functions and SnowSQL
Should have data modeling experience in Snowflake along with creating ERD's
Hands-on Python development experience
Should have knowledge of Real time or Near-real time streaming data using Snowpipe, Streams and Tasks
Knowledge of Cloud platforms (AWS, Azure, or Google Cloud Platform) and data integration
Experience with performance tuning, indexing, and query optimization in Snowflake
Snowflake SnowPro Advanced certification
Preferred Requirements:
Data Vault 2.0 modeling experience
Experience with CI/CD pipelines and DevOps practices for Snowflake
Knowledge of DBT is a plus
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.