Work Location: Brooklyn NY 11201 Hybrid schedule combining in office 3 days and 2 days remote workday

Scheduled Work Hours: Monday through Friday 40 hours per week 8:00 AM 4:45 PM EST

Scope of Services:

Client seeks Senior Data Analyst with ETL expertise to work with the Information Technology (IT) Division .

• 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 the 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 working in accordance with client policies in effect for the duration of the project.

Mandatory Skills/Experience

Experience Mandatory:

• 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 technique troubleshooting abilities.

The following deliverables shall apply:

• Participate in identification, inventory, and classification of CLIENT critical data.
• Work with data SME’s to document data quality rules and definitions.
• Actively participate in optimization and performance tuning of existing ETL and SQL processes.
• Extract business rules from the existing Legacy code and create Source-to-Target mappings.
• Transform business rules and data quality rules into ETL and/or SQL technical specifications.
• Develop complex SQL data validations based on STTMs and target Data Models.
• Provide technical and analytical support to 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.
• Defect handling and problem resolution.

Desirable Skills/Experience

• Experience extracting business rules from the existing legacy code.
• Experience with Data Quality/Profiling tools.
• Experience with Data Warehouses/Data Marts.
• Experience with SQL Server Reporting Services (SSRS).
• Prior experience working in a pension system, preferably New York State or New York City pension system.