Lead Snowflake Developer
Capgemini•Columbia, SC
•Hybrid
About The Position
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.
Requirements
- 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
- 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
- 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
Responsibilities
- 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
- 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
- Conduct thorough testing of all ETL/ELT processes post-security implementation
- Validate data integrity across all security frameworks
- Review and update Snowflake use case inventory with accurate ownership and cost alignment
Benefits
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
