16 Sep
Senior Data Analyst
New York, Brooklyn , 11201 Brooklyn USA

Vacancy expired!

Direct End Client: City of New YorkJob Title: Senior Data AnalystDuration: 5 YearsNo. of Hours Per Week: 40 Hours Per WeekStart Date: 01/01/2022Location: 335 Adams Street, Suite 2300, Brooklyn, NY 11201Position Type: ContractInterview Type: In-Person InterviewRequirement ID: NYCDA021BR Description: New York City Employees’ Retirement System (“NYCERS”) NYCERS seeks one (1) Senior Data Analyst to work with the Information Technology (IT)Division for a period up to 60 months. The Senior Data Analyst will primarily be responsible for detailed field level analysis, profiling, and mapping of the currentIBM Mainframe VSAM files loaded into SQL tables. The Senior Data Analyst will create and maintain the master data dictionary and mapping to NYCERS mission critical applications and inventory of its components. The Senior Data Analyst shall provide NYCERS’ Data Management team with technicalexpertise for the completion of Data Profiling/ Cleansing and Conversion/ Migration efforts part of ongoing Legacy Replacement initiative. Mandatory Experience:Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments.Hands-on MS Access programming (Macros, VBA, etc.).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. Preferred Experience:Experience extracting business rules from the existing legacy code.Experience with Data Quality/ Profiling tools.Experience with Data Warehouses/ Data Marts.Hands-on Experience with SSRS or SSIS. Mandatory Technical Ability:Excellent analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities.Strong SQL knowledge working with complex queries and stored procedures.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.Understanding of data structures and their relationship to ETL applications. Tasks and Deliverables:The Senior Data Analyst shall provide NYCERS’ Data Management with technical expertise for the completion of Data Quality, Data Profiling and Data Cleansing effort 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 SMEs to document data quality rules and definitions.Extract business rules from the existing Legacy code and create Source-to-Target mappings.Transform business 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. V Group Inc. is an IT Services company which supplies IT staffing, project management, and delivery services in software, network, help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: NY, NJ, PA, MD, NC, SC, GA, FL, CA, DE, IL, MI, OH, OR, TX, VA, and WA. If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant. Please share my contact information with others working in Information Technology. Website: www.vgroupinc.comLinkedIn: www.linkedin.com/company/v-group/Facebook: www.facebook.com/VGroupITTwitter: www.twitter.com/vgroupinc

Vacancy expired!


Related jobs

Report job