Snowflake Admin Architect need in Texas

Who we are:

ConnectedX is focused on Digital Transformation and Product Engineering Services, enabling clients achieve their business, operating and technology needs for the digital age. Our unique industry-based, consultative approach helps clients implement digital transformation initiatives. Headquartered in Dallas, Texas, U.S. ConnectedX is a preferred partner for leading Fortune 1000 enterprises and is consistently admired by the clients and employees across the globe.

What we are looking for:

Role: Snowflake Admin

Location: Plano, TX (Hybrid)

Job Description:

Roles and Responsibilities:

• Enhance and modify existing Python-based ELT processes within the Snowflake environment.
• Develop Python scripts to automate Snowflake administration tasks.
• Leverage AWS infrastructure, including S3, EC2, EKS, and implement Unix shell scripting and Python scripting for automation.
• Administer Snowflake in sub-prod, production, and global environments, including creating databases, schemas, tables, views, external stages, and storage integrations.
• Troubleshoot data issues, debug Python code, and optimize SQL queries and business logic.
• Manage Snowflake features such as Streams, Tasks, Cloning, Time Travel, multi-cluster warehouses, and ensure scalability for diverse workloads.
• Implement security best practices for role-based access, user privileges, and integrate with external tools as required.
• Proactively design and implement process improvements, such as automation of manual tasks, optimizing data flows, and ensuring cost-effectiveness and scalability.
• Utilize optimization techniques like materialized views, clustering, micro-partitioning, and caching to enhance query performance.
• Administer Snowflake SSO/Okta integration, AD Group setups, access control, encryption, and security policies (Network, Row Access, Masking).
• Support integration of Tableau, SAS, Python, and JDBC connections with Snowflake.
• Manage CI/CD pipelines within Snowflake, oversee schema changes, and ensure smooth deployment processes.