RRC - Systems Analyst V-VI

Please paste the following URL into a browser to view the entire job posting on the CAPPS Careers page.https://erphcmprd.cpa.texas.gov/psp/candidateportal/EMPLOYEE/HRMS/c/HRS\_HRAM\_FL.HRS\_CG\_SEARCH\_FL.GBL?Page=HRS\_APP\_JBPST\_FLandAction=UandFOCUS=ApplicantandSiteId=1andJobOpeningId=107163andPostingSeq=1Agency 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 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 yearTelework options for eligible positions Flexible work schedulesRetirement pension with a 150% agency match - you can watch this YouTube video that describes this amazing benefit https://www.youtube.com/watch?v=AJI6M7g73-w401(k), 457(b) and RothHealth premiums 100% paid for full-time employeesTuition ReimbursementWellness and Exercise LeaveCareer 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 DescriptionThe Railroad Commission of Texas (RRC) seeks a Systems Analyst V-VI 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 software-as-a-service (SaaS) and commercial off-the-shelf (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 DutiesAssess 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 current-state and future-state 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 source-to-target 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, row-count and integrity checks, exception analys s, and root-cause investigation; recommend corrective actions to prevent recurring defects.Partner with application and ETL/ELT/Snowflake teams on data integration, incremental or change-data-capture 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 business-rule 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 root-cause analysis and coordinate resolution to improve system functionality, performance, and stability.Define, validate, and support AI-enabled business use cases using Microsoft Copilot, Kiro, or similar platforms, consistent with agency policy and responsible-use 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: https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC\_InformationTechnology.pdf