CyberTec
Senior Data Analyst Hybrid
CyberTec, New York, New York, us, 10261
Job Title : Senior Data Analyst - Hybrid ( Only Local )Location: Suite 2300 Brooklyn, NY,11201Job Type : HybridDuration : 72 monthsOpening : 1 Opening !
The Senior Data Analyst will primarily be responsible for detailed field level analysis, profiling, metadata analysis and mapping of the current IBM Mainframe VSAM files into relational/dimensional SQL tables, create and maintain the master data dictionary, assist in database design and mapping to NYCERS mission critical applications and inventory of its components.
The Senior Data Analyst shall provide NYCERS' Data Management with technical expertise for the completion of Data Quality, Data Profiling and Data Cleansing efforts part of Legacy Replacement initiative, as well as NYCERS' ongoing process improvement programs.
RESPONSIBILITIES
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 processesExtract 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.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.MANDATORY SKILLS
Note: Candidates who do not have the mandatory skills will not be considered
Minimum 5 years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments.Hands-on IBM DataStage ETL administration experience in Windows environment.Hands-on experience with SQL Server Reporting Services (SSRS) platform.Hands-on experience with IBM RAA (Rational Asset Analyzer).Experience creating data dictionary documentation with business terms, valid values, and definitions.Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases .Minimum 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, Build and CICD pipeline automation.Minimum 3 years of recent experience with Pension Administration systemsExcellent analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities.Strong SQL knowledge working with complex queries and stored procedures.Proficiency in LINUX/UNIX Shell scripting, C#, and VB.NETProficiency in SSRS reports' development and administration.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 and CICS.Proficiency creating Control-M Jobs, Smart Folders, Schedules with complex interdependencies.Understanding of data structures and their relationship to ETL applications
PREFERRED SKILLS
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 Integration Services (SSIS)Prior experience working in a pension system, preferably New York State or New York City pension system
The Senior Data Analyst will primarily be responsible for detailed field level analysis, profiling, metadata analysis and mapping of the current IBM Mainframe VSAM files into relational/dimensional SQL tables, create and maintain the master data dictionary, assist in database design and mapping to NYCERS mission critical applications and inventory of its components.
The Senior Data Analyst shall provide NYCERS' Data Management with technical expertise for the completion of Data Quality, Data Profiling and Data Cleansing efforts part of Legacy Replacement initiative, as well as NYCERS' ongoing process improvement programs.
RESPONSIBILITIES
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 processesExtract 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.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.MANDATORY SKILLS
Note: Candidates who do not have the mandatory skills will not be considered
Minimum 5 years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments.Hands-on IBM DataStage ETL administration experience in Windows environment.Hands-on experience with SQL Server Reporting Services (SSRS) platform.Hands-on experience with IBM RAA (Rational Asset Analyzer).Experience creating data dictionary documentation with business terms, valid values, and definitions.Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases .Minimum 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, Build and CICD pipeline automation.Minimum 3 years of recent experience with Pension Administration systemsExcellent analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities.Strong SQL knowledge working with complex queries and stored procedures.Proficiency in LINUX/UNIX Shell scripting, C#, and VB.NETProficiency in SSRS reports' development and administration.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 and CICS.Proficiency creating Control-M Jobs, Smart Folders, Schedules with complex interdependencies.Understanding of data structures and their relationship to ETL applications
PREFERRED SKILLS
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 Integration Services (SSIS)Prior experience working in a pension system, preferably New York State or New York City pension system