Remote Snowflake Administrator

at Reyes Holdings in Rosemont, Illinois, United States

Job Description

Responsibilities

Pay Transparency Statement:?

The compensation philosophy reflects the Company’s reasonable expectation at the time of posting. We consider a number of factors when making individual compensation decisions including, but not limited to, skill sets, experience and training, and other business needs. ?This role may also be eligible to participate in a discretionary incentive program, subject to the rule governing the program.

Position Summary:

The Snowflake Administrator will be responsible for all databases used for our Business Intelligence and Analytics environments in a 24×7 environment. This position will primarily be focused on Snowflake and will be expected to become a Snowflake expert quickly. The ideal candidate’s expertise will contribute to the organization’s data-driven initiatives and help drive business success through effective data management and analytics.

Position Responsibilities may include, but not limited to:

+ Responsible for design, implementation, and administration of Snowflake based analytics and data warehouse environment

+ Develop, maintain, and oversee Snowflake deployment and usage best practices to ensure high performing solutions are both cost effective and secure

+ Educate development teams and power users on both the capabilities and limitations of Snowflake

+ Work with 3rd party staffing and support providers as required

+ Own all aspects related to maintaining a high level of uptime for all production databases.

+ Develop and implement proactive monitoring

+ Responsible for maintaining environment diagrams, development standards, and team documents and checklists

+ Responsible for defining processes to support administering accounts

+ Assist operations and developers with troubleshooting as needed

+ Liaison with Security and IT Architecture Teams as required

+ Assist with risk and issue identification and resolution

+ Develop and maintain security, disaster recovery and business continuity documentation, playbook, and checklists

+ Implement security, roles, users and privileges using the best practices

+ Proactively identify, design, and implement improvements like automating manual processes

+ Keep up to date with latest features and best practices in Snowflake administration

+ Provide off-hour support and on-call support as needed

+ Other projects or duties as assigned

Qualifications

Required Skills and Experience:

+ Bachelor’s Degree in Computer Science, Information Systems, or in a related discipline.

+ 3+ years of hands-on working experience in BI / Data Warehouse / Analytics environments and understanding of methodologies

+ 2+ years of hands-on experience as a Snowflake Administrator

+ Ability to quickly learn new technologies

+ Ability to identify and drive continuous improvements

+ Experience with disaster recovery planning and execution

+ Strong communication skills (written and oral)

+ Strong customer service skills and the ability to interact well with business users

+ Strong problem solving and analytical skills

+ Strong SQL skills

+ Knowledge of Snowflake security features including access control, authentication, authorization, encryption, masking, secure view, etc.

+ This position must pass a post-offer background and drug test

Preferred Skills and Experience:

+ Experience coordinating work with 3rd party vendors and consultants

+ Strong in JavaScript to enable creation of Snowflake stored procedures

+ Experience in scripting languages such as PowerShell and Python

+ Experience working in Azure and/or other cloud environments

+ Experience integrating Snowflake with an identity and access management program such as OKTA is a plus

+ Experience working with Power BI and other BI, data visualization, and reporting tools

+ Experience with other relational database management systems, cloud data warehouses and big data platforms is a plus

+ Experience with data integration solutions and tools, data pipelines, and modern ways of automating data using cloud based and on-premise technologies

+ Experience with ServiceNow

Physical Demands and Work Environment:

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Due to the nature of our business in regard to such things as delivery schedules, order inputs, selection, and Department of Transportation Hours of Service, overtime, attendance and punctuality are essential job functions. Should an individual in this classification not be able to adhere to this requirement due to a disability, they should contact their Human Resources department to see what, if any, reasonable accommodation may be made.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation and gender identity, national origin, disability, or protected veteran status. Drug Free Workplace.