Cloud Solutions Architect
Cloud Solutions Architect
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Snowflake Cloud Architect
Austin TX (Hybrid Candidates must be in the Austin area to work onsite 2 times per week)
8 months Contract with possibility to extension
Clients 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 problemsolving skills a resultsdriven mindset and a solid grasp of data governance and security practices in a cloud environment. The ability to collaborate with crossfunctional 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 endtoend Data integration process using ETL for Structured semistructured and Unstructured Data.
- Build robust data pipelines to ingest data into Snowflake especially large datasets like Geometric files GIS datasets HECRAS 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 adhoc 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 semistructured data (JSON XML) columnar PARQUET using the VARIANT attribute in Snowflake.
5
Required
reclustering data in Snowflake with good understanding on MicroPartitions.
5
Required
migration processes to Snowflake from onpremises 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.
Employment Type
Full Time
