RRC - Data Analyst V

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://(Use the "Apply for this Job" box below)..

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 You Tube video that describes this amazing benefit
• 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:// To view benefits available to all State of Texas employees visit the Employee Retirement Systems website at .

The Railroad Commission of Texas (RRC) seeks a senior Data Analyst to perform highly advanced (senior-level) 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 and 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 in the implementation of multiple inter-related projects (including implementation of software applications in Software as a Service (SaaS) or Commercial off the Shelf (COTS), migration of data from the mainframe to the 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 tracks work of other team members or completes individual assignments as needed. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.

• 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…