NEW JOB OPENING
SENIOR SNOWFLAKE DEVELOPER
IN Trenton, NJ, USA!

*** Only Qualified Senior Snowflake Developer candidates currently located in the Trenton, NJ area will be considered due to the position requiring an onsite Presence***



Senior Snowflake Developer will design, implement, and optimize data solutions using the Snowflake cloud data platform. This role plays a pivotal part in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics for our client.



Required Education:

• Bachelor's or master's degree in computer science, data engineering, or a related field.



Required Skills and Experience:

• Snowflake Data Warehouse Design & Development (7 Years)

• Cloud Computing, Preferably AWS (Azure, GCP) (7 Years)

• Data Modeling (Star Schema, Snowflake Schema) (7 Years)

• Continuous Integration/Deployment (CI/CD) Tools (7 Years)

• Performance Tuning & Optimization (7 Years)

• SQL for Data Querying & Manipulation (7 Years)

• Data Migration to Cloud Platforms (7 Years)

• Data Security & Governance in Cloud Environments (7 Years)

• Data Warehousing Best Practices (7 Years)

• Automation using Python/Snow SQL (7 Years)

• ETL/ELT Processes using Snowflake (5 Years)

• Snowflake Stored Procedures, UDFs, and Views (5 Years)

•Working with Snowflake Utilities (SnowPipe, Streams, Tasks) (5 Years)



Desired Skills and Experience:

• Data Integration (Informatica, Talend, Matillion, DBT Preferable) (5 Years)



Senior Snowflake Developer Job Duties:

Data Architecture:

• 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.

Data Integration:

• 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.

Performance Optimization:

• Optimize query performance by creating and maintaining appropriate indexes, materialized views, and clustering keys.

• Identify and resolve performance bottlenecks in data processing.

SQL Development:

• 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.

Security and Access Control:

• Implement and manage security measures, including role-based access control (RBAC) and data encryption, to protect sensitive data.

• Audit and monitor data access and user activities.

Data Quality Assurance:

• Define and implement data quality checks and validation processes to maintain data accuracy.

• Establish data quality rules and alerts to proactively identify issues.

Documentation:

• Create and maintain technical documentation for data models, ETL processes, and data dictionaries.

• Document best practices, standards, and guidelines for Snowflake development.

Version Control and Deployment:

• Use version control systems (e.g., Git) for managing Snowflake SQL scripts and objects.

• Coordinate the deployment of changes to Snowflake environments.

Monitoring and Alerts:

• Set up monitoring and alerting for Snowflake environments to proactively detect and respond to issues.

• Troubleshoot and resolve incidents related to data processing and performance.

Backup and Recovery:

• Implement backup and recovery strategies to ensure data integrity and availability.

• Develop and test data recovery procedures.

Collaboration:

• Collaborate with data engineers, data scientists, and business analysts to understand data requirements and provide data solutions.

• Work with cross-functional teams to support data-related projects and initiatives.