Senior Data Analyst with Retirement or Pension Industry Experience

Mandatory Skills/Experience • Minimum of five (10) 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 : • 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.