The position performs advanced (senior-level) computer systems analysis work. Work involves writing and reviewing complex SQL, review of Unix/Linux shell programming (basic knowledge) and coordinating file transfers (sftp). Interfacing with various teams, including Database Administrator (DBA) and systems teams to resolve complex issues with run performance. Works with program and policy customers to refine requirements and convert to technical specifications for the Data Analytics team. Training, motivating and guiding team on day-to-day issues. Tracking team deliverables and reporting to management. Resolving barriers for the team members and performing analysis on outgoing reports. Responsible for coordinating leave requests and ensuring coverage of duties when team members are unavailable. Works as subject matter expert regarding TIERS reporting as well as Unix/Linux batch processing and ftp services. Additionally, planning and analysis of system requirements, procedures, and problems to automate processing or to improve existing systems, designing and implementing designs using software programming languages. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment.

Essential Job Functions:
SQL ad-hoc report developer reporting on TIERS data to policy and program areas (25%).

Technical advisor to team, resolving questions on TIERS and YTB table references (25%).

Serves as liaison between business, DBA and systems teams as well as any other HHSC IT Social Services Applications staff to provide data relevant to reports, audits, legislative projects, policy implementation, and other decision-making needs of the agency (25%).

Oversees the assignment of tasks and monitors to ensure timely and accurate completion, based on team members’ skillset and workload bandwidth; notifies management of significant issues and provides feedback to managers on performance and suggested development (15%).

Oversees and directs the development of documents and reports produced by team members, to ensure professional quality and appearance, appropriate content, consistency, and responsiveness. (10%).

Knowledge Skills Abilities:
Knowledge of

Oracle databases and SQL

Unix/Linux environment and shell programming (basic).

Health and Human Services Social Services Applications eligibility systems and reports (TIERS, TLM, EWMS, YTB).

State and federal laws and regulations and internal policies and procedures related to HHS programs.

Project management principles and practices.

Agile principles and practices.

Skill in

analyzing and evaluating complex IT programs, policies and issues

communicating effectively both orally and in writing

coordinating and communicating with a wide range of staff, programs, departments, officials, agencies and

the public



Ability to

analyze and interpret technical information including regulations, policy, and automation system documentation/specifications

organize projects with highly complex functions

understand with a degree of expertise business needs, impacts to system(s) due to requirements changes or enhancements, technical specifications documents and related artifacts

Registration or Licensure Requirements:
None

Initial Selection Criteria:
Required graduation from an accredited four-year college or university with a bachelor’s degree in computer science or related field of study and 7 years of related professional experience. Additional related work experience may substitute for the required education on a year for year basis with a maximum substitution of four (4) years.
Required 3 years of extensive knowledge of HHS automated eligibility system (TIERS).
Required experience working with state and federal laws and regulations and HHS programs policies and
procedures.
Preferred experience working professionally with a broad range of stakeholders.

Additional Information:
Applicants must be willing to work a regular Monday through Friday 8am - 5pm (CST) schedule. Applicants
must also be willing to work after hours (evenings, Saturdays, Sundays, or holidays), on occasion to complete
necessary activities including system validation and critical communications.

Applicants who fail to follow the written instructions in completing the State of Texas Employment Application
will be disqualified.

MOS Code:
35F, IT, 23, 02111, 8E000

Top 10 Tips for Success when Applying to Jobs at HHSC and DSHS

HHS agencies use E-Verify. You must bring your I-9 documentation with you on your first day of work.

In compliance with the Americans with Disabilities Act (ADA), HHS 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.