Senior Data Analyst

NOTE: on-site and/or remote working in accordance with client's policies in effect for the duration of the project.

SCOPE OF SERVICES

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 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.
• 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/EXPERIENCE:

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 systems
• Excellent 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.NET
• Proficiency 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.
  

If you are interested in getting more information about this opportunity, please contact Irina Rozenberg, Recruiting@arielpartners.com at your earliest convenience.

At Ariel Partners, we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions, so when they have their biggest challenges, we are on their short list. We are looking for team members who share our values of: Integrity to do the right thing even when it hurts; Commitment to the long-term success and happiness of our customers, our people, and our partners; Courage to take on difficult challenges, accept new ideas, and accept incremental failure; and the constant pursuit of Excellence. Ariel Partners is an Equal Opportunity Employer in accordance with federal, state, and local laws.