Snowflake Administrator

Plano, TX - USA

Monthly Salary: Not Disclosed

Posted on: 4 hours ago

Vacancies: 1 Vacancy

Job Summary

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.

Who were looking for:

We are looking for a passionate and highly motivated Sr. Developer for a Fortune 100 client. This is a long-term role in Plano TX

Role: Snowflake Admin Architect

Location: Plano TX

Duration: Long-Term Contract

What you will do:

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.

Collaborate with Data Modelers Engineers Architects and Information Security teams to ensure consistency adherence to best practices and regulatory compliance

What you will bring:

Bachelors degree in a relevant field.

10 years of IT experience including 5 years in DevOps or Database Administration roles.

3 years of hands-on experience with Snowflake administration Python ELT SQL Unix Shell scripting and AWS services like EC2 and S3.

Preferred certifications in Snowflake Python or AWS.

Previous experience in the financial industry is a plus.

Strong communication and collaboration skills with attention to detail.

Proven ability to design effective solutions maintain consistency and drive disciplined execution.

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