Senior Systems Analyst - Texas Railroad - Austin, TX

Title: Senior Systems Analyst

Agency: Railroad Commission of Texas

Solicitation Reference Number: 455-26-28310

Address: 1701 North Congress Avenue, Austin, Texas

Remote Policy: 100% Remote

The Railroad Commission of Texas requires the services of one (1) Senior Systems Analyst to play a critical role in supporting the transition of reporting and data‑extract capabilities from legacy mainframe IMS systems to the future cloud or data‑lake environment.

This position focuses heavily on requirements gathering, analysis, and documentation to ensure that business reporting needs, data extract workflows, and downstream integrations are accurately captured and translated into technical specifications for cloud‑based solutions.

The ideal candidate has strong analytical skills, experience with legacy systems, and a solid understanding of modern data platforms, reporting tools, and integration patterns.

Major responsibilities include conducting detailed sessions with business stakeholders to understand reporting needs, data extract requirements, and downstream data consumption patterns.

• Document current state reporting logic, data sources, extract schedules, and dependencies within the mainframe IMS environment.
• Analyze gaps between current state mainframe processes and future state cloud or data lake architecture.
• Translate business requirements into clear functional and technical specifications for development teams.
• Validate requirements with stakeholders to ensure accuracy and alignment with business objectives.
• Coordinate and oversee analysis, designs, plans, diagrams, and verification procedures for existing and proposed applications. Provide technical advice, assistance, and recommendations for report development.

• Review and interpret mainframe IMS data structures, file layouts, and extract processes.
• Collaborate with data engineers and architects to map legacy data elements to cloud‑based data models.
• Support the design of new reporting and extract workflows that leverage cloud capabilities.
• Assist in defining data transformation rules, metadata, and data lineage documentation.
• Ensure reporting and extract requirements align with enterprise data governance standards.
• Work closely with project managers, developers, QA teams, and business units to ensure requirements are understood and implemented correctly.
• Provide subject‑matter expertise on reporting logic, data dependencies, and extract processes throughout the project lifecycle.
• Facilitate JAD sessions and stakeholder interviews, and document both business and technical requirements in a clear, comprehensive, and actionable format.
• Elicit and document data & reporting requirements (KPIs, filters, delivery cadence) and translate into functional/data specifications.
• Communicate progress, risks, and issues clearly to project leadership.
• Produce and maintain mappings, business rules, data dictionaries, and lineage/data flow diagrams spanning staging, integration, and presentation/reporting layers.
• Develop test cases and acceptance criteria for reporting and extract functionality.
• Support UAT by validating data accuracy, report outputs, and extract completeness.
• Troubleshoot defects and work with technical teams to resolve issues.

• Minimum Requirements: 6+ years required:
  Experience working in a medium to large IT environment as a System Analyst, Business Analyst, or similar role.
• 3+ years required:
  Strong experience gathering and documenting requirements for reporting, data extracts, or data‑driven applications.
• 3+ years preferred:
  Familiarity with mainframe systems (IMS, COBOL files, JCL, batch processes).
• 5+ years required:
  Skill with Microsoft Office tools, particularly Word, Excel, PowerPoint, Visio, and SharePoint.
• 3+ years required:
  Understanding of cloud data platforms (Azure, AWS, Databricks, Snowflake, or similar).
• 2+ years required:
  Ability to interpret data models, data dictionaries, and technical documentation.
• 2+ years required:
  Knowledge of database structures and theories.
• 2+ years required:
  Knowledge of enterprise information management processes and methodologies, relational database management…