Snowflake Administrator - remote India
Description
RiskSpan is a leading source of analytics, modeling, data, and risk management solutions for the Consumer and Institutional Finance industries. We solve business problems for clients such as banks, mortgage-backed and asset-backed securities issuers, equity and fixed-income portfolio managers, servicers, and regulators that require our expertise in market risk, credit risk, operational risk, and information technology domains. RiskSpan is proud to be an Equal Opportunity/Affirmative Action employer committed to hiring a diverse workforce and sustaining an inclusive culture.
Job Summary:
We are seeking an experienced Snowflake Administrator with a SnowPro Advanced Administrator Certification to join our data engineering team on a contract-to-hire basis. The ideal candidate will be responsible for managing and optimizing our Snowflake data platform, ensuring efficient data management and analytics processes. You will work closely with cross-functional teams to support data integration, migration, and analysis initiatives, contributing to our mission of delivering exceptional data solutions.
Key Responsibilities:
- Administer, monitor, and optimize the Snowflake environment, ensuring high performance, availability, and security.
- Implement best practices for Snowflake architecture, including data modeling, database design, and query optimization.
- Collaborate with data engineers and analysts to design and implement data pipelines and ETL processes using Snowflake.
- Manage Snowflake roles, users, and permissions to ensure data security and compliance with organizational policies.
- Leverage enterprise LDAP accounts to manage access control and permissions within each individual product.
- Develop and maintain documentation for Snowflake configurations, processes, and best practices.
- Troubleshoot and resolve Snowflake-related issues, providing technical support to end-users and stakeholders.
- Conduct performance tuning and optimization of queries, stored procedures, and data models.
- Provide technical solutions for disaster recovery, backup, data sharing, and data replication.
- Stay up-to-date with Snowflake features and capabilities, evaluating and implementing enhancements as needed.
- Collaborate with DevOps teams to integrate Snowflake with CI/CD pipelines and automation tools.
- Assist in capacity planning and cost management for Snowflake resources.
- Work on critical incidents and user service requests and be responsible for SLA adherence, tracking, and reporting.
- Train and mentor team members on Snowflake best practices and usage.
Qualifications:
- SnowPro Advanced Administrator (required).
- 3+ years of experience in Snowflake administration or data engineering.
- Bachelor’s degree in Computer Science, Information Technology, or a related field, or 5 years of experience.
- Strong understanding of data warehousing concepts and best practices.
- Proficiency in SQL and experience with Snowflake's query performance tuning.
- Familiarity with ETL tools and data integration processes.
- Experience with cloud platforms, particularly AWS, Azure, or Google Cloud.
- Knowledge of data governance, data quality, and data security principles.
- Experience with disaster recovery and backup solutions.
- Strong analytical and problem-solving skills with attention to detail.
- Excellent communication skills, with the ability to work collaboratively in a team environment