Snowflake Platform Lead / Senior Administrator

Ascentt is building cutting-edge data analytics & AI/ML solutions for global automotive and manufacturing leaders. We turn enterprise data into real-time decisions using advanced machine learning and GenAI. Our team solves hard engineering problems at scale, with real-world industry impact. We’re hiring passionate builders to shape the future of industrial intelligence.

·       Administrating Snowflake sub-prod, prod and the global environments. Create database, schema, tables, views, data share, external stage, storage integration.

·       Document, maintain and implement Snowflake platform design standard, pattern, discipline, naming, sizing, optimization, automation, security, best practices, usage.

·       Real world work experience in using Snowflake Stream, Task, Clone and Time Travel, multi-cluster Warehouses, scaling out, scaling up for different types of workloads.

·       Security roles, privileges, users as per best practice. Integrate other tools as per business need but leverage snowflake role-based security to enforce access restrictions.

·       Proactively identify, design, and implement process improvements like automating manual processes, optimizing data flow, increase scalability and be cost-effective.

·       Well versed with Materialized views, Clustering, micro-partitioning, Caching like optimization techniques to tune the queries and fix the performance issues on priority basis.

·       Experience in setting up the Snowflake account from scratch for an enterprise-wide implementation, the Private Link setups, VPC, Networking, Firewall.

·       Should have written in past the DBA scripts using Python and/or Shell scripts and the SNOW SQL. Execution from Amazon EC2 to automate and/or notify Admin related alerts. Must have used the AWS services like the S3, EC2, EKS.

·       Snowflake SSO/Okta integration and AD Groups setups, Access Control, Encryption, Secured Views. Work experience on Network policy, Row Access Policy, Masking policy.

·       Support to Tableau connection to Snowflake.  SAS, Python and other jdbc connections.

·       Should have done the Data Share, Account Replication, Disaster Recovery exercise.

·       Should know the CI/CD in Snowflake and the Schema change process.

·       Perform POT and POC for new features, capabilities and their evaluations and then adaption.

·       Collaborate with Data Modelers, Data Engineers, Data Architects, Information Security and maintain the standards, consistency, adhere to best practices and be compliant.

·       Partner with Data Science, Data Analysis teams, address snowflake platform issues, concerns if there is any. Provide Snowflake solution to the business problem as applicable.

·       Bachelor’s degree in a relevant field.

·       10+ years of IT experience, including 5+ years in DevOps or Database Administration roles.

·       3+ years of hands-on experience with Snowflake administration, Python ELT, SQL, Unix, Shell scripting and AWS services like EC2 and S3.

·       Preferred certifications in Snowflake, Python, or AWS.

·       Previous experience in the financial industry is a plus.

·       Strong communication and collaboration skills with attention to detail.

·       Proven ability to design effective solutions, maintain consistency, and drive disciplined execution.