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 Systems Analyst VVI to support the agency's Technology Modernization initiatives, including Mainframe Transformation and LoneSTAR. This role combines business, systems, and data analysis to understand user needs and existing operations; define requirements and specifications; and help design, implement, test, and improve applications, integrations, reporting, and data solutions. Work spans softwareasaservice (SaaS) and commercial offtheshelf (COTS) applications, migration from mainframe and other legacy systems, and data migration from Legacy systems into modern platforms.
The analyst collaborates with product owners, subject matter experts, project managers, developers, systems analysts, DBAs, ETL engineers, reporting teams, and agency stakeholders. Work is performed under limited supervision with considerable latitude for initiative and independent judgment. The position also supports consistent analysis practices, quality deliverables, data governance, and effective coordination across interrelated projects. The analyst may coordinate or assign work to other team members while completing individual assignments as needed. These actions will primarily support the production of currently deployed applications and will require daily interactions with business users.
Essential Job Duties - Assess and improve LoneSTAR and data transformation analysis, design, and documentation processes; monitor adherence to standards and the quality of application and project deliverables.
- Elicit, analyze, document, verify, and validate business, functional, system, and data requirements and translate them into specifications, business rules, and testable acceptance criteria.
- Analyze and document currentstate and futurestate business processes, system workflows, interfaces, and operational needs for modernization and implementation projects.
- Analyze legacy data flows to support transition to modern applications and platforms, including data warehouse capabilities.
- Profile and analyze complex datasets; produce and maintain sourcetotarget mappings, transformation logic, data definitions, dictionaries, and dataflow and lineage documentation across SQL Server, Oracle, and legacy sources.
- Define and perform data quality controls, including reconciliations, rowcount and integrity checks, exception analysis, and rootcause investigation; recommend corrective actions to prevent recurring defects.
- Partner with application and ETL/ELT/Snowflake teams on data integration, incremental or changedatacapture approaches, load schedules, and performance considerations; validate loads against source systems.
- If needed, support reporting and analytics deliverables by documenting measures, field definitions, filters, aggregations, semantic model requirements, and businessrule validation.
- Develop, review, and maintain system and project documentation, including process models, requirements packages, design materials, test plans, risk assessments, cutover plans, and runbooks.
- Plan and facilitate system integration and user acceptance testing with the Quality Assurance team; define scenarios and expected results, coordinate defect remediation and retesting, and document approvals.
- Provide quality assurance consultation and review project deliverables for completeness, consistency, auditability, and alignment with established policies and procedures.
- Identify project risks, issues, and dependencies; analyze trends; recommend mitigation and corrective actions; and work with project managers and stakeholders to resolve concerns.
- Support production operations by helping identify, triage, investigate, and document incidents; perform rootcause analysis and coordinate resolution to improve system functionality, performance, and stability.
- Define, validate, and support AIenabled business use cases using Microsoft Copilot, Kiro, or similar platforms, consistent with agency policy and responsibleuse practices.
- Coordinate analysis activities and assignments across team members as needed; provide assistance to developers, systems analysts, customers, and business stakeholders during implementation and maintenance.
- Perform related work as assigned.
For Military Crosswalk information, please visit: _InformationTechnology.pdf
Minimum QualificationsSystems 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.
- Eight or more years of progressive experience in business, systems, or data analysis on enterprise IT projects, including handson requirements, process analysis, and system or data documentation.
- Experience planning, developing, implementing, or maintaining technology projects; experience may have occurred concurrently.
- Education and experience may be substituted for each other on a yearforyear basis.
Systems Analyst VI - Bachelor's degree from an accredited fouryear college or university, preferably with major coursework in information systems, computer science, business, or a related field.
- Ten or more years of progressive experience as a business, systems, or data analyst on enterprise IT projects, including requirements, process analysis, data mapping, profiling, lineage, and documentation responsibilities.
- At least eight years of experience supporting information technology programs and at least four years of experience in data analysis and/or data architecture.
- Experience planning, developing, implementing, or maintaining technology projects; experience may have occurred concurrently.
- Education and experience may be substituted for each other on a yearforyear basis.
Preferred Qualifications - Experience with the RBDMS (RiskBased Data Management System) platform and regulatory processes, such as permitting, inspection, or licensing; oil and gas domain experience is a plus.
- Advanced SQL proficiency with SQL Server and/or Oracle for data profiling, analysis, validation, and reconciliation; familiarity with ERDs and relational modeling.
- Experience with production support, DevOps, or a technical support lead role; familiarity with ticketing systems and Azure DevOps.
- Experience with ETL/ELT tools and practices such as SSIS, Azure Data Factory, Informatica, GoAnywhere, and MuleSoft, including sourcetotarget specifications and transformation validation.
- Experience defining data quality rules, data governance, metadata, lineage, and data security practices; familiarity with data catalog or lineage tools.
- Exposure to Power BI or SSRS, Snowflake or Azure analytics services, and reporting or semantic model validation.
- Familiarity with MuleSoft, GoAnywhere, or filebased integrations, including scheduling, controls, and reconciliation.
- Strong technical writing and diagramming skills, including Visio; experience maintaining project artifacts in SharePoint, Confluence, or Azure DevOps.
- Experience with process improvement, change management, risk mitigation, quality assurance, and user acceptance testing.
- Experience leading analysis standards, coordinating team assignments, resolving conflicts, and improving stakeholder processes.
- Experience using Microsoft Copilot, Kiro, or similar AI platforms for requirements, process analysis, documentation, testing, or workflow automation; familiarity with prompt engineering, model evaluation, and responsible AI practices.
- Scripting for analysis or automation, such as Python or PowerShell.
- CCBA, CBAP, or a similar business analysis certification.
Knowledge/Skills/Abilities - Knowledge of Agile methods, enterprise IT operations, vendor performance evaluation, and technology modernization from legacy or mainframe systems.
- Knowledge of data governance, metadata management, data quality, data security, and user acceptance and integration testing methods.
- Knowledge of change management, training and communication practices, and work simplification methods.
- Skill in eliciting and documenting requirements, analyzing business processes and complex systems, and translating needs into practical solutions.
- Skill in data analysis, interpreting complex data, identifying trends and defects, and developing data validation and reconciliation approaches.
- Skill in coordinating analysis, integration, and user acceptance testing activities; supporting development, training, and implementation materials.
- Skill in technical writing, diagramming, problem solving, facilitation, negotiation, and managing stakeholder expectations.
- Ability to communicate complex technical information clearly and concisely, orally and in writing, to diverse audiences.
- Ability to exercise sound judgment, take initiative, work independently, manage multiple projects, and respond effectively to highpriority or timesensitive requests.
- Ability to lead and collaborate with diverse teams, maintain effective internal and external working relationships, and plan or assign work as needed.
Working Conditions - Ability to work onsite at RRC headquarters in Austin, Texas, with potential eligibility to work remotely for up to two days per week if approved under applicable state and agency telework policies and business needs.
- Ability to work a consistent schedule such as Monday through Friday, 8:00 a.m. to 5:00 p.m. Central Time, with occasional flexible hours, afterhours, weekend, or holiday work.
- Level and 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.
- 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.
Important Information For All Applicants The Railroad Commission of Texas does not sponsor employment visas or participate in employersponsored immigration programs. The agency does not provide employer support for applications to extend or obtain employment authorization, including employer attestations, training plans, or other documentation required for participation in programs such as STEM Optional Practical Training (STEM OPT). Applicants should consider this policy when determining whether the position meets their employment authorization requirements.
The agency will complete employment eligibility verification and other documentation required by applicable law. The agency does not provide discretionary immigration sponsorship or programspecific employer documentation beyond those legal obligations.
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.
