Snowflake Lead Developer - Platform Governance & Security Specialist

Choosing 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