SNOWFLAKE with DBT Developer

Role Summary: Design, build, and optimize data pipelines and Snowflake-based solutions supporting enterprise analytics and reporting needs.Key ResponsibilitiesDesign, develop, and maintain ETL/ELT pipelines using Snowflake, along with tools like Snowpipe, Streams, Tasks, and Snowflake Scripting/SQL Stored ProceduresWrite complex, high-performance SQL queries, views, and UDFs for data transformation and analyticsIntegrate Snowflake with tools such as Informatica, Talend, dbt, Matillion, Airflow, or ADF for data ingestion/orchestrationImplement data loading strategies (bulk load, COPY INTO, external stages, Snowpipe for near real-time ingestion)Optimize warehouse sizing, query performance, clustering keys, and caching strategies to control cost and improve efficiencyImplement role-based access control (RBAC), row-level/column-level security, and data masking policiesWork with semi-structured data (JSON, Parquet, Avro) using VARIANT, FLATTEN, and related functionsCollaborate with data modelers/architects to implement physical data models (dimensional/Data Vault) in SnowflakeTroubleshoot production issues, monitor pipeline health, and support CI/CD deployment of Snowflake objectsDocument technical designs, data flows, and coding standards; mentor junior developers (for senior-level candidates)Required Skills7+ years overall data engineering experience, with 4+ years hands-on Snowflake experienceStrong SQL and Snowflake-specific features (Time Travel, Zero-Copy Cloning, Streams & Tasks, Secure Views)Experience with cloud platforms (AWS/Azure/GCP) and associated storage services (S3, ADLS, GCS)Proficiency in at least one ETL/orchestration tool (dbt, Informatica, Talend, Airflow, ADF, Matillion)Scripting experience in Python or Shell for automationUnderstanding of data warehousing concepts, dimensional modeling, and CDC patternsFamiliarity with version control (Git) and CI/CD pipelines (Jenkins, Azure DevOps, GitHub Actions)Snowflake certification (SnowPro Core, preferred)