Job Description
Senior Data Analyst – Mainframe & Reporting Modernization
Location: Remote (Texas Preferred)
This role supports large-scale technology modernization initiatives for legacy Mainframe and enterprise reporting systems within a regulatory environment. The position is highly data-centric, focusing on data modeling, data migration, source-to-target documentation, ETL validation, and database architecture modernization. The Senior Data Analyst will collaborate with cross-functional technical teams to ensure secure, normalized, and audit-ready data solutions aligned with business and compliance requirements.
- Responsibilities(Including but not limited to)
- Lead data analysis efforts supporting Mainframe Transformation and enterprise reporting modernization initiatives.
- Analyze legacy mainframe and relational data sources to document data flows, lineage, and transformation logic.
- Design, develop, and maintain normalized and secure data models, including ERDs and governed data standards (PII classification).
- Develop and document Source-to-Target (S2T) mappings and transformation specifications for ETL/ELT processes.
- Support database implementations across Oracle, Snowflake, SQL Server, and IMS environments.
- Collaborate with ETL teams (SSIS, ADF, Informatica) to validate loads, transformations, and reconciliation processes.
- Perform root cause analysis on data defects and production support issues related to system/data bridges.
- Define data quality controls, validation processes, and reconciliation procedures.
- Create comprehensive technical documentation, including interface documentation and data flow diagrams.
- Implement Change Data Capture (CDC) strategies for bulk data movement.
- Support controlled code promotion and version management using GitHub or equivalent tools.
- Provide status updates, risk identification, and progress 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 security guidelines.
- Provide 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 focused 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 root cause analysis for production data/system issues.
- 10+ years defining functional design and system specifications for large-scale IT projects.
- 10+ years of advanced SQL proficiency (SQL Server and/or Oracle) for profiling, validation, reconciliation, and relational modeling (normalization, indexing, keys).
- Strong expertise in ERD development and relational database design principles.
- Experience with Oracle, SQL Server, Snowflake, and/or Mainframe IMS hierarchical databases.
- Knowledge of Change Data Capture (CDC) processes and bulk data movement.
- Experience supporting UAT, implementation activities, and audit-ready reporting.
- Strong technical writing skills and proficiency with Visio, SharePoint, Confluence, Azure DevOps, and MS Office tools.
- Experience maintaining documentation in structured repositories and version control environments.
- Preferred Qualifications
- Experience working within the Oil & Gas industry.
- Experience modernizing Mainframe systems and legacy reporting/tracking systems.
- Experience migrating data from mainframe environments to modern SaaS or COTS platforms.
- Familiarity with hierarchical databases (IMS) and legacy system limitations.
- Experience with Informatica, MuleSoft, COBOL, Java, Salesforce, Snowflake, or GoAnywhere.
- Experience implementing Data Warehouse solutions.
- Proven ability to lead process improvement initiatives and enforce governance standards.
- Experience in compliance, enforcement, or regulatory data environments.
- Bachelor’s Degree in Computer Science, Business Administration, or related discipline (or equivalent experience).
Apply Now
Apply Now