TCEQ - Data Analyst IV
Centralized Accounting and Payroll/Personnel System, Austin, TX, United States
Job Description - TCEQ - Data Analyst IV (00057776)
Description
Are you an experienced Data Analyst IV, ready for a unique opportunity to grow with an environmental state agency?
Join TCEQ! We bring passion and drive to carry out our mission of protecting our state’s public health and natural resources.
Your Future Team
As part of TCEQ’s Office of the Executive Director, you would support management of the agency's day-to-day operations. This position is a member of our Fiscal Control Division.
Where This Works
Primary Location : Texas – Austin
Work Locations : Headquarters (582‑HQAUS) 12100 Park 35 Circle Austin 78753
Job Details
Job : Computer and Mathematical
Employee Status : Regular
Schedule : State Job Code 0653
Salary (Pay Basis) : 6,499.00 – 6,499.00 (Monthly)
Number of Openings : 1
Overtime Status : Exempt
Job Posting : Apr 24, 2026, 1:21:16 PM
Closing Date : May 9, 2026, 4:59:00 AM
Responsibilities
Design, build, test and deploy CAPPS queries/reports out of tables using a graphical interface.
Create complex CAPPS queries that include joined tables, criteria and prompts.
Edit existing CAPPS statewide queries to produce data relevant to TCEQ business needs.
Analyze and provide technical support to program areas in conjunction with CAPPS queries.
Collaborate with the program area for validation of accuracy on CAPPS queries that are created.
Work with the program areas to understand their reporting and analytical needs and translate them into reports.
Create reports in CAPPS SAP Business Objects (BOBJ).
Create dashboards in Power BI.
Edit existing statewide BOBJ reports to produce data relevant to TCEQ business needs.
Work with the program areas to create BOBJ reports that will help with reconciliation and business processes.
Monitor and optimize the performance of queries/reports in CAPPS/BOBJ.
Develop training materials for educating CAPPS Query Manager users.
Create desk aids related to CAPPS queries for the program areas to use.
Deliver quarterly and one-on-one training, as needed, on how to create CAPPS queries.
Design training materials to educate BOBJ users on the system.
Create desk aids related to BOBJ reports for the program areas to use.
Deliver quarterly and one-on-one training, as needed, on how to create BOBJ reports.
Provide backup to the CAPPS Security Coordinator.
Complete other duties or projects as assigned.
Key Qualifications
Experience using the Centralized Accounting and Payroll/Personnel Systems (CAPPS) Financials.
Experience designing, building and testing SQL queries outside of CAPPS.
Required Education & Experience
Five years of full-time experience in data analysis, data research, data compilation; and/or reporting work.
OR
A bachelor's degree from an accredited college or university with a major in engineering, basic science, computer science, environmental science, mathematics, statistics or a related field; plus three years of the required experience.
OR
A bachelor’s degree from an accredited college or university; plus four years of the required experience.
Employees in this classification series may research, work on, or have access to critical infrastructure, including but not limited to a communication infrastructure system, cybersecurity system, electric grid, hazardous waste treatment system, or water treatment facility. Accordingly, the ability to maintain the security or integrity of the infrastructure is a requirement to be hired for and to continue to be employed with TCEQ.
Transcript/College Hours or Course Work
See instructions on how to attach documents. A copy of your official college transcript or evaluation of foreign credentials in CAPPS is required if needed to meet the qualifications listed above.
Current TCEQ Employees
This position is also available as a lateral transfer opportunity (LTO) to TCEQ employees within the Data Analyst IV state classification. The selected candidate must meet the minimum qualifications of the corresponding job in the Data Analyst IV series.
Work Schedule
Standard business hours are M-F, 8:00 a.m. – 5:00 p.m. Individual and work group schedule determined by the TCEQ Fiscal Control Division.
Benefits
Optional 401(k) and 457 plans
Insurance: Health, Vision, Dental, and optional FSA
Paid days off from work on national holidays and holidays that the state observes
Longevity pay based on your number of years working for the state
Wellness Program and Activities
Work-Life Balance
Condition of Employment
TCEQ will conduct a criminal history records search, driving history (if required for the job) on candidates offered employment.
In compliance with ADA, if you need any special accommodations during the employment process, please contact HRSS for assistance at (512) 239-0102.
Equal Opportunity
Texas Commission on Environmental Quality is an Equal Opportunity Employer.
#J-18808-Ljbffr
Description
Are you an experienced Data Analyst IV, ready for a unique opportunity to grow with an environmental state agency?
Join TCEQ! We bring passion and drive to carry out our mission of protecting our state’s public health and natural resources.
Your Future Team
As part of TCEQ’s Office of the Executive Director, you would support management of the agency's day-to-day operations. This position is a member of our Fiscal Control Division.
Where This Works
Primary Location : Texas – Austin
Work Locations : Headquarters (582‑HQAUS) 12100 Park 35 Circle Austin 78753
Job Details
Job : Computer and Mathematical
Employee Status : Regular
Schedule : State Job Code 0653
Salary (Pay Basis) : 6,499.00 – 6,499.00 (Monthly)
Number of Openings : 1
Overtime Status : Exempt
Job Posting : Apr 24, 2026, 1:21:16 PM
Closing Date : May 9, 2026, 4:59:00 AM
Responsibilities
Design, build, test and deploy CAPPS queries/reports out of tables using a graphical interface.
Create complex CAPPS queries that include joined tables, criteria and prompts.
Edit existing CAPPS statewide queries to produce data relevant to TCEQ business needs.
Analyze and provide technical support to program areas in conjunction with CAPPS queries.
Collaborate with the program area for validation of accuracy on CAPPS queries that are created.
Work with the program areas to understand their reporting and analytical needs and translate them into reports.
Create reports in CAPPS SAP Business Objects (BOBJ).
Create dashboards in Power BI.
Edit existing statewide BOBJ reports to produce data relevant to TCEQ business needs.
Work with the program areas to create BOBJ reports that will help with reconciliation and business processes.
Monitor and optimize the performance of queries/reports in CAPPS/BOBJ.
Develop training materials for educating CAPPS Query Manager users.
Create desk aids related to CAPPS queries for the program areas to use.
Deliver quarterly and one-on-one training, as needed, on how to create CAPPS queries.
Design training materials to educate BOBJ users on the system.
Create desk aids related to BOBJ reports for the program areas to use.
Deliver quarterly and one-on-one training, as needed, on how to create BOBJ reports.
Provide backup to the CAPPS Security Coordinator.
Complete other duties or projects as assigned.
Key Qualifications
Experience using the Centralized Accounting and Payroll/Personnel Systems (CAPPS) Financials.
Experience designing, building and testing SQL queries outside of CAPPS.
Required Education & Experience
Five years of full-time experience in data analysis, data research, data compilation; and/or reporting work.
OR
A bachelor's degree from an accredited college or university with a major in engineering, basic science, computer science, environmental science, mathematics, statistics or a related field; plus three years of the required experience.
OR
A bachelor’s degree from an accredited college or university; plus four years of the required experience.
Employees in this classification series may research, work on, or have access to critical infrastructure, including but not limited to a communication infrastructure system, cybersecurity system, electric grid, hazardous waste treatment system, or water treatment facility. Accordingly, the ability to maintain the security or integrity of the infrastructure is a requirement to be hired for and to continue to be employed with TCEQ.
Transcript/College Hours or Course Work
See instructions on how to attach documents. A copy of your official college transcript or evaluation of foreign credentials in CAPPS is required if needed to meet the qualifications listed above.
Current TCEQ Employees
This position is also available as a lateral transfer opportunity (LTO) to TCEQ employees within the Data Analyst IV state classification. The selected candidate must meet the minimum qualifications of the corresponding job in the Data Analyst IV series.
Work Schedule
Standard business hours are M-F, 8:00 a.m. – 5:00 p.m. Individual and work group schedule determined by the TCEQ Fiscal Control Division.
Benefits
Optional 401(k) and 457 plans
Insurance: Health, Vision, Dental, and optional FSA
Paid days off from work on national holidays and holidays that the state observes
Longevity pay based on your number of years working for the state
Wellness Program and Activities
Work-Life Balance
Condition of Employment
TCEQ will conduct a criminal history records search, driving history (if required for the job) on candidates offered employment.
In compliance with ADA, if you need any special accommodations during the employment process, please contact HRSS for assistance at (512) 239-0102.
Equal Opportunity
Texas Commission on Environmental Quality is an Equal Opportunity Employer.
#J-18808-Ljbffr