• Increase Text Icon
  • Decrease Text Icon
  • Email Icon
  • Print this page
You are here: Home . jobs . postings . joB17238

Texas Department of Insurance

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.

Important notice: Read before you apply

Veterans’ Preference:

To receive veterans’ preference, applicants must provide at least one 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 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

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.

 EMPLOYMENT WILL BEGIN ON OR AFTER SEPTEMBER 1, 2017

 

Position Details

Opening Date:08/21/2017
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:17-238
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: 08/21/2017

Contact Information and Other Helpful Links