Senior Data Analyst

Role: Senior Data Analyst Location: Brooklyn, NY (Hybrid) Duration: Long Term Scope Of Services The Senior Data Analyst shall provide Client s Data Management team with technical expertise for the completion of Data Profiling/Cleansing, Conversion/Migration and Validation efforts part Legacy Replacement initiative as well as client s ongoing process improvement programs. Responsibilities • 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. Mandatory Skills/Experience • 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. 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.