TCEQ - Data Analyst IV
The Texas Comptroller of Public Accounts (CPA), Austin, TX, United States
Job 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. See details about what we do.
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 designing, building and testing SQL queries outside of CAPPS.
Experience building CAPPS Financials queries.
Qualifications:
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.
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 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 any special accommodations 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.
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. See details about what we do.
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 designing, building and testing SQL queries outside of CAPPS.
Experience building CAPPS Financials queries.
Qualifications:
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.
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 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 any special accommodations 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.