Railroad Commission of Texas is hiring: RRC - Data Analyst V in Austin

Data Analyst V – Railroad Commission of Texas The Railroad Commission of Texas (RRC) seeks a senior Data Analyst to perform highly advanced data analysis and documentation supporting the agency’s Technology Modernization initiatives (including Mainframe Transformation and LoneSTAR). The 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. Key Details Seniority level: Mid‑Senior level Employment type: Full‑time Job function: Information Technology Industry: Oil and Gas Responsibilities 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 logs, 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 reporting and analytics deliverables (Power BI/SSRS): field definitions, semantic model requirements, and validation of calculations/filters against business rules. Plan and facilitate UAT for data changes and reports (test scenarios, expected results, sign‑offs); coordinate remediation of defects and re‑tests. Contribute to cutover/runbooks for data migrations; track issues/risks and maintain auditable documentation in SharePoint/Confluence/Azure DevOps. Perform related work as assigned. Minimum Qualifications Bachelor’s Degree from an accredited four‑year college or university, preferably with major coursework in information systems, computer science, business, or a related field. 10+ years of progressive experience as a Data Analyst on enterprise IT projects, including hands‑on requirements, data mapping, profiling, lineage, and documentation responsibilities; experience may be concurrent. Planning, developing, and implementing projects or maintenance activities. Experience may have occurred concurrently. Experience and education may be substituted for each other on a year‑for‑year basis. Preferred Qualifications Experience with the RBDMS platform. Experience dealing with regulatory processes; for example: permitting, inspection, and/or licensing. Experience with process improvement strategies and methodologies. Experience with test planning and implementation strategies, particularly user acceptance testing. Proven ability to lead change and design more efficient processes. Proven ability to resolve conflict and deal with challenging situations. Advanced SQL proficiency (SQL Server and/or Oracle) for profiling, validation, and reconciliation; fluency with ERD/relational modeling, normalization, keys, and indexing. Demonstrated experience working with ETL/ELT teams and artifacts (SSIS, ADF, and/or Informatica): reading/writing S2T specs, documenting transformations, validating loads. Proven ability to define data quality rules and execute reconciliation/exception analysis; deliver root‑cause findings and corrective actions. Strong technical writing skills and proficiency with Visio/diagramming; experience maintaining auditable artifacts in SharePoint/Confluence/Azure DevOps. Experience facilitating UAT for data/reporting deliverables (test design, execution tracking, sign‑off). Oil gas/regulatory domain experience and/or familiarity with RBDMS data models. Experience bridging mainframe/hierarchical data (e.g., VSAM/IMS) into relational structures and documenting the mappings. Exposure to Power BI/SSRS (semantic modeling concepts, DAX basics, report validation) and Snowflake or Azure analytics services. Familiarity with MuleSoft/GoAnywhere and file‑based integrations, including scheduling, controls, and reconciliation. Experience with process improvement methods and change management for data‑centric projects; prior leadership of analysis standards. Benefits 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. 401(k), 457(b) and Roth plans. Health premiums 100% paid for full‑time employees. Tuition Reimbursement. Wellness and Exercise Leave. Career development programs/opportunities for advancement. Additional Information For Military Crosswalk information, please visit https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_PlanningResearchandStatistics.pdf. 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. #J-18808-Ljbffr