Data Analyst

Job Title: Data Analyst

Location: Remote

Duration: 11 Months + Extension

Bill Rate: $80/hr

Job Type: W2 Contract

Client: To Be Discussed Later

Work Authorization: US-Citizen, H-1B, OPT-EAD, GC-EAD

Job Description

• Perform detailed field-level analysis of VSAM files.
• Conduct metadata analysis and data profiling.
• Map VSAM files into relational and dimensional SQL tables.
• Support conversion and validation efforts for the enterprise-wide Legacy Replacement program.
• Create and maintain the master data dictionary.
• Assist with database design for mission-critical applications.
• Maintain an inventory of application components.
• Collaborate with the Information Technology (IT) Division on data analysis and modernization efforts.

Mandatory Requirements:

• 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.

Technical Ability Mandatory:

• 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 DB2.
• Understanding 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 technical troubleshooting abilities.
  
  Equal Opportunity Employer: We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.