Software Engineer 3 - Snowflake Job at Hill Country Project Management LLC, Austin, TX

b0hrdldNc2Z3SytOYVNlS0FOSTV2cEZoaVE9PQ==
  • Hill Country Project Management LLC
  • Austin, TX

Job Description

Job Description

Job Description

Current Texas Residents Only | | Closes 12/27/24

I. DESCRIPTION OF SERVICES

Texas Health and Human Services Commission requires the services of 1 Software Engineer 3 , hereafter referred to as Candidate(s), who meets the general qualifications of Software Engineer 3, Applications/Software Development and the specifications outlined in this document for the Texas Health and Human Services Commission .

The Department of Information Resources (DIR) requires the services of One Developer hereafter referred to as Worker, who meets the general qualification of Developer 3 Emerging and the specifications outlined in this document for Health & Human Services Commission - Social Services Applications team.
  • Design overall data structure, ensuring that Snowflake's features (e.g., data sharing, scalability, secure data exchange, etc.) are fully utilized to meet the business requirements.
  • Create a blueprint for how data will be stored, processed, and accessed within the Snowflake platform.
  • Perform optimization of data pipelines and workflows for performance, scalability, and cost-efficiency.
  • Design ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform) processes, and optimize queries and data storage strategies.
  • Integrate with other cloud services (e.g., AWS, Azure, GCP), third-party tools, and on-premises data systems.
  • Designs and implements strategies to control access to sensitive data, applying encryption, role-based access control, and data masking as necessary.
  • Work closely with data engineers, data scientists, business analysts, and other stakeholders to understand their requirements and ensure the Snowflake environment meets those needs.
  • Monitor the performance of the Snowflake environment, identifying bottlenecks, and ensuring optimal query performance.
  • Automate administrative tasks using Snowflake SQL and scripting languages like Python or Shell scripting.
  • Preform data loading methods (bulk loading using COPY INTO, Snowpipe for real-time ingestion, and External tables).
  • Perform Snowflake cloning capabilities for databases and schemas.
  • Perform configuration and management of Snowflake Virtual Warehouses including scaling, resizing and auto-suspend/resume settings.
  • Implement roles and privileges for managing secure access utilizing Snowflake RBAC (Role-Based Access Control)
  • Integrate Snowflake SSO (Single Sign-On) and SCIM (System for Cross-domain Identity Management) for secure access and identity management.
  • Configure alerts and monitor data pipeline failures, resource spikes, and cost thresholds.


II. CANDIDATE SKILLS AND QUALIFICATIONS

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. YearsRequired/ PreferredExperience8RequiredExperience with data modeling, data integration, data warehousing, data governance, and data security8RequiredExperience with Oracle and/or PostgreSQL in HA deployments and Expertise in data storage8RequiredProficiency in Snowflake architecture and its components.8

Job Tags

Remote job,

Similar Jobs

Gartner

Managing Partner, IT Strategy Consulting, State and Local Government (Sacramento) Job at Gartner

 ...industry-leading IT Research. From CIOs, to leaders in business and government, we help Gartner clients across enterprises translate insights...  ...to drive the mission-critical priorities of public sector - state and local government clientsExperience working with state and... 

Peraton Corporation

External Background Investigator (FT Employee) - Panama City, FL Job at Peraton Corporation

 ...Peraton is seeking to fill a critical role for a full-time background investigator near Panama City, FL. Applicants must reside within 20 miles of the city center of Panama. What you'll do:The Investigator will be responsible for the following but no Investigator, External... 

All Seniors

Health Coach (In-Home) Job at All Seniors

Health Coach (In-Home) - Guiding Seniors Toward Wellness & Healthy Living Company: All Seniors FoundationLocation: Los Angeles, CAAbout...  ...with "Health Coach Application" to ****@*****.*** or apply online.All Seniors Foundation is an equal-opportunity employer,... 

Roger West

Senior Digital Media Planner Job at Roger West

 ...Were looking for a strategic, data-driven, and collaborative Digital Media Planner to drive campaign performance, mentor our team of...  ...to meet you. Who We Are Roger West is a full-service marketing and advertising agency based in Tampa, FL. Our team of digital... 

MDstaffers

Telemedicine Clinical Psychologist *REMOTE* (Arizona) Job at MDstaffers

(Only QUALIFIED Healthcare Professionals accepted) Psychologist/Psychometrist - MDstaffers is seeking a qualified Clinical Psychologist in Arizona. For more information, please apply or call (866) 90-STAFF. Job Description Clinical Psychologist needed to provide...