Snowflake Lead Developer - Platform Governance & Security Specialist

Capgemini; Fort Mill, Northern (SC, KY); Hybrid; USD 103,000 - 129,000; Full time

Benefits offered by this job

Flexible work

Health & retirement benefits

Paid time off & holidays

Paid parental leave

Family building benefits

Job summary

Capgemini is seeking an experienced Snowflake Lead Developer to drive platform governance, security automation, and compliance initiatives from Fort Mill, SC (Day One Onsite - Hybrid). You will establish a Snowflake Center of Excellence, implement masking/classification, tokenization, and automated provisioning across environments.

Responsibilities include RBAC stabilization, audit remediation, API development, and integration with ServiceNow and IIQ teams.

Qualifications

• Snowflake security, governance, and automation experience
• CyberArk PAM, SailPoint IIQ/IdentityNow implementation experience
• ServiceNow development and workflow automation
• Tokenization and masking platform implementation
• AWS Secrets Manager credential management
• Financial Services or regulated environment experience
• Strong project coordination and stakeholder management

Responsibilities

• Establish Snowflake Center of Excellence framework and platform standards
• Remediate audit findings including CyberArk integration
• Implement Dynamic Data Masking and Protegrity tokenization
• Deploy credential protection via Conjur/AWS Secrets Manager
• Automate user provisioning and RBAC processes
• Develop Snowflake APIs for ServiceNow and IIQ integrations
• Collaborate with ServiceNow and IIQ teams to automate workflows
• Automate infrastructure deployment across environments

Skills

Snowflake administration

RBAC design

API development

Python scripting

PowerShell scripting

Education

Snowflake SnowPro Advanced certification (Security/Architecture preferred)

Tools

CyberArk PAM

Protegrity tokenization

AWS Secrets Manager

Conjur Vault

SailPoint IIQ/IdentityNow

ServiceNow

Terraform

CloudFormation

Job description

# Snowflake Lead Developer - Platform Governance & Security SpecialistColumbiaApply for this job* Permanent* Experienced Professionals* Data & AI* ID 574739-en\\_USChoosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.## Job Location - Fort Mill SC (Day One Onsite - Hybrid)## About The Role* Seeking an experienced Snowflake Lead Developer to lead enterprise-wide platform governance, security automation, and compliance initiatives.* This role focuses on establishing Center of Excellence, implementing comprehensive security frameworks, and automating all aspects of Snowflake platform management## Core Responsibilities* Center of Excellence & Security Implementation* Establish Snowflake Center of Excellence framework and platform standards* Remediate audit findings including CyberArk integration for key pair authentication* Implement Dynamic Data Masking policies and Protegrity tokenization enterprise-wide* Deploy Dynamic Data Classification framework and credential protection via Conjur Vault/AWS Secrets Manager* Implement automated service account credential rotation## Automation & Integration* Collaborate with ServiceNow and IIQ teams to automate user provisioning workflows* Develop Snowflake APIs for ServiceNow and IIQ integrations* Automate complete user access provisioning and infrastructure deployment across all environments* Stabilize and document Role-Based Access Control (RBAC) processes* Set up comprehensive resource monitoring and alerting systems## Testing & Validation* Conduct thorough testing of all ETL/ELT processes post-security implementations* Validate data integrity across all security frameworks* Review and update Snowflake use case inventory with accurate ownership and cost alignment## Required Technical Expertise* **Snowflake Platform:** Advanced administration, Dynamic Data Masking/Classification, RBAC design, API development, monitoring configuration* **Security & Identity Management:** CyberArk PAM integration, Protegrity tokenization, AWS Secrets Manager/Conjur Vault, SailPoint IIQ/IdentityNow, automated credential rotation* **Automation & DevOps:** Infrastructure as Code (Terraform/CloudFormation), CI/CD pipelines, ServiceNow workflow development, Python/PowerShell scripting## Required Experience* 8+ years enterprise data platform governance experience* 5+ years hands-on Snowflake development, administration, and security* 3+ years implementing enterprise security and governance frameworks* 2+ years privileged access management and identity governance experience* Proven audit remediation experience in regulated environments* Large-scale automation and integration project leadership## Key Deliverables* Complete audit finding remediation (CyberArk integration)* Establish Center of Excellence framework and standards documentation* Begin RBAC stabilization and Confluence inventory review* Deploy Dynamic Data Masking and classification policies platform-wide* Implement Protegrity tokenization across all environments* Complete ServiceNow and IIQ workflow integrations with secrets management* Achieve complete automation of user and service account provisioning* Implement full infrastructure automation across all environments* Finalize comprehensive testing and monitoring frameworks## Stakeholder Collaboration with Key Partners:* InfoSec Team (security policy implementation),* ServiceNow Team (workflow design),* IIQ Team (identity governance),* Product Owners (requirements gathering),* Application Teams (integration testing)## Required Qualifications* Snowflake SnowPro Advanced certification (Security/Architecture preferred)* 5+ years Snowflake security, governance, and automation experience* **Security Tools:** CyberArk PAM, SailPoint IIQ/IdentityNow implementation experience* **Integration:** ServiceNow development and workflow automation* **Data Protection**: Tokenization and masking platform implementation* **Cloud Security**: AWS Secrets Manager and credential management* **Industry:** Financial Services or regulated environment experience* **Soft Skills:** Strong project coordination and stakeholder management capabilities## Life At CapgeminiCapgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer: * Flexible work* Healthcare including dental, vision, mental health, and well-being programs* Financial well-being programs such as 401(k) and Employee Share Ownership Plan* Paid time off and paid holidays* Paid parental leave* Family building benefits like adoption assistance, surrogacy, and cryopreservation* Social well-being benefits like subsidized back-up child/elder care and tutoring* Mentoring, coaching and learning programs* Employee Resource Groups* Disaster Relief## DisclaimerCapgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law## Salary TransparencyThe primary focus is to help organizations design, develop, and optimize their data infrastructure and systems. They help organizations enhance data processes, and leverage data effeCapgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The disclosed range takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, performance, sales or revenue-based metrics, and business or organizational needs. At Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role. The base salary range for the tagged location is $103330 to $128656 /yearly. This role may be eligible for other compensation including variable compensation, bonus, or commission. Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees. Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.ctively to drive business outcomes.The base compensation range for this role in the posted location is:$103330 to $128656Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law.The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction.These may include, but are not limited to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity.It is not typical for candidates to be hired at or near the top of the posted compensation range.In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws.**Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees.** In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include: * Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave* Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)* Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)* Life and disability insurance* Employee assistance programs* Other benefits as provided by local policy and eligibility**Important Notice:** Compensation (including bonuses, commissions, or other forms of incentive pay) is not considered earned, vested, or payable until it becomes due under the terms of applicable plans or agreements and is subject to Capgemini’s discretion, consistent with applicable laws. The Company reserves the right to amend or withdraw compensation programs at any time, within the limits of applicable legislation.**Disclaimers**Capgemini is an Equal Opportunity Employer encouraging inclusion in the workplace. Capgemini also participates in the Partnership Accreditation in Indigenous Relations (PAIR) program which supports meaningful engagement with Indigenous communities across Canada by promoting fairness, accessibility, inclusion and respect. We value the rich cultural heritage and contributions of Indigenous Peoples and actively work to create a welcoming and respectful environment. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodation does not pose an undue hardship. Capgemini is committed to providing reasonable accommodation during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.