CFO Data Architect I

Join the Texas Health and Human Services Commission (HHSC) and be part of a team committed to creating a positive impact in the lives of fellow Texans. At HHSC, your contributions matter, and we support you at each stage of your life and work journey. Our comprehensive benefits package includes 100% paid employee health insurance for full-time eligible employees, a defined benefit pension plan, generous time off benefits, numerous opportunities for career advancement and more. Explore more details on the Benefits of Working at HHS webpage.

Functional Title: CFO Data Architect I 
Job Title: Data Architect I 
Agency: Health & Human Services Comm 
Department: HHS Provider Finance M/C Admin 
Posting Number: 10339 
Closing Date: 04/17/2026 
Posting Audience: Internal and External 
Occupational Category: Computer and Mathematical 
Salary Group: TEXAS-B-28 
Salary Range: $7,716.66 - $13,051.00 
Pay Frequency: Monthly
Shift: Day 
Additional Shift:  
Telework: Eligible for Telework 
Travel: Up to 10% 
Regular/Temporary: Regular 
Full Time/Part Time: Full time 
FLSA Exempt/Non-Exempt: Exempt 
Facility Location:  
Job Location City: AUSTIN 
Job Location Address: 4601 W GUADALUPE ST 
Other Locations:  
MOS Codes: N/A 
 
 
 

Brief Job Description:

The Health and Human Services Commission (HHSC) Chief Financial Officer Division's Data Architect I performs highly advanced data migration (ETL) activities including detailed data mapping, data profiling and cleansing, authoring migration program specifications, and designing complex reconciliation reports. Focuses on designing and leading the migration of data from legacy systems to new platforms, ensuring data accuracy, accessibility, and security throughout the process. This involves creating migration strategies, developing data models, and collaborating with various teams to minimize disruption and ensure a smooth transition. Provides recommendation, guidance and leadership in business architecture and systems processing and leads creation of business architecture models and initiatives using project management best practices and industry architecture frameworks. Provides analyses and consultation to agency leadership on key technology issues affecting the agency and research emerging trends and ideas. Develops a comprehensive data center migration plan, outlining the step-by-step process, timeline, and resource requirements.

Essential Job Functions (EJFs):

(35%) Snowflake Support Duties: Data Load and ETL Monitoring, including monitoring scheduled data loads and ETL jobs, troubleshooting failed or slow data loads, and coordinating with ETL developers for issue resolution; Performance Monitoring and Optimization, including monitoring warehouse performance and query execution, identifying and resolving bottlenecks (e.g., long-running queries), and recommending and implementing warehouse scaling or clustering; Maintenance and Housekeeping, including managing storage usage and retention policies, archiving or purging old/unnecessary data, and applying best practices for cost control; Incident and Problem Management, including responding to incidents, alerts, and service requests, documenting and escalating issues as needed, and maintaining knowledge base articles for common issues; and Data Analysis & Ad hoc Data Requests, including working on Data Analysis requests, providing data extracts on demand based on the program team and automating common Data Requests.

(35%) SAS and IICS (Informatica Intelligent Cloud Services) Support Duties: Job and Workflow Monitoring

1. 1. Monitor daily/weekly/monthly ETL job runs.
   2. Investigate and resolve job failures or performance issues.
   3. Restart failed jobs and communicate status to stakeholders.
2. Connection and Integration Management
   1. Set up and maintain connections to source/target systems (databases, cloud apps, etc.).
   2. Troubleshoot connectivity issues.
3. Change and Release Management
   1. Deploy new or updated mappings, workflows, and tasks.
   2. Validate and test changes in lower environments before promoting to production.
4. Incident and Service Request Handling
   1. Respond to tickets and service requests.
   2. Provide root cause analysis for recurring issues.
   3. Document solutions and update runbooks.

Common Support Activities Across Both Platforms

• Documentation: Maintain up-to-date documentation for processes, runbooks, and troubleshooting guides.
• Reporting: Provide regular status reports on incidents, job status, and platform health.

(20%) Coordinates with internal CFO division data users regarding data needs and system performance, communicates changes to CFO division users, and serves as liaison to the Information Technology division and other HHSC business areas regarding data needs and system performance.

(10%) Drafts and submits reports, responds to inquires, and participates in briefings, meetings, presentations, and other activities to ensure CFO division leadership are aware of data needs and system performance; develops and recommends solutions to data related problems and concerns; and advises on training needs for CFO division staff to optimize user experience and expertise related to data.

Knowledge, Skills and Abilities (KSAs):

• Knowledge of Information Technology theories and practical application approaches
• Knowledge of data center infrastructure and migration processes.
• Knowledge of on-premises data storage systems, virtualization, and networking technologies.
• Knowledge of data center architectures, data replication, and disaster recovery strategies.
• Knowledge of data architecture, data modeling, and data warehousing.
• Knowledge of business intelligence and big data solutions.
• Knowledge of how to lead and manage advanced analytics projects.
• Ability to develop, deploy, and manage applications and data storage.
• Strong knowledge of data architecture principles and best practices.
• Knowledge of advanced analytics tools and strategies.
• Ability to lead teams and manage complex projects.
• Ability to develop and maintain enterprise data models, data warehouses, and data lakes to support analytics and reporting.
• Ability to design and implement solutions using SAS software, manage data, and integrate SAS with other systems. 
• Ability to problem-solving and analytical skills, with the ability to develop effective migration plans and solutions.
• Ability to communicate effectively using interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
• Ability to work independently and efficiently manage time and tasks to meet project deadlines.
• Ability to evaluate and integrate emerging technologies such as AI, machine learning, and big data analytics.
• Skilled at working closely with data engineers, developers, and analysts to ensure seamless data accessibility and usability.
• Skilled in working with ETL tools, data integration platforms, and APIs.
• Skilled at architecting and designing ETL pipelines using Informatica tools.
• Skilled in SQL and other database technologies.
• Skilled in communication, with the ability to explain complex technical concepts to a non-technical audience.
• Skills in SAS programming, data management, and system architecture
• Skills in communication, including technical and non-technical audiences
• Skills in leadership and organizational management 

Registrations, Licensure Requirements or Certifications:

Preferred certifications: Snowflake - Snow-pro; ITIL; or Informatica

Initial Screening Criteria:

1. Required: Bachelor's degree from a 4-year university in Information Technology, Computer Science, or a related field or equivalent work experience (experience may be substituted for education on a year to year basis); At least 3 years of experience in developing, deploying, and managing applications and data storage; At least 2 years of experience developing and maintaining enterprise data models, data warehouses, and data lakes to support analytics and reporting; and at least 2 years of experience working closely with data engineers, developers, and analysts to ensure seamless data accessibility and usability. Work experience may be concurrent.

2. Preferred: 5 years of experience as a Data Center Migration Consultant or in a similar role, with expertise in data center infrastructure and migration processes; Experience in data architecture, data modeling, and data warehousing; Experience evaluating and integrating emerging technologies such as AI, machine learning, and big data analytics; Experience in data center architectures, data replication, and disaster recovery strategies; Experience using analytical skills to develop effective migration plans and solutions; 4 or more years of experience handling Data Analytics projects with on the job experience in Snowflake and Informatica;  

Review our Tips for Success when applying for jobs at DFPS, DSHS and HHSC.

Active Duty, Military, Reservists, Guardsmen, and Veterans:

Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited to those listed in this posting. All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information please see the Texas State Auditor’s Job Descriptions, Military Crosswalk and Military Crosswalk Guide at Texas State Auditor's Office - Job Descriptions.

ADA Accommodations:

In compliance with the Americans with Disabilities Act (ADA), HHSC and DSHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.

Pre-Employment Checks and Work Eligibility:

Depending on the program area and position requirements, applicants selected for hire may be required to pass background and other due diligence checks.

HHSC uses E-Verify. You must bring your I-9 documentation with you on your first day of work. Download the I-9 Form

Telework Disclaimer:

This position may be eligible for telework.  Please note, all HHS positions are subject to state and agency telework policies in addition to the discretion of the direct supervisor and business needs.