Please paste the following URL into a browser to view the entire job posting in the CAPPS Career Section: https://capps.taleo.net/careersection/ex/jobdetail.ftl?job=00042062 You may apply to the job directly through the CAPPS Career Section. It is not necessary to apply both through Work In Texas and CAPPS Career Section

Do you have a passion for public service and enjoy making a difference? Dont miss out on this opportunity. The Texas Department of Insurance (TDI) is hiring! Apply now if youre looking for a rewarding career in public service. We regulate the insurance industry, administer the Texas workers compensation system, and educate and protect consumers. Youll love the benefits of working at TDI: Flexible work schedules. Hybrid work schedule, if applicable. Work-life-balance. 96 hours of accrued vacation a year. 96 hours of accrued sick leave a year. 20+ holidays every year. Career advancement opportunities. Free parking. Free comprehensive medical insurance for full-time employees and 50% off premium costs for dependents (state pays the other 50%). Before you apply: Learn about our selection process, our military employment preference, and licensing and credential requirements. Programmer II (SAS Reporting Specialist) The SAS Reporting Specialist performs complex (journey-level) computer programming work. Work involves analyzing data systems to develop software and produce reports; documenting the methods and procedures used in software development; and testing, correcting, and revising software. May provide guidance to others. Works under the Director of Information Management Services (IMS) with general supervision with limited latitude for the use of initiative and independent judgment. This position: Writes code in the SAS Windowing Environment using relational databases 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 EXPORT, PROC FORMAT, PROC FREQ, PROC PRINT, PROC REPORT, PROC SQL, PROC TABULATE, the SAS macro language, and ODS output, especially ODS output to Excel using the ExcelXP tagset. Helps analyze proposed programming projects in terms of requirements, capabilities, and time management; and provides technical assistance and advice to other programmers. May meet with program area users to gather, define and validate business requirements necessary for the development of specifications or programming work. Helps coordinate, design, and maintain the integration of data from various systems to the SAS data warehouse through ETL processes. Adheres to 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: This position requires: 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. Requires one year of experience working with relational databases. Education and experience relevant to position requirements may be substituted for one another on a year-for-year basis. Preferences for this position include: Experience with advanced SAS or SQL programming; and Experience working with the Division of Workers Compensation data. Additional job details: This position requires regular work attendance. The position may be eligible for a hybrid work schedule. If eligible, the employee must have a secure, dedicated workspace with reliable broadband internet service. The ideal candidate must be available for weekly meetings and group collaboration via Microsoft Teams and other applications during regular business hours. This position requires demonstrated knowledge of: State laws, rules, procedures, and regulations relevant to job requirements. Principles, practices, and techniques of comp ter databases, programming, system analysis, and system design. Database structures and theories. Database management, how to create, implement, and maintain a data warehouse; and Windows operating system and programming environment. This position requires demonstrated skill in: Problem-solving and critical thinking. Using Microsoft Office software applications, including Word, Excel, Outlook, and SharePoint. Using personal computers sufficient to enter and extract data from related systems and programs such as Centralized Accounting Payroll and Personnel (CAPPS) and other systems required to perform the job. Computer programming, and the operation of computers and applicable software. Programming and testing of structured computer programs; and Technical writing and development of business requirements. This position requires the demonstrated ability to: Communicate and work effectively with a wide range of people with varied skills, knowledge, and backgrounds. Maintain the confidentiality of sensitive information. Analyze and solve work-related problems and work independently on a variety of administrative work and technical assignments. Manage and coordinate multiple tasks and priorities to meet necessary deadlines. Work both independently and as a team player. 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 outliers, and debug/troubleshoot programs. Identify and articulate trends, outliners, and quality issues. Communicate highly technical and complex information to a diverse audience. Prioritize workload 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. Veterans Get help translating your military work experience and training courses into civilian job terms, qualifications/requirements, and skill sets. Redact personal or sensitive information from all attachments. To receive a veterans preference, you must submit the following documents, as applicable, with your application. Copy of the DD-214; member #4. Statement of compensation from the Veterans Administration or Copy of the DD1300. Applicable Military Occupational Specialty (MOS) codes are included, but not limited to one of the following: 25B, IT, ISM, 0673, 8846, 3D0X4 Click or copy and paste the following link into your browser to access Military Crosswalk information: Military Crosswalk for Occupational Category - Information Technology (texas.gov) How to apply: All applications must contain complete job histories, including job title, dates of employment, name of employer, managers name and phone number, and a description of duties performed. We may reject applications that do not include all the required information. Resumes do not substitute for this required information. Submitted through Work in Texas: Work in Texas (WIT) applicants must complete supplemental questions to be considered for the position. To complete supplemental questions, go to CAPPS Career Center to register or log in and access your profile.