Agency InformationThe 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 LPgas industry, and surface mining operations. You can find more details about us on the Railroad Commission of Texas' website here
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
- 401(k), 457(b) and Roth
- Health premiums 100% paid for fulltime 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 To view benefits available to all State of Texas employees, visit the Employee Retirement Systems website at
Job DescriptionThe Railroad Commission of Texas (RRC) seeks a Data Analyst III, IV, or V to perform data analysis and documentation in support of the agency's Technology Modernization initiatives (including Mainframe Transformation and LoneSTAR). Work is datacentric: profiling and mapping data, documenting SourcetoTarget (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 auditready 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 other team members' work, or complete individual assignments as needed. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.
Essential Job Duties - 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, sourcetotarget 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 endtoend dataflow and lineage diagrams (currentstate and futurestate) covering staging, integration, and presentation/reporting layers.
- Define and execute data quality controls (rowcount checks, checksums/hashes, referential integrity, threshold/exception reports) and drive rootcause 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, signoffs); coordinate defect remediation and retests.
- Contribute to cutover/runbooks for data migrations; track issues/risks and maintain auditable documentation in SharePoint/Confluence/Azure DevOps.
- Performs related work as assigned
For Military Crosswalk information, please visit: _PlanningResearchandStatistics.pdf
Minimum QualificationsData Analyst V - Bachelor's Degree from an accredited fouryear 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 handson 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 yearforyear basis.
Data Analyst IV - Bachelor's Degree from an accredited fouryear college or university, preferably with major coursework in information systems, computer science, business, or a related field.
- 8+ years of progressive experience as a Data Analyst on enterprise IT projects, including handson 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 yearforyear basis
Data Analyst III - Bachelor's Degree from an accredited fouryear college or university, preferably with major coursework in information systems, computer science, business, or a related field.
- 6+ years of progressive experience as a Data Analyst on enterprise IT projects, including handson 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 yearforyear 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, and validating loads.
- Proven ability to define data quality rules and execute reconciliation/exception analysis; deliver rootcause 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, signoff).
- 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 filebased integrations, including scheduling, controls, and reconciliation.
- Experience with process improvement methods and change management for datacentric projects; prior leadership of analysis standards.
- Scripting for analysis/automation (e.g., Python or PowerShell) and experience with data catalog/lineage tools.
Knowledge/Skills/Abilities - Knowledge of Business / Data Analysis and Project Management Processes (BABOK/PMBOK) and the DIR Project Delivery Framework.
- Knowledge of systems and procedures used to evaluate a thirdparty vendor's performance.
- Knowledge of Agile methodologies, including build planning, sprint planning, and sprint execution processes and activities.
- Knowledge of largescale IT operations and information technology industry trends.
- Knowledge of technology modernization, from legacy/mainframe systems to modern technologies.
- Knowledge of change management best practices for technologyrelated initiatives, including training and communication.
- Knowledge of user acceptance testing methods and strategies.
- Knowledge of work simplification methods.
- Skill in the coordination of business/data analyst activities, analysis and documentation of business processes, elicitation of requirements, development of process improvement, planning and execution of integration and user acceptance testing, support of development training, and implementation material.
- Skill in coordinating and solving problems.
- Skill in managing user expectations and satisfaction.
- Skill in analyzing complex business/data environments and policies to develop effective and innovative solutions.
- Ability to lead diverse activities while maintaining a high degree of efficiency in achieving the commission goals through consistent, effective assessment and implementation of improvements.
- Ability to exercise sound judgment in making critical decisions; to analyze complex information and develop plans; to interpret complex data; to effectively demonstrate negotiation and facilitation skills; to communicate effectively; and to plan, assign, and/or supervise the work of others.
- Ability to respond effectively in highpriority, highpressure, or highly visible situations (e.g., elected official, Legislative, or Executive requests) when necessary and meet changing demands, priorities, and timelines.
- Ability to communicate complex technical information clearly and concisely, both orally and in writing, to diverse audiences.
- Ability to analyze systems and procedures; to write and revise standards and procedures; and to handle multiple projects.
- Ability to maintain working relationships with internal/external stakeholders.
- Ability to take initiative and work independently.
- Ability to work effectively on a team as a member and a leader.
Working Conditions - Ability to work a consistent schedule such as MondayFriday, 8 AM 5 PM Central Time, with occasional flexible hours, after hours, weekends, and holidays.
- Ability to work Onsite (Austin, TX), with the flexibility to follow the organization's telework policy, including eligibility to work remotely up to two days per week if approved.
- Level & Salary will be determined based on the selected candidate's education, experience, knowledge, skills, and abilities
Additional InformationWork Hours: Standard office hours for Commission employees are 8:00 a.m. to 5:00 p.m., Monday through Friday. Our agency offers alternative schedules for employees, provided they do not adversely affect operations or service levels and standard hours of operation are maintained. The Commission may also offer telework in accordance with the agency's approved Telework Plan. Alternate work schedules may be discussed with the hiring manager during the interview process.
APPLICATIONS SUBMITTED THROUGH WORK IN TEXAS: Work In Texas (WIT) applicants must complete the CAPPS Recruit Prescreening Questionnaire to be considered for the posting. To complete the Prescreening Questionnaire, go to CAPPS Recruit to register or log in:
Remarks: - There is one available position.
- Official transcripts, DD214 or DD1300, copies of license/certifications, or other minimum requirement validations will be requested at the time of the job offer.
- Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa.
- Criminal background checks will be conducted on all final candidates. An applicant who has been convicted of a criminal offense relevant to the position may be disqualified from employment.
THE RAILROAD COMMISSION OF TEXAS ONLY ACCEPTS ONLINE APPLICATIONS FOR THIS POSTING. Due to the high volume of applications, we do not accept telephone calls. Only candidates selected to interview will be contacted. Notifications to applicants are sent electronically to the email address you provide.
The Railroad Commission of Texas is an Equal Opportunity Employer and does not
discriminate on the basis of race, color, national origin, sex, religion, age
or disability in employment or in the provision of services.
The Railroad Commission of Texas is a tobaccofree workplace.
Never miss an opportunity! Create an alert based on the job you applied for.
