Senior Data Analyst

260706\-2**Duration:** 12 Months, extension possible based on needs and performance**Job Title:** Senior Data Analyst**Job Summary:** **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. **Skills: Data Analyst, SQL, Pension system, SSRS, VSAM, BMCLocation:** Brooklyn, NY 11201 Need Local Candidates, and 3 references are required pension/retirement Experience **Salary Range:** $55/hr Pay: $50\.00 \- $55\.00 per hour Application Question(s): * USC CANDIDATES ARE ELIGIBLE Work Location: Hybrid remote in Brooklyn, NY 11201