What are the responsibilities and job description for the Mainframe Data Analyst position at Spruce Technology Inc.?
Title: Sr. Data Analyst
Location: Brooklyn NY (Hybrid: 2/3 days onsite)
Long term
Mandatory Requirements:
- 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.
- 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.
All full-time employees are eligible for the following benefits:
Medical, dental, vision health benefits
Life Insurance and AD&D (paid by company)
401k, Flexible and Dependent Care Spending Account plans.
Paid-time Off or Paid Sick Leave (amount dependent on position level and if required by state).