Texas
Overview
Applications must be filed at
https://capps.taleo.net/careersection/ex/jobdetail.ftl?job=00053102 If you have previously applied, there is no need to reapply. Your application is still being considered for this position. Are you ready to grow and make a positive impact?
If you are seeking to gain knowledge, build your career, and network among goal-oriented professionals, this is the place for you! Innovation, collaboration, and a commitment to excellence drive the culture here at the Comptrollers Office. We take pride in the work we do serving as States accountant, tax collector, treasurer, and much more. The Comptrollers office serves virtually every citizen in the state. As Texas chief tax collector, accountant, revenue estimator, treasurer and purchasing manager, the agency is responsible for writing the checks and keeping the books for the multi-billion-dollar business of state government. Our agency workforce is as diverse as the people of Texas we serve. We value our employees and take our collective commitment to public service very seriously. 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. General Description
Performs highly advanced (senior level) computer systems analysis work. Performs complex analysis of Comptrollers financial systems and data used for statewide financial and fund (i.e., budgetary) accounting and oversight. Provides expertise in querying and extracting data using programming languages, including Structured Query Language (SQL). Provides guidance for or manages projects related to accounting system data. Works under minimal supervision with extensive latitude for the use of initiative and independent judgment. Work Hours
Monday through Friday, 40 hours a week with occasional evening, weekend hours and holidays. Hours may change based on business need. Minimum Qualifications
Education: Graduation from an accredited college or university with a bachelors degree. Experience: Experience with USAS or similar large-scale accounting systems (CAPPS, PeopleSoft, Oracle Financials, SAP, etc.). 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 Qualifications
Preferred Education: Graduation 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 using Power BI. 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 Substitutions
One (1) 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 and Certifications
N/A Summary of Physical Requirements
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. This position requires the incumbent to primarily perform sedentary office work; however, mobility (standing and walking) is routinely required to carry out some duties. It requires extensive computer, telephone and client/customer contact. It requires the ability to bend, stoop, kneel, and reach as needed for filing and similar routine office duties. The job also requires normal cognitive abilities requiring the ability to learn, recall, and apply certain practices and policies. It requires the stamina to maintain attention to detail despite interruptions. Marginal or corrected visual and auditory requirements are required for reading printed materials and computer screens and communicating with internal and external customers In this role you will:
Develops and codes programs that extract information from the Comptrollers fiscal management systems and use the information to (1) provide reports in response to open records and ad hoc report requests; and (2) ensure compliance with state law and agency fiscal policies. Performs system support of USAS including Central Profile Action Requests (CPARs) and Super Security Delete (SSD) request and assists with yearend close activities such as GL Close, file fixes and security reviews. Analyzes system data to identify and correct problems and assists agencies and business SMEs with problem resolution. Utilize SQL tools to analyze and research data issues. Leads and participates in special projects as assigned. Performs other related duties as assigned. Maximize Your Earnings! At the Comptroller's office, we know potential employees are looking for more than just a paycheck. The agency offers a strong benefits package for you and your family. Insurance, retirement plans, and a flexible work schedule are just the start. See our benefits offering Important Note to the Candidate:
Salary is contingent upon qualifications.
If you are scheduled for an interview and require any reasonable accommodation in our interview process, please inform the hiring representative who calls you to schedule your interview. Whenever possible, please give the hiring representative sufficient time to consider and respond to your request. MILITARY PREFERENCE
To receive MILITARY PREFERENCE, you are required to provide proof by attaching the necessary documentation to this job application. Click on the occupational category for the position. Additional MOS can be found at the State Auditors Office, Military Crosswalk Guide The Texas Veterans Commission provides helpful employment information. Go to: http://www.texasskillstowork.com , http://www.onetonline.org, https://hr.sao.texas.gov/CompensationSystem/JobDescriptions/ or www.careeronestop.org for assistance translating your military experience and training courses into civilian job terms, qualifications/requirements and skill sets. Applications submitted through Work in Texas: Work In Texas (WIT) applicants must complete supplemental questions to be considered for the position. To complete the supplemental questions please go to CAPPS Recruit to register or login and access your profile. The Comptrollers Office is proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity. Resumes will not be accepted in lieu of completed applications. The application must contain the necessary information in the work history for the applicant to qualify for the position. An applicant must be eligible to work in the United States to be hired at the Comptrollers office and must remain eligible, without sponsorship or any assurance of financial or other assistance from this agency, during the term of their employment. #J-18808-Ljbffr
Applications must be filed at
https://capps.taleo.net/careersection/ex/jobdetail.ftl?job=00053102 If you have previously applied, there is no need to reapply. Your application is still being considered for this position. Are you ready to grow and make a positive impact?
If you are seeking to gain knowledge, build your career, and network among goal-oriented professionals, this is the place for you! Innovation, collaboration, and a commitment to excellence drive the culture here at the Comptrollers Office. We take pride in the work we do serving as States accountant, tax collector, treasurer, and much more. The Comptrollers office serves virtually every citizen in the state. As Texas chief tax collector, accountant, revenue estimator, treasurer and purchasing manager, the agency is responsible for writing the checks and keeping the books for the multi-billion-dollar business of state government. Our agency workforce is as diverse as the people of Texas we serve. We value our employees and take our collective commitment to public service very seriously. 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. General Description
Performs highly advanced (senior level) computer systems analysis work. Performs complex analysis of Comptrollers financial systems and data used for statewide financial and fund (i.e., budgetary) accounting and oversight. Provides expertise in querying and extracting data using programming languages, including Structured Query Language (SQL). Provides guidance for or manages projects related to accounting system data. Works under minimal supervision with extensive latitude for the use of initiative and independent judgment. Work Hours
Monday through Friday, 40 hours a week with occasional evening, weekend hours and holidays. Hours may change based on business need. Minimum Qualifications
Education: Graduation from an accredited college or university with a bachelors degree. Experience: Experience with USAS or similar large-scale accounting systems (CAPPS, PeopleSoft, Oracle Financials, SAP, etc.). 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 Qualifications
Preferred Education: Graduation 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 using Power BI. 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 Substitutions
One (1) 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 and Certifications
N/A Summary of Physical Requirements
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. This position requires the incumbent to primarily perform sedentary office work; however, mobility (standing and walking) is routinely required to carry out some duties. It requires extensive computer, telephone and client/customer contact. It requires the ability to bend, stoop, kneel, and reach as needed for filing and similar routine office duties. The job also requires normal cognitive abilities requiring the ability to learn, recall, and apply certain practices and policies. It requires the stamina to maintain attention to detail despite interruptions. Marginal or corrected visual and auditory requirements are required for reading printed materials and computer screens and communicating with internal and external customers In this role you will:
Develops and codes programs that extract information from the Comptrollers fiscal management systems and use the information to (1) provide reports in response to open records and ad hoc report requests; and (2) ensure compliance with state law and agency fiscal policies. Performs system support of USAS including Central Profile Action Requests (CPARs) and Super Security Delete (SSD) request and assists with yearend close activities such as GL Close, file fixes and security reviews. Analyzes system data to identify and correct problems and assists agencies and business SMEs with problem resolution. Utilize SQL tools to analyze and research data issues. Leads and participates in special projects as assigned. Performs other related duties as assigned. Maximize Your Earnings! At the Comptroller's office, we know potential employees are looking for more than just a paycheck. The agency offers a strong benefits package for you and your family. Insurance, retirement plans, and a flexible work schedule are just the start. See our benefits offering Important Note to the Candidate:
Salary is contingent upon qualifications.
If you are scheduled for an interview and require any reasonable accommodation in our interview process, please inform the hiring representative who calls you to schedule your interview. Whenever possible, please give the hiring representative sufficient time to consider and respond to your request. MILITARY PREFERENCE
To receive MILITARY PREFERENCE, you are required to provide proof by attaching the necessary documentation to this job application. Click on the occupational category for the position. Additional MOS can be found at the State Auditors Office, Military Crosswalk Guide The Texas Veterans Commission provides helpful employment information. Go to: http://www.texasskillstowork.com , http://www.onetonline.org, https://hr.sao.texas.gov/CompensationSystem/JobDescriptions/ or www.careeronestop.org for assistance translating your military experience and training courses into civilian job terms, qualifications/requirements and skill sets. Applications submitted through Work in Texas: Work In Texas (WIT) applicants must complete supplemental questions to be considered for the position. To complete the supplemental questions please go to CAPPS Recruit to register or login and access your profile. The Comptrollers Office is proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity. Resumes will not be accepted in lieu of completed applications. The application must contain the necessary information in the work history for the applicant to qualify for the position. An applicant must be eligible to work in the United States to be hired at the Comptrollers office and must remain eligible, without sponsorship or any assurance of financial or other assistance from this agency, during the term of their employment. #J-18808-Ljbffr