Principal Snowflake Architect

**Cloud Snowflake Search Engineer Job Description**:

- Securonix provides the Next-Generation Security and Information Event Management (SIEM) solution. As a recognized leader in the SIEM industry, Securonix helps some of the largest organizations globally to detect sophisticated cyber-attacks and rapidly respond to these attacks within minutes. With the Securonix SNYPR platform, organizations can collect billions of events each day and analyze them in near real time to detect advanced persistent threats (APTs), insider threats, privilege account misuses and online fraud. Securonix pioneered the User and Entity Behaviour Analytics (UEBA) market and holds patents in the use of behavioral algorithms to detect malicious activities. The Securonix SNYPR platform is built on big data Hadoop technologies and is infinitely scalable. Our platform is used by some of the largest organizations in the financial, healthcare, pharmaceutical, manufacturing, and federal sectors._

**Summary**:
We are looking for a Senior Snowflake Developer who can perform the design, implementation, and testing of cloud computing solutions using Snowflake technology, creating, monitoring, and optimizing ETL/ELT processes, and migrating solutions from on-premises to public cloud platforms.

We have a great opportunity to help refine a Snowflake Data Solution for Securonix strategic Enterprise Data journey. This is a fantastic opportunity to join Securonix and the Enterprise Data Practice for Securonix, with significant opportunities to influence Enterprise Data, Enterprise Search, and Analytics capabilities.

**Responsibilities**:

- Provide an understanding of Snowflake, Data Warehouse, Data Movement, Data Curation, and Data Staging best practices in relation to existing Snowflake implementations.
- Provide resolution to an extensive range of complicated data pipeline related problems proactively and as issues surface.
- Build processes supporting data transformation, data structures, metadata, dependency and workload management.
- Create and contribute to automating essential processes related to infrastructure solution deployment, creating repeatable and robust deployments.
- Provide Snowflake solutions, including hands on keyboard (implementation)
- Overall ownership of the “platform” and supporting essential platform capabilities
- Responsible for day-to-day sustainment and configuration of the platform, including
- System Health and Telemetry
- Performance and performance tuning
- Data Quality, Protection, and Availability
- Responsible for developing and implementing solutions related to Snowflake and preparing data for deep analytics
- Fully document all solution work, including designs and configurations

Play an essential role in troubleshooting data system problems and provide viable solution options

**Experience Required**:

- Minimum 10 years of experience in IT with a focus on Enterprise Data Solutions
- Minimum 3 years experience in Enterprise Search Solutions using AWS cloud technologies and Snowflake
- Minimum 3 of years of experience in:

- Snowflake Data Solutions, hands-on
- Data warehousing methodologies and modeling techniques Data migration methods of on-prem to cloud data solutions, including ELT/ETL Tools and concepts
- Working with Batch and Stream data
- SQL, preferably Snowflake SQL
- Massively Parallel Processing (MPP) Analytical Datastores
- Expertise in Snowflake advanced concepts like **setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel **and understanding how to use these features
- Experience in Snowflake utilities, including SnowSLQ, Snowpipe, Snowlight for handling Streaming data, is a plus
- Experience in re-clustering Snowflake data with a good understanding of Micro-Partition within Snowflake
- Expertise in deploying Snowflake features such as **data sharing, events and lake-house patterns**:

- Experience in handling semi-structured data (JSON, XML) in Snowflake
- Minimum of 2 years of hands-on experience in Cloud technologies such as
AWS Athena, OpenSearch, AWS Elasticsearch, SQL Data Warehouse
- Certified **Snowflake cloud data warehouse** Architect (Desirable).
- Must have experience of Agile development methodologies
- Strong written communication skills. Is effective and persuasive in both written and oral communication
- Deep understanding of **relational** as well as **NoSQL data stores**, methods and approaches (star and snowflake, dimensional modeling)

**Benefits**:
As a full-time employee with Securonix, you will be eligible for the following employee benefits:

- Health Insurance with total sum insured is INR 5,00,000
- Coverage: Self, Spouse, 2 kids, Dependent parents, or parents-in-law
- Personal Accident with total sum insured is INR 10,00,000
- Term Life Insurance with sum assured for employees is 5 times fixed base pay is covered
- Securonix, Inc. provides equal employment opportunities (EEO) to all emplo