The Hartford

Snowflake Administrator

Posted on: 10 Mar 2021

Hartford, CT

Job Description

You are a driven and motivated problem solver ready to pursue meaningful work. You strive to make an impact every day & not only at work, but in your personal life and community too. If that sounds like you, then you've landed in the right place.

The Hartford's Data and Analytics Enablement Services team within the Enterprise Data Organization is seeking a talented Snowflake Administrator professional with a proven track record of administration, engineering and operationalizing the Snowflake Cloud Data Platform including integration with associated AWS Services and on-premise infrastructure. Our ideal candidate will leverage deep technical expertise and strong communication skills to deliver services to platform, projects and users.

Responsibilities

* Provide architectural guidance, enablement and operationalization of Snowflake capabilities to accommodate business/technical use cases

* Design, automate and manage provisioning needs, such as Snowflake storage and compute components, Role Based Access Control model and User Access

* Coordinate and collaborate with dependent infrastructure and AWS services to implement Snowflake integration with services, such as PrivateLink, S3, IAM, SSO, Encryption etc.

* Implement backup, replication and recovery policies and procedures

* Tuning for better performance and optimizing compute utilization

* Implement DevOps/CICD framework and solutions for provisioning snowflake components and application code deployments

* Define standards and practices for platform use, provide technical expertise and troubleshooting

* Contribute to adoption of Snowflake as part of the enterprise technology stack

* Provide support for change management, governance compliance, internal audits and remediation. On-call support during critical application rollouts and issues.

* Work with Snowflake vendor in communicating and resolving platform challenges

* Provide technical leadership, mentoring and oversight for evolving Snowflake admins

Qualifications

* Bachelors degree (or foreign equivalent) in Computer Science, Computer Engineering or a related field

* At least 6 or more years of solid, diverse work experience in IT, database management, analytics or an equivalent combination of education and work experience

* At least 3 years of experience providing architectural guidance and technical direction to developers, or platform administrators

* At least 3 years of experience with administration and tuning of RDBMS database platforms, developing database and analytical applications with languages, such as: SQL, Python

* At least 2 years of experience (or equivalent training/certification) preferred in enabling, operationalizing and administration of Snowflake Cloud Data Platform

* At least 1 year of experience (or equivalent training/certification) with AWS Services (S3, IAM, SQS, SNS etc) associated with Snowflake and CICD tools such as GIT, Jenkins, uDeploy, Liquibase

* Ability to learn new technologies quickly, and perform major job responsibilities proficiently within 6-12 months

* Strong analytical ability, problem analysis techniques, and broad knowledge of technology alternatives

* Strong communication skills, and the ability to work effectively with business and IT partners

Equal Opportunity Employer/Females/Minorities/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age

Sr Data Engineer - GE07BE

The Hartford

Hartford, CT

The Hartford Financial Services Group, Inc. provides a range of insurance products. The Company's products include property and casualty insurance, group benefits, and mutual funds. Hartford Financial Services Group operates in the United States.

Similar Jobs