What are the responsibilities and job description for the Senior Data Analyst with Retirement or Pension industry experience position at Baanyan Software Services, Inc.?
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.