Snowflake Administrator

Who We AreConnectedX 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 we're 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, TXRole: Snowflake Platform DevOps Engineer Location: Plano, TXDuration: Long-Term ContractWhat You Will DoEnhance 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 complianceWhat You Will BringBachelor's 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.