Snowflake Data Warehouse

Company Description New York Global Consultants Inc. (NYGCI) is an innovative technology services provider specializing in IT consulting, data protection, and application performance management. The company designs, builds, and operates IT infrastructure and business processes that help clients improve productivity and performance. NYGCI serves Fortune Global 500 organizations through business process outsourcing, infrastructure consulting, application development, managed IT, and cloud services. Founded in 2007 in New York, the company has expanded its presence to more than half of the U.S. states and operates in India to support global clients. NYGCI combines deep industry insight with technology expertise to help customers maximize performance and achieve their strategic goals.

Job Description:

• Configure, deploy, and maintain Snowflake accounts, virtual warehouses, databases, and schemas.

• Use Terraform to provision and manage Snowflake resources (databases, warehouses, roles, users) and associated cloud infrastructure, ensuring consistency and repeatability through Infrastructure as Code.

• Monitor warehouse performance, query performance, and resource utilization; troubleshoot issues to ensure optimal system performance.

• Implement and manage access controls, including role-based access control (RBAC), secure data sharing, and data governance policies to protect sensitive data.

• Manage Snowflake releases, features, and account-level configurations; evaluate and enable new capabilities as needed.

• Provide technical support to Snowflake users, including query troubleshooting, performance tuning, and issue resolution.

• Optimize warehouse sizing, auto-suspend/resume settings, and query design for performance and cost efficiency.

• Monitor and manage auto-scaling of virtual warehouses to ensure efficient resource allocation.

• Implement and enforce security policies, including RBAC, masking policies, row-level security, and encryption mechanisms.

• Develop and maintain backup, failover, and disaster recovery strategies using features like Time Travel and Fail-safe to ensure data integrity and availability.

• Collaborate with data engineers to integrate Snowflake with external data sources, data lakes, and ETL/ELT pipelines.

• Monitor and manage platform costs, including credit usage, storage costs, and optimizing workloads to control expenses.

• Collaborate with cross-functional teams (data engineers, data scientists, analysts, and business stakeholders) to understand requirements and deliver scalable data solutions.

Must have: Snowflake Infrastructure

Good To Have: Terraform, Databricks

Number of years experiences needed: 3-5 (or more is accepted)