View all jobs SnowFlake DBA, Snowflake Platform Specialist Newark, NJ Apply Now
EDP Snowflake Platform Specialist
Our Client is building an AWS Enterprise data platform built for the cloud that is effective, affordable, and accessible to all data users. We’re looking for a talented contractor, Snowflake specialist for our EDP team. In this role, you will work closely with our Product, Engineering, IT, and Data Science teams to build best in class infrastructure supporting data across the company. This is a strategic, high-impact role that will also help shape the future of our Hybrid AWS Platform.
In this role, you will work closely with our Product, Engineering, IT, and Data Science teams to build best in class infrastructure supporting data across the company
Design, Deploy & Monitor Multi-tenant Lakehouse environment.
Design, Deploy the RBAC security Model in Multi-tenant Lakehouse environment.
Design, build, and own the core data models and key infrastructure to manage data and usage across our Snowflake/Redshift account with an emphasis on Multi Tenancy and Security.
Responsible to integrate Snowflake/Redshift Database with SAML or OpenID Provider for Authentication
Create Snowflake/Redshift utilization and Capacity Plan for general housekeeping as well as for peak period.
Implement Snowflake/Redshift best practices & considerations for managing load operations and performance which will aid in creating right size Snowflake/Redshift warehouses.
Implement Data Masking policies to protect PII/PCI Data.
Create and manage multiple accounts across the Organization.
Good knowledge of Time Travel & Cloning
Automate tenant onboarding to Multi-Tenant Snowflake/Redshift Platform.
Automate RBAC Security model with Sailpoint Integration.
Automate Internal/External Data catalog.
Good Understanding of data replication for data sharing across accounts and for failover scenarios
Good Understanding of Snowflake ODBC, JDBC drivers as well as SnowSQL in terms of usage as well as troubleshooting any issues
Good Understanding of Snowflake Snowpark
Collaborate closely with Engineering, Product Management, IT, Finance, and Compliance to inform product decision making with data and to identify opportunities for system improvements.
Collaborate with the Engineering, IT, and Compliance team to meet data governance requirements.
Build dashboards to help IT Leadership monitor performance and availability of our system.
Think creatively to find optimal solutions to our complex, often unstructured problems.
Design and implement a data quality monitoring system. The system should include source-to-target data validations as well as anomaly detection.
10+ years’ experience including:
2+ Years’ experience as Redshift DBA/Developer.
2+ years’ experience as Snowflake DBA.
Designing and building complex data pipelines in a large-scale data environment.
Experience with Salesforce, Workday, and application integrations
Snow Pro Core Certification preferred
Experience in CI/CD implementation of Snowflake data Platform.
Ability to clearly present learnings to business leaders and technical stakeholders
The ability to thrive in a dynamic environment. That means being flexible and willing to jump in and do whatever it takes to be successful. In accordance with applicable law, the