Snowflake Admin

Position Description:

Founded in 1976 CGI is among the worlds largest independent IT and business consulting services firms. With 94000 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.68billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more .

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: Bachelors or Masters 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 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

Skills:

• English
• MySQL
• Python
• Snowflake
• SQLite

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll 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. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll 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.

Youll shape your career by joining a company built to grow and last. Youll 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 teamone of the largest IT and business consulting services firms in the world.