[Remote] Senior COBOL / Mainframe Data Analyst

Note: The job is a remote job and is open to candidates in USA. All IT Solutions is a technology and workforce solutions company serving government and commercial organizations. The company is seeking a Senior COBOL / Mainframe Analyst to support an enterprise-wide Legacy Replacement program through data analysis, VSAM-to-SQL mapping, conversion, validation, and data quality initiatives. Responsibilities • The Senior Data Analyst will primarily be responsible for detailed field level analysis, metadata analysis, profiling, and mapping of VSAM files into relational/dimensional SQL tables as well as conversion/validation efforts as part of an enterprise-wide Legacy Replacement program • The Senior Data Analyst must be available to work a minimum of 40 hours per week and will be subject to onsite and /or remote work in accordance with our client policies in effect for the duration of the project • Develop complex SQL data validations based on STTMs and target Data Models • Provide technical and analytical support to our client data integrity and quality initiatives • Collaborate with SME’s and technical leads in identifying and addressing data quality gaps • Work with IT partners to remediate identified gaps using both manual and automated solutions • Support processes that proactively detect, correct, and prevent invalid data values Skills • Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments • Experience creating data dictionary documentation with business terms, valid values, and definitions • Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases • Minimum of three (3) years of recent experience developing applications using IBM DataStage ETL • Experience extracting field references and calculated data from COBOL programs • Experience with BMC Control-M workload automation software • Experience with GIT version control software • Minimum of three (3) years of recent experience with Pension Administration systems • Strong SQL knowledge working with complex queries and stored procedures • Proficiency in SSRS reports' development • Strong analytical skills demonstrated by the ability to receive and analyze requirements and propose a suitable solution that adheres to the team's methodology • Ability to work in multiple environments: IBM Mainframe, Windows Server, and SQL Server • Proficiency in mainframe applications encompassing COBOL, CICS and DB2Understanding of data structures and their relationship to ETL applications • Ability to develop complex SQL data validations based on STTMs and target Data Models • Excellent analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities Benefits • Onsite and/or remote work in accordance with client policies for the duration of the project Company Overview • All IT Solutions offers IT consulting, networking, website, and mobile app development services. It was founded in 2018, and is headquartered in Mount Laurel, New Jersey, USA, with a workforce of 11-50 employees. Its website is https://allitsolutions.us. Company H1B Sponsorship • All IT Solutions has a track record of offering H1B sponsorships, with 1 in 2025, 1 in 2024. Please note that this does not guarantee sponsorship for this specific role.