Skip to Top Main Navigation Skip to Left Navigation Skip to Content Area Skip to Footer
Topics:   A B C D E F G H I J K L M N O P Q R S T U V W X Y Z All

Texas Department of Insurance

The Texas Department of Insurance (TDI) is a state agency responsible for both consumers and the insurance industry. We work to fulfill our legislative mandate to regulate the insurance industry, administer the Texas workers’ compensation system, and promote a healthy insurance marketplace, while also protecting the people and the businesses that are served by insurance. We take our responsibility to Texans seriously and strive for excellent customer service through our professional attitude, competence and efficiency.

Important notice: Read before you apply

Veterans’ preference:

To receive veterans’ preference, applicants must provide at least one of the following documents with their State of Texas Application:

  • a copy of the DD 214, member #4;
  • a statement of compensation from the Veterans Benefits Administration; or
  • a copy of the DD 1300.

Applicable Military Occupational Specialty (MOS) codes are included, but not limited to one of the following: 25B, 255S, 181X, 275, 26, 0171, 8848, 3D0X2.

Additional Military Crosswalk information can be accessed at:

http://www.hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_InformationTechnology.pdf

 

Veterans: Go to www.texasskillstowork.com for assistance with translating your military work experience and training courses into civilian job terms, qualifications/requirements and skill sets.

 

Current opportunity: SAS Programmer

Internal/External Posting – TDI Employees and General Public

The SAS Programmer performs complex (journey-level) computer programming work. Work involves assisting in the planning, scheduling, and assigning of programming projects; coordinating programming projects; analyzing proposed computer applications; preparing and developing programs; and providing technical programming assistance.


This position:

  • works with relational databases and/or SQL to develop original statistical reports and troubleshoot or enhance existing reports.
  • works with large datasets of over 1 million records using advanced SAS programming, including PROC SQL, PROC TABULATE, PROC REPORT, the SAS macro language, SAS/IntrNet, and ODS output, especially ODS output to Excel using the ExcelXP tagset;
  • assists with analyzing proposed programming project in terms of requirements, capabilities and time management;
  • provides technical assistance and advice to other programmers;
  • meets with program area users to gather, define and validate business requirements necessary for the development of specifications or programming work;
  • assists with coordinating, designing, and maintaining the integration of data from various systems to the SAS data warehouse through ETL processes;
  • develops and maintains programming standards, database documentation, and business rules while working with programmers, end-users, and other staff to define project requirements; and
  • performs other duties as assigned.

Qualifications

Graduation from an accredited four-year college or university with a four-year degree in Computer Science, Information Systems or in a field relative to assignment. Education and experience relevant to position requirements may be substituted for one another on a year-for-year basis.


Additionally, this position:

  • requires two years of experience working with relational databases; and
  • prefers experience with advanced SAS or SQL programming, and experience working with the Division of Workers’ Compensation data.

This position requires demonstrated knowledge of:

  • principles, practices, and techniques of computer databases, programming, system analysis, and system design;
  • database structures and theories;
  • database management;
  • how to create, implement and maintain data warehouse; and
  • Windows operating system and programming environment.


This position requires demonstrated skill in:

  • complex problem solving, decision making and planning;
  • computer programming, in the operation of computers and applicable software;
  • programming and testing of structured computer programs; and
  • technical writing and development of business requirement.

This position requires the demonstrated ability to:

  • learn new technology quickly;
  • learn the workers’ compensation system;
  • subset datasets by one or more variables;
  • join 2 or more datasets by one or more variables;
  • validate data, identify outliners and debug/troubleshoot programs;
  • identify and articulate trends, outliners, and quality issues;
  • communicate highly technical and complex information to a diverse audience;
  • prioritize work load and consistently meet deadlines;
  • process information logically to design programs and systems logic;
  • apply critical thinking to interpret technical information related to computer programming and other areas of data processing; and
  • establish and maintain effective working relationships with all employees and the general public.

 

Interviewees will be asked to solve a typical programming problem at the time of the interview.
 
 

Position details

Opening date:06/18/2018
Functional title:SAS Programmer
Classification title:Programmer III
Status:Internal/External Posting – TDI Employees and General Public
Application deadline:Until Filled
Pay group:B21
Monthly salary: $5,000.00
Annual salary:$60,000.00
Job posting number:18-286
Division:Division of Workers’ Compensation/Information Management Services
Location:7551 Metro Center Drive, Ste. 100, Austin, TX 78744
Travel required:5 %

 

For more information, contact:

Last updated: 6/18/2018