RRC - Data Analyst III - V
Job Description
**RRC \- Data Analyst III \- V** **(****00056908****)**
**Organization****:** RAILROAD COMMISSION OF TEXAS
**Primary Location****:** Texas\-Austin
**Work Locations****:** RRC Headquarters 1701 N Congress Avenue Austin 78701
**Job****:** Computer and Mathematical
**Employee Status****:** Regular
**Schedule****:** Full\-time
**Standard Hours Per Week****:** 40\.00
**State Job Code****:** 0654
**Salary Admin Plan****:** B
**Grade****:** 22 24, 26
**Salary (Pay Basis)****:** 6,377\.50 \- 9,916\.67 (Monthly)
**Number of Openings****:** 1
**Overtime Status****:** Exempt
**Job Posting****:** Mar 18, 2026, 2:17:13 PM
**Closing Date**: Apr 1, 2026, 11:59:00 PM
**Description**
The Railroad Commission of Texas is a state agency with primary regulatory jurisdiction over the oil and natural gas industry; pipeline transport and pipeline safety; natural gas utilities; the LP\-gas industry; and surface mining operations. You can find more details about us on the Railroad Commission of Texas' website here: https://www.rrc.texas.gov/about\-us/.
To support our mission to serve Texas, we need great people to join our team. We provide a great working environment along with outstanding benefits, including:
* Generous paid time off, including vacation, sick time, and at least 12 paid holidays per year
* Telework options for eligible positions
* Flexible work schedules
* Retirement pension with a 150% agency match – you can watch this YouTube video that describes this amazing benefit https://www.youtube.com/watch?v\=AJI6M7g73\-w
* 401(k), 457(b) and Roth
* Health premiums 100% paid for full\-time employees
* Tuition Reimbursement
* Wellness and Exercise Leave
* Career development programs/opportunities for advancement
For a complete list of our total compensation package, please visit our website at https://www.rrc.texas.gov/about\-us/jobs/. To view benefits available to all State of Texas employees, visit the Employee Retirement Systems website at https://ers.texas.gov/benefits\-at\-a\-glance.
**Job Description**
The Railroad Commission of Texas (RRC) seeks a Data Analyst III, IV, or V to perform data analysis and documentation supporting the agency's Technology Modernization initiatives (including Mainframe Transformation and LoneSTAR). Work is data\-centric: profiling and mapping data, documenting source\-to\-target (S2T) transformations, analyzing root causes of data defects, defining data quality controls, and creating dataflow/lineage documentation across SQL Server, Oracle, and mainframe/legacy sources.
The analyst collaborates with product owners, SMEs, DBAs, ETL engineers (SSIS/ADF/Informatica), and reporting teams (Power BI/SSRS) to translate business needs into requirements, specifications, and testable acceptance criteria; ensure accurate, timely extracts/loads; and support audit\-ready reporting. Work is performed under limited supervision with considerable latitude for initiative and independent judgment.
This position will be responsible for data analysis and documentation during the implementation of multiple interrelated projects (including the deployment of software applications in Software as a Service (SaaS) or Commercial Off\-the\-Shelf (COTS), data migration from the mainframe to new systems, and building a Data Warehouse). Assessment of existing Mainframe Transformation business analysis processes, implementation of any necessary improvements to these processes, and monitoring/enforcement of the processes to ensure deliverables and materials are produced and maintained in accordance with newly established processes and procedures, are of consistent quality, and use accepted business analysis methodologies. Make assignments and track the work of other team members, or complete individual assignments as needed. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.
**Essential Job Functions**
* Assess and improve program analysis/process standards (with emphasis on data mapping, lineage, and reconciliation); monitor adherence and quality.
* Elicit and document data and reporting requirements (KPIs, filters, aggregations, cadence, delivery channel) and translate into functional/data specifications.
* Produce and maintain data profiling results, source\-to\-target mapping documents, business rules, transformation logic, and data dictionaries for ETL/ELT (SSIS/ADF/Informatica) between SQL Server/Oracle and legacy/mainframe sources.
* Create and maintain end\-to\-end dataflow and lineage diagrams (current\-state and future\-state) covering staging, integration, and presentation/reporting layers.
* Define and execute data quality controls (row\-count checks, checksums/hashes, referential integrity, threshold/exception reports) and drive root\-cause analysis for data issues.
* Partner with ETL and app teams on incremental/CDC strategies, load windows, and performance considerations; validate loads and reconcile with sources.
* Support repor
**Organization****:** RAILROAD COMMISSION OF TEXAS
**Primary Location****:** Texas\-Austin
**Work Locations****:** RRC Headquarters 1701 N Congress Avenue Austin 78701
**Job****:** Computer and Mathematical
**Employee Status****:** Regular
**Schedule****:** Full\-time
**Standard Hours Per Week****:** 40\.00
**State Job Code****:** 0654
**Salary Admin Plan****:** B
**Grade****:** 22 24, 26
**Salary (Pay Basis)****:** 6,377\.50 \- 9,916\.67 (Monthly)
**Number of Openings****:** 1
**Overtime Status****:** Exempt
**Job Posting****:** Mar 18, 2026, 2:17:13 PM
**Closing Date**: Apr 1, 2026, 11:59:00 PM
**Description**
The Railroad Commission of Texas is a state agency with primary regulatory jurisdiction over the oil and natural gas industry; pipeline transport and pipeline safety; natural gas utilities; the LP\-gas industry; and surface mining operations. You can find more details about us on the Railroad Commission of Texas' website here: https://www.rrc.texas.gov/about\-us/.
To support our mission to serve Texas, we need great people to join our team. We provide a great working environment along with outstanding benefits, including:
* Generous paid time off, including vacation, sick time, and at least 12 paid holidays per year
* Telework options for eligible positions
* Flexible work schedules
* Retirement pension with a 150% agency match – you can watch this YouTube video that describes this amazing benefit https://www.youtube.com/watch?v\=AJI6M7g73\-w
* 401(k), 457(b) and Roth
* Health premiums 100% paid for full\-time employees
* Tuition Reimbursement
* Wellness and Exercise Leave
* Career development programs/opportunities for advancement
For a complete list of our total compensation package, please visit our website at https://www.rrc.texas.gov/about\-us/jobs/. To view benefits available to all State of Texas employees, visit the Employee Retirement Systems website at https://ers.texas.gov/benefits\-at\-a\-glance.
**Job Description**
The Railroad Commission of Texas (RRC) seeks a Data Analyst III, IV, or V to perform data analysis and documentation supporting the agency's Technology Modernization initiatives (including Mainframe Transformation and LoneSTAR). Work is data\-centric: profiling and mapping data, documenting source\-to\-target (S2T) transformations, analyzing root causes of data defects, defining data quality controls, and creating dataflow/lineage documentation across SQL Server, Oracle, and mainframe/legacy sources.
The analyst collaborates with product owners, SMEs, DBAs, ETL engineers (SSIS/ADF/Informatica), and reporting teams (Power BI/SSRS) to translate business needs into requirements, specifications, and testable acceptance criteria; ensure accurate, timely extracts/loads; and support audit\-ready reporting. Work is performed under limited supervision with considerable latitude for initiative and independent judgment.
This position will be responsible for data analysis and documentation during the implementation of multiple interrelated projects (including the deployment of software applications in Software as a Service (SaaS) or Commercial Off\-the\-Shelf (COTS), data migration from the mainframe to new systems, and building a Data Warehouse). Assessment of existing Mainframe Transformation business analysis processes, implementation of any necessary improvements to these processes, and monitoring/enforcement of the processes to ensure deliverables and materials are produced and maintained in accordance with newly established processes and procedures, are of consistent quality, and use accepted business analysis methodologies. Make assignments and track the work of other team members, or complete individual assignments as needed. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.
**Essential Job Functions**
* Assess and improve program analysis/process standards (with emphasis on data mapping, lineage, and reconciliation); monitor adherence and quality.
* Elicit and document data and reporting requirements (KPIs, filters, aggregations, cadence, delivery channel) and translate into functional/data specifications.
* Produce and maintain data profiling results, source\-to\-target mapping documents, business rules, transformation logic, and data dictionaries for ETL/ELT (SSIS/ADF/Informatica) between SQL Server/Oracle and legacy/mainframe sources.
* Create and maintain end\-to\-end dataflow and lineage diagrams (current\-state and future\-state) covering staging, integration, and presentation/reporting layers.
* Define and execute data quality controls (row\-count checks, checksums/hashes, referential integrity, threshold/exception reports) and drive root\-cause analysis for data issues.
* Partner with ETL and app teams on incremental/CDC strategies, load windows, and performance considerations; validate loads and reconcile with sources.
* Support repor
Posted: 2026-03-18