Founded in 1976, CGI is among the world's largest independent IT and business consulting services firms. With 94,000 consultants and professionals globally, CGI delivers an end-to-end portfolio of capabilities, from strategic IT and business consulting to systems integration, managed IT and business process services, and intellectual property solutions. CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results. CGI Fiscal 2024 reported revenue is CA$14.68 billion, and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more at cgi.com.
Job Title: Snowflake - Admin
Experience: 7+ years of experience
Category: Software Development
Job location: Hyderabad/Bengaluru/Chennai
Position ID: J1025-0724
Employment Type: Full Time / Permanent
Qualification: Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.
We are seeking an experienced and highly skilled Senior Snowflake Administrator to manage, maintain, and optimize our cloud-native data warehouse environment. The ideal candidate will have 7+ years of hands-on experience specifically focused on administering and architecting solutions within the Snowflake Data Cloud. This role is critical for ensuring the performance, security, availability, and cost-efficiency of our data platform and requires deep technical expertise in both Snowflake features and cloud best practices.
Key Responsibilities:
Platform Management & Operations
. Manage and maintain the overall Snowflake environment, including accounts, users, roles, resource monitors, warehouses, databases, schemas, and objects.
. Monitor and manage Snowflake performance and resource consumption, specifically focusing on Virtual Warehouse sizing, cluster key management, and query optimization to ensure efficient operation and control costs.
. Implement and manage Data Sharing capabilities with internal and external partners securely.
. Oversee regular maintenance, upgrades, and patching processes for Snowflake.
Security & Governance
. Establish and enforce robust Role-Based Access Control (RBAC) security models within Snowflake, aligning with organizational governance policies.
. Manage user authentication, including integration with Single Sign-On (SSO) solutions (e.g., Okta, Azure AD) and Key Pair Authentication.
. Implement and manage data encryption, masking, and tokenization techniques to protect sensitive data (e.g., using Dynamic Data Masking and External Functions).
. Conduct regular security audits and maintain compliance documentation.
Performance & Optimization
. Proactively monitor and troubleshoot complex, long-running, or resource-intensive queries using the Query Profile and Snowsight tools.
. Provide expertise in data modeling (e.g., dbt, dimensional modeling) as it pertains to optimizing Snowflake table structures for performance (e.g., partitioning, clustering).
. Develop and implement strategies for data loading and unloading performance using tools like Snowpipe, the COPY INTO command, and external stages (AWS S3, Azure Blob, GCP Cloud Storage).
Automation & Disaster Recovery
. Develop and maintain automation scripts (using Python, SQL, or CI/CD tools) for administrative tasks such as user provisioning, warehouse resizing, and cost reporting.
. Define, document, and execute comprehensive Disaster Recovery (DR) and Business Continuity Planning (BCP) strategies, leveraging Snowflake features like Failover and Replication.
. Utilize Snowflake features like Time Travel and Fail-safe for data recovery and compliance.
Required Qualifications
. 7+ years of professional experience in Database Administration, with at least 4+ years specifically dedicated to Snowflake Data Warehouse Administration in a production environment.
. Expert-level proficiency in SQL and deep understanding of cloud data warehousing concepts and architecture.
. Proven experience implementing and managing Snowflake RBAC, security features, and cost management strategies.
. Strong hands-on experience with Snowpipe, streams, tasks, and stored procedures for data ingestion and automation.
. Solid experience working with at least one major cloud provider (AWS, Azure, or GCP) for setting up external stages and connectivity.
. Proficiency in scripting languages like Python for automation and administrative tasks using the Snowflake Connector for Python or SnowSQL.
. Excellent troubleshooting, problem-solving, and communication skills.
CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodation for people with disabilities in accordance with provincial legislation. Please let us know if you require reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.
#LI-GB9
Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…
You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.
You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
Come join our team—one of the largest IT and business consulting services firms in the world.