SISTEMA

Job Listing

Cloud Solutions Architect 3443

Austin, TX
Austin, TX
Cloud Solutions Architect - Solicitation# 58025IFB3443
Texas Water Development Board (TWDB)

 

TWDB 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 Snowflake’s 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 company’s 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.

Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
Actual
Years
Experience
Years
Experience
Needed
Required/
Preferred
Skills/Experience
  5 Required years of experience in Snowflake architecture, database design, data sharing, cost optimization and API (Required)
  5 Required years of experience in 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 years of experience in handling semi-structured data (JSON, XML), columnar PARQUET using the VARIANT attribute in Snowflake.
  5 Required years of experience in re-clustering data in Snowflake with good understanding on Micro-Partitions.
  5 Required years of experience in migration processes to Snowflake from on-premises database environment.
  5 Required years of experience in designing and building auto ingestion data pipeline with near real time data.
  5 Required years of experience working in Cloud technologies such as AWS – S3, SQS, EC2, Lambda, Redshift, RDS
  5 Required years of experience designing and developing automated monitoring processes on Snowflake using combination of Python, PySpark, Bash with Snow SQL.
  5 Required years of experience with SnowSQL developing stored procedures and writing queries to analyze and transform data.

 

General Application

* - indicates a required field

File types allowed: .doc, .docx, .pdf, and .txt.Max file size: 5mb

Send us your resume

Work with our amazing team and change your life.
View Our Job Openings
crossmenu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram