logo

View all jobs

SnowFlake DBA, Snowflake Platform Specialist

Newark, NJ
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.

Job Responsibilities:
 
  • 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.

Qualification:
 
  • 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
  • Expert level Python/SQL, JavaScript and experience building Stored Procedures
  • 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

 

More Openings

Project Manager
Embedded Engineer

Share This Job

Powered by