Note : Visa- ANY *Please don’t submit less than 10+ years of consultant* PLEASE INCLUDE RATE VISA CONTACT LOCATION ===============
04232021 Job Title: Senior Data Analyst Client: NYCERS Work Location: Brooklyn, NY Scheduled Work Hours: 40 hours/week Assignment Start Date: Immediate start Duration of Contract: 48 months Due Date:4/20/21; 5:00PM Interview Type Requested: In person, WebEx or Skype Rate: $70 on C2C or 1099 Job Description: The Sr. Data Analyst will primarily be responsible for detailed field level analysis, profiling, and mapping of the current IBM Mainframe VSAM files loaded into SQL tables. The Data Analyst will create and maintain the master data dictionary and mapping to client's mission critical applications and inventory of its components. Scope of Services: The Data Analyst shall provide client’s Data Management team with technical expertise for the completion of Data Profiling/Cleansing and Conversion/Migration efforts part of ongoing Legacy Replacement initiative. 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. 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. Mandatory Skill: Must have excellent analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities. 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. Proficiency in mainframe applications encompassing COBOL and CICS. Strong SQL knowledge working with complex queries and stored procedures. Understanding of data structures and their relationship to ETL applications. Ability to work in multiple environments: IBM Mainframe, Windows Server, and SQL Server. Strong analytical skills demonstrated by the ability to receive and analyze requirements and propose a suitable solution that adheres to the team’s methodology. Desirable Skill: Experience with Data Quality/Profiling tools. Experience extracting business rules from the existing legacy code. Experience with Data Warehouses / Data Marts. -- You received this message because you are subscribed to the Google Groups "Android Discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/android-discuss/CABexGQGKT7Nfu2Br2UbRckyVa1oLRszAiznkShQBf9FSO6uLHQ%40mail.gmail.com.
