Job Description
· RBAC Setup & Troubleshooting: Assist with configuring Snowflake RBAC roles, as well as developing and troubleshooting access rights within the Snowflake environment.
· Phased Deployment: Support the phased rollout of Snowflake RBAC to designated LOBs in close partnership with the InfoSec and Snowflake development teams.
· Hypercare Support: Interact directly with stakeholders to resolve access issues during the Hypercare phase and provide elevated technical support.
· Knowledge Transfer: Conduct comprehensive Knowledge Transfer (KT) sessions for the GTC and Onsite InfoSec teams to support ongoing operational initiatives
Pay Rate: $6.00-$9.00 depending on skills and experience.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
4+ years of experience in Snowflake RBAC
Basic SQL
Communication to interact with stakeholders and between US and India teams
Nice to Have Skills & Experience
New position
June
L1: Kamal
L2: is Chandra
Onboarding a new process within the team, taking over some operations from one of the dev team
Syncing between US and India office to make sure this is fully handed over to operations
Configuring and troubleshooting within Snowflake- ensure person maintain RBAC
Can perform KT between existing and new team
Existing SAP Security Team-
SAP Security team will be taking on Snowflake security configurations- this person is going to help lead that
Project based initially, then later will be rolling out into tickets
Hypercare- handing all teething issues
L1 and L2 support pending
Handing an RBAC, help with operational tasks
Snowflake is mostly already established, need someone in security to monitor
Snowflake RBAC
Basic SQL
Support and Maintenance, Senior, Standard- if not we can look at Niche
Here’s a 30-minute recruiter screen script you can use directly — optimized for speed, flow, and easy evaluation.
30-Minute Recruiter Screen – Sr. Snowflake Security Engineer (RBAC Focus)
0–3 min: Intro / Setup
• Quick overview of role:
○ Snowflake security (RBAC) support & troubleshooting
○ Working with InfoSec + SAP Security team
○ Hypercare + operational handoff
• Confirm candidate:
○ Experience with Snowflake security
○ Comfortable with support + KT + global team collaboration
3–20 min: Technical Screening (Core Questions)
1) RBAC Fundamentals (3–4 min)
Question:
“Can you explain how RBAC works in Snowflake?”
Listen for:
• Roles assigned to users (not direct permissions)
• Role hierarchy (roles granted to roles)
• Least privilege approach
• Objects controlled via roles (DB, schema, tables, warehouses)
2) Hands-On Configuration (3–4 min)
Question:
“Walk me through how you’ve set up roles and permissions in Snowflake.”
Listen for:
• Creating roles (CREATE ROLE)
• Granting access:
○ USAGE (DB/schema)
○ SELECT (tables/views)
• Assigning roles to users or other roles
• Real example (strong preference)
3) Troubleshooting Access Issues (3–4 min)
Question:
“If a user cannot access a table, how would you troubleshoot?”
Listen for:
• Check role assigned to user
• Validate:
○ DB access
○ Schema access
○ Table permissions
• Use of:
○ SHOW GRANTS
○ USE ROLE
• Logical step-by-step debugging
4) Layered Access Control (3–4 min)
Question:
“What permissions are required to access a table in Snowflake?”
Listen for:
• Must have:
○ USAGE on database
○ USAGE on schema
○ SELECT on table
• Awareness that missing one layer blocks access
5) SQL for Security Admin (2–3 min)
Question:
“What SQL commands do you use regularly for Snowflake security?”
Listen for:
• CREATE ROLE, GRANT, REVOKE
• SHOW GRANTS, USE ROLE
• CREATE USER / ALTER USER
6) Phased Rollout / KT (2–3 min)
Question:
“Have you supported rolling out security or access changes across teams?”
Listen for:
• Working with stakeholders (InfoSec, devs, ops)
• Structured rollout / validation
• Documentation + knowledge transfer
7) Hypercare Support (2–3 min)
Question:
“Tell me about a time you supported access issues post-go-live.”
Listen for:
• Handling high volume of access issues
• Common problems (missing roles, incorrect grants)
• Communication with users + escalation handling
• Transition to ticket-based support
20–25 min: Role Fit / Environment
Quick checks:
• Experience supporting production environments
• Comfort with:
○ US/India time overlap
○ Working with SAP Security / InfoSec teams
• Experience moving from project → operations
25–30 min: Close
• Confirm:
○ Availability (June 16 start)
○ Contract comfort (4–5 months)
• Candidate questions
Quick Scoring Guide (Use During Call)
Area Strong متوسط Weak
RBAC Knowledge Clear, structured, Snowflake-specific General RBAC only Vague
Hands-on Experience Real examples, SQL usage Some exposure No real experience
Troubleshooting Step-by-step, logical Basic Struggles
SQL Comfortable with grants/roles Limited Minimal
Support/Hypercare Has done it Some exposure None
Hire Signal Snapshot
✅ Move forward if candidate:
• Has hands-on Snowflake RBAC experience
• Can clearly troubleshoot access issues
• Comfortable with SQL-based security admin
• Has supported production / hypercare
❌ Pass if candidate:
• Only theoretical RBAC knowledge
• No Snowflake-specific experience
• Weak troubleshooting approach
• No support or operational exposure
If you want next, I can convert this into a 1-page intake sheet for your CRM or add ideal answers inline for junior recruiters.
From
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.