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=00039055You 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

　　Applications must be filed athttps://capps.taleo.net/careersection/304/jobdetail.ftl?job=00039055tz=GMT-05%3A00tzname=America%2FChicagoAbout the Comptrollers OfficeInnovation, collaboration, and a commitment to excellence best describes the culture here at the Comptrollers Office. We take pride in the work we do serving as Texas' accountant, tax collector, treasurer, and much more!CultureOur agency workforce is as diverse as the people of Texas we serve. We value our employees and take very seriously our collective commitment to public service. Personal development opportunities are strongly encouraged through available workshops, teambuilding exercises, and on the job training. We offer flexible scheduling that helps employees maintain a healthy work-life balance.If you are seeking to gain knowledge, build your career, and network among goal-oriented professionals, this is the place for you!Click here to see an inside look at the Texas Comptrollers office! Click here to see a video from the division!General descriptionThe Comptrollers office is seeking a Systems Analyst VI for Agency Services in the Fiscal Management Statewide Fiscal Oversight Division. The work involves performing computer systems analysis work of Comptrollers financial systems and data used for statewide financial and fund (i.e., budgetary) accounting and oversight, providing expertise in querying and extracting data using programming languages, including Structured Query Language (SQL) and providing guidance for or manages projects related to accounting system data.Qualifications: Minimum QualificationsGraduation from an accredited college or university with a bachelors degree. Three years of experience with the Uniform Statewide Accounting System (USAS). Experience using DB2s Structured Query Language (SQL). Experience researching, analyzing and resolving variances and out of balance conditions with governmental accounting systems. Experience documenting and updating procedures.Preferred QualificationsGraduation from an accredited four-year college or university with a bachelors degree in accounting, auditing, business management, finance, computer science, computer information systems, or management information systems or a related field.Preferred Experience:Experience supporting Texas statewide fiscal systems (CAPPS, HRIS, SPRS, SPA, TINS, and/or USAS).Experience with a relational database (DB2 in particular).Experience using report generators and tools such as QMF, SYNCSORT, SAS, EASYTRIEVE.Experience using SAP Business Objects/Business Intelligence (BI) tools.Experience with programming languages including Python, Java, etc.A functional knowledge of mainframe programming (JCL - Job Control Language), including some experience at creating, reading, updating, and deleting mainframe datasets.A functional knowledge of using SAS to manage data and create reports.A functional knowledge of generating reports using mainframe tools, including experience with IBM OS mainframe environments (ex. TSO, batch processing, job control procedures and import/export of data).Prior experience at developing ad hoc reports using PC-based resources (Excel, Access, Business Objects), including experience working with flat files, CSV and formatted mainframe files.SubstitutionsOne additional year of experience performing accounting functions in a Comptroller fiscal system (HRIS, SPRS, SPA, TINS, and USAS) may substitute for thirty semester hours of educational requirement with a maximum substitution of 120 semester hours (four years).LICENSES / CERTIFICATIONSN/AIn this role you will have:Knowledge o :Standard practices for managing, interpreting, documenting, auditing, and developing information systems and data;Techniques for establishing and monitoring effective information system control structures; and,Current database design and digital analysis techniquesGovernmental accounting standards and reporting requirements.Skill in:Using several software platforms used for interrogating and analyzing data, which includes one or a combination of SAS, CAMS, Easytrieve, SQL, QMF, Queryman, MS Access, ACL, and Excel to perform control testing and digital analysis on information system data; (Technical Competence)Performing business or systems analysis using a defined methodology.Gathering information and performing research.Using a desktop computer in a Windows environment.Using Microsoft software and mainframe functions, with a high degree of accuracy.Effectively conveying information and encouraging an exchange of ideas. (Communication)Identifying, defining and solving problems. (Problem Solving)Ability to:Maintain confidentiality and protect the privacy of state employees, taxpayers, and other members of the public. (Security and Privacy)Follow all agency confidentiality, privacy, and information security policies and procedures. (Security and Privacy)Appropriately store, secure, and protect sensitive records and other confidential documents and data in accordance with the agencys certified Records Retention Schedule. (Security and Privacy)Seek guidance and clarification from relevant agency specialists when potential confidential issues arise. (Security and Privacy)Use discretion and appropriate judgement in communicating confidential and sensitive information. (Security and Privacy)Analyze, consolidate, and interpret complex data, procedures and systems.Write and revise standards, policies and procedures.Understand governmental fiscal policies.Be detail oriented.Establish and maintain effective working relationships with others, including peers, management, vendors and the general public.Professionally represent the section, division, or agency.Work within a team and a self-directed environment.Learn new concepts quickly and apply knowledge appropriately in highly active environment and changing circumstances.Work with others to achieve a common goal. (Teamwork)Adjust to changing workplace demands. (Adaptability)Meet the needs and expectations of internal and external customers. (Customer Service)Effectively demonstrate skill and ability to perform the specific job duties and tasks as defined by a job description.Be dependable, meet deadlines and produce high-quality work. (Workload Management/Productivity)Veterans:To receive veteran's preference a copy of your DD214 (Member 4) is required.Veterans, Reservist or Guardsmen with an MOS or additional duties that fall within the essential duties of the job position or other related fields pertaining to the minimum experience requirements may meet the minimum qualifications. All active duty, reservists, guardsmen, and veterans are encouraged to apply if they meet the qualifications for this position. Please call Human Resources, CPA Veterans Liaison at 512-475-3560/800-531-5441 for more information or assistance.If selected for the position the following must be provided for proof of veterans preference:Veteran must provid