drjobs Data ArchitectSnowflake

Data ArchitectSnowflake

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

San Francisco, CA - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Snowflake Data Architect
About Decision Minds:
Decision Minds is a Silicon Valley based AIfirst data solutions company specializing in data cloud solutions GenAI and AIInfused Product Engineering services and multiple global locations. We serve many fortune 100 companies across technology financial services and healthcare sectors with our own products and IP driven services supported by our strong technology practices in Snowflake Data bricks Google Big Query and Microsoft Cloud.

We are looking for a Snowflake Architect who will perform mission critical duties in our data engineering strategy contributing to and leading the development of our Enterprise Data and Analytics Platforms. A passionate professional who can blend the everevolving technology landscape of Cloud and Advanced Analytics with responsibilities to provide input on implementation and administration methodologies to management.
The Snowflake Architect will mainly be responsible to develop optimize and oversee companys logical conceptual and physical data model and provide recommendations. This role will be responsible for expanding optimizing and monitoring our expanding data pipelines through meticulous architect intelligent business logic consistent data governance testing and continuous delivery.

Responsibilities
  • Deep understanding of relational as well as NoSQL data stores methods and approaches (star and snowflake dimensional modelling).
  • Experience with data security and data access controls and design in Snowflake.
  • Proficiency in complex SQL Unix Shell/Python Scripting performance tuning and database optimization techniques.
  • Must have expertise in AWS Platform as a Service (PAAS) model and its integration with Snowflake to load/unload data.
  • Implement cloudbased Enterprise data warehouse solutions with multiple data platforms along with Snowflake and NoSQL environment to build data movement strategy.
  • Lead in Developing Project requirements for endtoend Data integration process using ETL for Structured semistructured and Unstructured Data.
  • Make necessary ongoing updates to modeling principles processes solutions and best practices to ensure that the Snowflake is aligned with the business needs of the environment.
  • Act as Data domain expert for Snowflake in a collaborative environment to provide demonstrated understanding of data management best practices and patterns.

Required Knowledge and Level of Experience

  • 8 years of experience implementing data management solutions (Required).
  • Management consulting experience (Highly Desired).
  • Expertise in Snowflake concepts like setting up Resource monitors RBAC controls scalable virtual warehouse SQL performance tuning zero copy clone time travel and automating them.
  • Experience in handling semistructured data (JSON XML) columnar PARQUET using the VARIANT attribute in Snowflake.
  • Experience in reclustering of the data in Snowflake with good understanding of MicroPartitions.
  • Experience in Migration processes to Snowflake from onpremises database environment.
  • Experience in designing and building manual or auto ingestion data pipeline using Snowpipe.
  • Experience in Cloud technologies such as AWS S3 SQS EC2 Lambda Redshift RDS
  • Design and Develop automated monitoring processes on Snowflake using combination of Python PySpark Bash with SnowSQL.
  • SnowSQL Experience in developing stored Procedures writing Queries to analyze and transform data.
  • Certified Snowflake cloud data warehouse Architect (Desirable).




Employment Type

Full-Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.