TCEQ - CAPPS Reporting Coordinator

Are you an experienced Data Analyst, 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 Chief Budget & Efficiency Office, you would assist the Executive Office with oversight of the agency's budget, strategic planning, and promoting efficiency.

This position is a member of our Fiscal Control Division.

HERE'S WHAT YOU'LL BE DOING 

• 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 performing public drinking water system analyses, such as evaluation of water quality, water chemistry, or water microbial assessment.
• Experience creating Power BI dashboards.
• Experience building CAPPS Financials queries.

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. See Tex. Business & Commerce Code Section 117.001(2). 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.

Work Schedule

Standard business hours are M-F, 8:00 a.m. - 5:00 p.m.

Individual and work group schedule determined by the Fiscal Control Division.

BENEFITS

• Optional 401(k) and 457 plans
• Insurance: Health, Vision, Dental, and optional FSA
• Paid day(s) off from work on national holidays and holidays that the state observes
• Professional development opportunities
• Longevity pay based on your number of years working for the state
• Wellness Program and Activities
• Onsite Nurse Practitioner in HQ
• 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 accommodation during the employment process, please contact HRSS for assistance at (512) 239-0102.

MILITARY OCCUPATIONAL SPECIALTY (MOS) CODES

Military Occupational Specialty (MOS) codes can be found at: https://hr.sao.texas.gov/CompensationSystem/JobDescriptions/. Please click the hyperlink under `Occupational Category' for the respective Class Title.

Texas Commission on Environmental Quality is an Equal Opportunity Employer.