Senior Data Analyst with Pension/Retirement::Need locals to NY/NJ

The Senior Data Analyst shall provide the Client's Data Management team with technical expertise for the completion of Data Profiling/Cleansing, Conversion/Migration, and Validation efforts as part of the Legacy Replacement initiative, as well as ongoing process improvement programs.

• Prior experience working in a pension system is required, preferably a New York State or New York City pension system.

The following deliverables shall apply:

• Participate in identification, inventory, and classification of critical data.
• Work with data SMEs to document data quality rules and definitions.
• Actively participate in optimization and performance tuning of existing ETL and SQL processes.
• Extract business rules from 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 the Client's data integrity and quality initiatives.
• Collaborate with SMEs 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.
• Handle defects and provide problem resolution.

• Experience extracting business rules from existing legacy code.
• Experience with Data Quality/Profiling tools.
• Experience with Data Warehouses/Data Marts.
• Experience with SQL Server Reporting Services (SSRS).
•