RemoteLocal TX Govt SystemsData Analyst (mainframe)

Job ID: TX()

Remote/Local TX Govt Systems/Data Analyst (mainframe migration must/15) with IMS/COBOL/JCL/batch Visio Azure/AWS Databricks/Snowflake PII MDM DW BI JAD UAT experience

Location: Austin TX (RRC)
Duration: 12 Months

Years Required/Preferred Experience
6 Required Experience working in a medium to large information technology environment as a System Analyst Business Analyst or similar role.
3 Required Strong experience gathering and documenting requirements for reporting data extracts or data driven applications
3 Preferred Familiarity with mainframe systems (IMS COBOL files JCL batch processes)
5 Required Skill with Microsoft Office tools particularly with Word Excel PowerPoint Visio and SharePoint
3 Required Understanding of cloud data platforms (Azure AWS Databricks Snowflake or similar).
2 Required Ability to interpret data models data dictionaries and technical documentation.
2 Required Knowledge of database structures and theories
2 Required Knowledge of enterprise information management processes and methodologies relational database management systems and metadata management
2 Preferred Knowledge of local state and federal laws and regulations (PII) relevant to data management and data governance
2 Required Experience in working in fast-paced and ever-changing environments; achieving projects deliverables and deadlines; exercising sound judgment in making critical decisions; analyzing complex information and developing plans to address identified issues.
2 Required Skill in interpersonal relationships including the ability to work with people under pressure negotiate among multiple parties resolve conflicts and establish and maintain effective working relationships with various levels of personnel.
2 Preferred Knowledge of master data metadata reference data data warehousing and business intelligence principles and process including technical architecture
2 Preferred Experience in data focused projects like moving from Legacy to
newer systems.
- Preferred Graduation from an accredited four-year college or university with major coursework in data processing computer science business
administration or a related field.

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