Snowflake Lead Developer - Platform Governance & Security Specialist

# Snowflake Lead Developer - Platform Governance & Security Specialist Columbia Apply  for this job
* Permanent* Experienced Professionals
* Data & AI
* -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 Cyber Ark 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 Service Now and IIQ teams to automate user provisioning workflows
* Develop Snowflake APIs for Service Now 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:
** Cyber Ark PAM integration, Protegrity tokenization, AWS Secrets Manager/Conjur Vault, SailPoint IIQ/Identity Now, automated credential rotation
* ** Automation & Dev Ops:
** Infrastructure as Code (Terraform/Cloud Formation), CI/CD pipelines, Service Now workflow development, Python/Power Shell 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 (Cyber Ark 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 Service Now 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:
* Info Sec Team (security policy implementation),
* Service Now Team (workflow design),
*…