Python Developer (Snowflake Automation)

Air InfoSec•Austin, TX

2d•Hybrid

About The Position

The Python Developer will support the Texas Health and Human Services Commission on a data automation and exchange initiative. This role is responsible for designing and implementing automated solutions to facilitate data exchange with external partners and data processing within Snowflake. The developer will analyze user requirements, operational procedures, and existing system capabilities to develop or improve automated processing workflows. This is a short-term engagement expected to run from June 2026 through August 2026, with a hybrid on-site presence required at the agency's Austin, Texas location.

Requirements

8 years of experience in business systems analysis, application development, or a related technical discipline.
Candidates must already reside in the Austin, Texas area. Candidates currently located out of state or planning to relocate will not be considered.
Initial interviews will be conducted in person.
The selected candidate may be required to work outside normal business hours, including evenings, weekends, and holidays, as requested and pre-approved by the agency.
All travel, per diem, parking, and living expenses are the responsibility of the candidate.

Nice To Haves

4 years of experience developing solutions in Python.
2 years of experience developing automated solutions involving data exchange with external partners.
2 years of experience developing for Snowflake Database.
2 years of experience building solutions that include Snowpipe.
1 year of experience building User Defined Functions (UDFs) in Snowflake.
Experience building solutions in Snowflake that include a custom user interface.

Responsibilities

Analyze current operational procedures, identify problems, and determine input/output requirements to support automation development.
Design and develop Python-based solutions to automate data exchange with external partners and data processing in Snowflake.
Write detailed descriptions of user needs, program functions, and steps required to develop or modify computer programs.
Review system capabilities, specifications, and scheduling limitations to assess feasibility of requested program changes.
Develop and maintain automated pipelines and workflows within the Snowflake environment.
Build and configure Snowpipe solutions to support continuous or scheduled data ingestion.
Develop User Defined Functions (UDFs) within Snowflake to extend platform functionality.
Conduct studies and cost/benefit analyses of alternative technical solutions to support business decision-making.
Confer with personnel across organizational units to identify operational challenges and gather requirements.
Document solutions, configurations, and processes in support of knowledge transfer and maintainability.