Data Analyst

1. Mandatory Skills: Candidate must meet all the requirements below to be considered for the for this position:

• Must have excellent interpersonal, communication, presentation, writing, analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities.

• Ability to facilitate sessions and one-on-one meetings with developers and managers, meet deadlines, and work well under pressure.

• Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe, relational database and object storage environment.

• Experience creating data dictionary documentation and data definitions/domains.

• Experience mapping/converting VSAM data to SQL databases and object relational databases.

• Experience extracting field references and calculated data from COBOL programs.

• Understanding of data structures and their relationship to applications.

• Ability to work in multiple development environments or systems: IBM Mainframe, Windows Server and SQL Server.

• Experience extracting field references from C# and Java application code.

2. Preferred Experience:

• Experience with legacy and unstructured data.

• Experience with ETL and Data Quality/Profiling tools. 5

• Experience extracting business rules from the existing legacy code.

• Experience creating automated inventory of mainframe components.

• Experience with MS Visual Studio and .NET.

3. Assumptions Regarding Consultant Tasks and Deliverables

The Data Analyst shall provide ’ Data Management with technical expertise for the completion of Data Quality, Data Profiling and Data Cleansing effort as well as ongoing process improvement programs.

The following deliverables shall apply:

• Participate in identification, inventory, and classification of critical data

• Work with data SME’s to document data quality rules and definitions

• Transform business rules into technical specifications to cleanse the data prior to the migration

• Provide technical and analytical support to data integrity and quality initiatives

• Collaborate with data 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.

Job Type: Contract

Salary: $45.00 /hour

Required experience:

• Data Analysis: 5 years
• VSE: 5 years