Ztek Consulting INC
Location
Illinois | United States
Job description
Job Title: Snowflake SnowPro Advanced
Location: FORT MILL, IL
Position Type: Contract
Duration: 6 Month
Work Type: Onsite
Rate: Pay range offered to a successful candidate will be based on several factors, including the candidate's education, work experience, work location, specific job duties, certifications, etc.
JOB DESCRIPTION:
Duties & Responsibilities:
Design, implement, and maintain Snowflake cloud data warehouse solutions that meet internal project requirements
Monitor Snowflake performance and tune for optimal storage & processing utilization
Provides technical and consultative support to partnering teams
Administer and maintain Snowflake users and role permissions
Develop solutions to remediate Security and Regulatory requirements
Identify automation opportunities for internal processes and procedures
Provide operational support for system access and availability
Author and maintain internal documentation
Stay up-to-date on the latest Snowflake features and best practices
Basic Qualifications:
2+ years of experience with Snowflake
2+ years of experience in database administration
Bachelor's degree:
Preferred Qualifications:
Experience with Snowflake cloud data platform, including the creation of create tables, views and tasks. new databases, new schema and data sharing
Experience troubleshooting authentication and access related issues
Experience with SQL Programing, PL/SQL, Python, and Stored Procedures
Experience implementing user and role privileges using RBAC model
Strong understanding of Snowflake architecture, administration, and performance optimization
Understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies
Knowledge of Snowflake security features including access control, authentication, authorization, encryption, masking, secured views etc.
Knowledge of Data Warehouses, sizing, ETL architecture and best practices
Strong troubleshooting and problem-solving skills
Strong data analytical skills
Ability to work in a fast-paced environment, handle multiple priorities and effectively prioritize them
Experience working in a consumer-centric company, partnering with teams of technical professionals in a cross-functional environment
Strong interpersonal and written communication skills
Experience with federated authentication SSO, SAML, oAuth, MFA
Experience with ETL/transformational data tools
Experience with ServiceNow
Required certification : Snowflake SnowPro Advanced Administrator
Experience in Financial Services or another regulated industry
Bachelor's degree in Computer Science, Engineering or a related field
ABOUT Ztek:
Website:
Ztek Consulting Inc is a minority- and woman-owned business enterprise that leverages a unique blend of human talent, machine learning algorithms, and artificial intelligence to provide customized talent management solutions for clients. Ztek's diversity-focused hiring models have proven successful, particularly in hiring veterans. The company's veteran-focused hiring and deployment program, Z-V.E.T, matches skilled veterans with clients' needs in various areas.
Disclaimer:
Ztek is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. Ztek is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation, or any other status protected by the statutes, rules, and regulations in the locations where it operates. If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at [email protected] Please indicate the specifics of the assistance needed. Ztek encourages all interested and qualified candidates to apply for employment opportunities. Ztek does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. 1324b.
Job tags
Salary