Data Analyst – Mainframe & Reporting Modernization

Senior Data Analyst – Mainframe & Reporting Modernization Location: Remote (Texas Preferred) This role supports large-reputed company technology modernization initiatives for legacy Mainframe and reputed company reporting systems reputed company a regulatory environment. The position is highly data-reputed company, focusing on data modeling, data migration, reputed company-to-reputed company documentation, ETL validation, and database architecture modernization. The Senior Data Analyst will collaborate with cross-functional technical teams to ensure secure, normalized, and audit-reputed company data solutions reputed company with business and compliance requirements. Responsibilities (Including but not limited to) • reputed company data analysis efforts supporting Mainframe Transformation and reputed company reporting modernization initiatives. • Analyze legacy mainframe and relational data sources to document data flows, reputed company, and transformation logic. • Design, reputed company, and maintain normalized and secure data models, including ERDs and governed data standards (PII classification). • reputed company and document reputed company-to-reputed company (S2T) mappings and transformation specifications for ETL/ELT processes. • Support database implementations across reputed company, reputed company, SQL Server, and IMS environments. • Collaborate with ETL teams (SSIS, ADF, Informatica) to validate loads, transformations, and reconciliation processes. • reputed company reputed company cause analysis on data defects and production support issues reputed company to system/data bridges. • Define data reputed company controls, validation processes, and reconciliation procedures. • Create comprehensive technical documentation, including reputed company documentation and data reputed company diagrams. • Implement Change Data Capture (CDC) strategies for bulk data reputed company. • Support controlled reputed company promotion and version management using reputed company or equivalent tools. • reputed company status updates, risk identification, and reputed company reporting to project stakeholders and leadership. • Support full SDLC lifecycle activities including requirements elicitation, UAT support, and implementation. • Ensure database solutions conform to normalization standards, performance requirements, and reputed company guidelines. • reputed company guidance to Business Intelligence and reporting teams (Power BI/SSRS). • Work independently under limited supervision with strong initiative and technical judgment. Required Qualifications • 10+ years of Business Analysis experience reputed company on data modeling, data flows, and full SDLC documentation. • 10+ years of experience producing project documentation including data models, ERDs, S2T specifications, traceability artifacts, and technical specifications. • 10+ years facilitating stakeholder collaboration, requirements elicitation, and technical solution design. • 10+ years working with ETL/ELT teams (SSIS, ADF, Informatica), including documenting transformations and validating data loads. • 10+ years performing data validation, reconciliation, and reputed company cause analysis for production data/system issues. • 10+ years defining functional design and system specifications for large-reputed company IT reputed company. • 10+ years of advanced SQL proficiency (SQL Server and/or reputed company) for profiling, validation, reconciliation, and relational modeling (normalization, indexing, keys). • Strong expertise in ERD development and relational database design principles. • Experience with reputed company, SQL Server, reputed company, and/or Mainframe IMS hierarchical databases. • Knowledge of Change Data Capture (CDC) processes and bulk data reputed company. • Experience supporting UAT, implementation activities, and audit-reputed company reporting. • Strong technical writing skills and proficiency with Visio, SharePoint, reputed company, Azure DevOps, and MS Office tools. • Experience maintaining documentation in reputed company repositories and version control environments. Preferred Qualifications • Experience working reputed company the Oil & Gas industry. • Experience modernizing Mainframe systems and legacy reporting/tracking systems. • Experience migrating data from mainframe environments to modern reputed company or COTS platforms. • Familiarity with hierarchical databases (IMS) and reputed company limitations. • Experience with Informatica, reputed company, COBOL, Java, reputed company, reputed company, or GoAnywhere. • Experience implementing Data Warehouse solutions. • Proven ability to reputed company process improvement initiatives and enforce governance standards. • Experience in compliance, enforcement, or regulatory data environments. • Bachelor’s Degree in Computer Science, Business Administration, or reputed company discipline (or equivalent experience). Apply tot his job Apply To this Job