Lead Snowflake Developer

Lead Snowflake Developer

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 Mills 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.

Key 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 implementation

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 Skills

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

• 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

Life At Capgemini

Capgemini 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

Disclaimer

Capgemini 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

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem.

Ref. code : 339084

Posted on : Oct 8, 2025

Experience Level : Experienced Professionals

Contract Type : Permanent

Location : Columbia, SC, US

Brand : Capgemini

Professional Community : Data & AI

Capgemini 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.