| Quick fill Cloud Solutions Architect -- Austin, TX (Hybrid, Candidates must be in the Austin area) Need State client experience at Austin, Texas, USA |
| Email: [email protected] |
| Role : Cloud Solutions Architect Location : Austin, TX (Hybrid, Candidates must be in the Austin area to work on-site 2 times per week) 8 months Contract with possibility to extension IT/Data Services team is seeking a Snowflake Cloud Architect with a minimum of 5 years of experience in Snowflake architecture, database design, data sharing, cost optimization and API integration. This position requires an expert who is proficient in Snowflakes capabilities and best practices with a deep understanding of performance optimization, data modeling, and cloud data architecture principles. This role requires a highly skilled individual who can work independently under limited supervision while applying creativity and initiative to solve complex problems. The role requires strong problem-solving skills, a results-driven mindset, and a solid grasp of data governance and security practices in a cloud environment. The ability to collaborate with cross-functional teams and provide technical leadership is essential. This position will report to the Data Management Officer. Assess the current infrastructure and database designs in Snowflake and come up with an optimized approach for long term sustainability of the environment. Responsible to develop, optimize, and oversee the companys logical, conceptual, and physical data model and provide recommendations. Lead user requirements elicitation for end-to-end Data integration process using ETL for Structured, semi-structured and Unstructured Data. Build robust data pipelines to ingest data into Snowflake, especially large datasets like Geometric files, GIS datasets, HEC-RAS models Develop Near real time data loads from various sources to Snowflake databases. Proficient in Python, Python libraries to assist business developing machine learning and other scientific models using Snowflake, Streamlit and Snowpark. Develop cost optimization techniques to keep costs in control and develop future estimates as per the projected workloads and storage needs. Contribute toward developing a comprehensive data cloud strategy for the agency, hybrid cloud infrastructure using Snowflake, AWS S3 and AWS RDS, AWS Kinesis etc., Develop data sharing functionalities using Snowflake APIs or other API techniques or tools to move data in and out with external entities and public in a secure way. Build artifacts to efficiently manage data science model life cycle, to include development, testing, training, and deploying models in an efficient way and extended ad-hoc support. Develop training modules and provide training support for the staff as needed. Candidate Skills And Qualifications: Years Required/Preferred Experience 5 | Required | Snowflake architecture, database design, data sharing, cost optimization and API (Required) | 5 | Required | Snowflake concepts like setting up Resource monitors, RBAC controls, scalable virtual warehouse, SQL performance tuning, zero copy clone, time travel and automating them. | 5 | Required | handling semi-structured data (JSON, XML), columnar PARQUET using the VARIANT attribute in Snowflake. | 5 | Required | re-clustering data in Snowflake with good understanding on Micro-Partitions. | 5 | Required | migration processes to Snowflake from on-premises database environment. | 5 | Required | designing and building auto ingestion data pipeline with near real time data. | 5 | Required | working in Cloud technologies such as AWS S3, SQS, EC2, Lambda, Redshift, RDS | 5 | Required | designing and developing automated monitoring processes on Snowflake using combination of Python, PySpark, Bash with Snow SQL. | 5 | Required | SnowSQL developing stored procedures and writing queries to analyze and transform data. | Thanks & Regards Riyaz Khan Pathan Sr Technical Recruiter 1601 N Harrison Ave, STE # 2B, Pierre, SD 57501 E Mail: [email protected] | LinkedIn: https://www.linkedin.com/in/riyazkhanpathan/ W: www.my3tech.com -- Keywords: sthree active directory information technology South Dakota Texas Quick fill Cloud Solutions Architect -- Austin, TX (Hybrid, Candidates must be in the Austin area) Need State client experience [email protected] |
| [email protected] View all |
| Tue Jan 07 02:15:00 UTC 2025 |