Senior Data Analyst
- Steneral
6 Days Ago
NA
C2C, 1099
New York-NY
6-10 Years
Required Skills: SQL distributed databases, IBM DataStage ETL
Job Description
Scope of Services:
NYCERS seeks one (1) Senior Data Analyst with ETL expertise to work with the Information Technology (IT) Division . The Senior Data Analyst will primarily be responsible for detailed field level analysis, metadata analysis, profiling, and mapping of VSAM files into relational/dimensional SQL tables as well as conversion/validation efforts as part of the enterprise-wide Legacy Replacement program. The Senior Data Analyst must be available to work a minimum of 40 hours per week, and will be subject to onsite and/or remote working in accordance with NYCERS policies in effect for the duration of the project.
Mandatory Skills/Experience
- Experience Mandatory:
- 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 technique troubleshooting abilities.
- Assumptions Regarding Consultant Tasks and Deliverables
The Senior Data Analyst shall provide NYCERS’ 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 NYCERS’ ongoing process improvement programs.
The following deliverables shall apply:
- Participate in identification, inventory, and classification of NYCERS 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 NYCERS 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.
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.
