What are the responsibilities and job description for the Senior Snowflake Developer in Trenton, NJ(Hybrid) - 745571 position at Super Technology Solutions, Inc.?
Job Details
One of our premier clients is looking for Senior Snowflake Developer in Trenton, NJ(Hybrid) for a contract position. If interested, please submit your resume ASAP indicating (1) current location (2) desired hourly rate, W2 or 1099? (3) Your email address.
RESPONSIBILITIES:
Collaborate with data architects to design and develop Snowflake data models and schemas.
Create and maintain a well-structured data warehouse and data lake architecture.
Develop ETL (Extract, Transform, Load) processes to ingest data from various sources into Snowflake.
Ensure data integration processes are efficient, reliable, and scalable.
Design and implement data pipelines using Snowflake features like tasks and streams.
Optimize query performance by creating and maintaining appropriate indexes, materialized views, and clustering keys.
Identify and resolve performance bottlenecks in data processing.
Write complex SQL queries, stored procedures, and user-defined functions (UDFs) to support data analytics and reporting needs.
Ensure SQL code follows best practices for readability and performance.
Implement and manage security measures, including role-based access control (RBAC) and data encryption, to protect sensitive data.
REQUIRED SKILLS:
Snowflake Data Warehouse Design & Development
Cloud Computing, Preferably AWS (Azure, Google Cloud Platform-)
Data Modeling (Star Schema, Snowflake Schema)
Continuous Integration/Deployment (CI/CD) Tools
Performance Tuning & Optimization
SQL for Data Querying & Manipulation
Data Migration to Cloud Platforms
Data Security & Governance in Cloud Environments
Data Warehousing Best Practices
Automation using Python/SnowSQL
ETL/ELT Processes using Snowflake
Snowflake Stored Procedures, UDFs, and Views
Working with Snowflake Utilities (SnowPipe, Streams, Tasks)
Data Integration (Informatica, Talend, Matillion, DBT - Preferable)
Bachelor's Degree minimum