Data Analyst
Summary This position is a blend of IT and PM skills.
Must understand the design and architecture (doesn't need to be an SME).
Definite understanding of UI, dataflow, mapping, nuances of data, must have leadership skills, it's a matrix environment, very good communication skills, must be proactive, take this as your own business, keep people together.
Banking experience is a must.
BSA AML and Sanctions is preferred.
Must have some engineering, computer science background.
70% of the work is data mapping and 30% is functional.
Project Deliverables:
Data and Impact Analysis Documentation and analysis of the data linkages from Systems of Records (SoRs) to downstream systems.
The following features will be identified and documented for each Key Data Item (KDI) and associated items:
Analyze large datasets and perform impact analysis of identified issues.
Work with Impacted Systems to analyze ETL code and perform root cause analysis of issues Document findings and prepare analysis presentations for stakeholders Database schema and file specifications of SoRs and downstream systems Data mapping and ETL logic from SoRs to downstream systems, including any and all intermediary systems Filtering and transformation logic Record counts Scheduling jobs and configurations Risk & Compliance Application:
Understand the requirements and approach for Risk & Compliance application projects and work with the customer on the design, development, and testing and deployment phases as defined by the ITPD process.
Responsibilities:
Planning Engage potentially impacted system/application managers based on the BRD Requirements, DRD and KDE candidates Drive to gather system/application attributes on each potentially impacted system with a custom Questionnaire/survey.
Drive to gather current state data mapping for each systems Drive to gather data/file attributes for each system Drive collaboration with the Enterprise Architect for delivery of an approved Architecture Solution Document (ASD) Create an high-level dataflow or wireframe diagram for use during our initial engagement with all the system/application leads and Technology Stakeholders Create and merge DRD, file attribute and current state data-mapping into workbook.
Create ISA Work Breakdown Structure and merge with PM WBS when feasible Design Create Functional Design Document - FDD, Data Sourcing Request (DSR), Detailed Design Document - DDD Drive to gather inputs from all impacted system/application leads Update high-level dataflow or wireframe diagram Drive to identify all KDE candidates per system/application with system/application leads and document accordingly Drive to solution design of inputs from all impacted system/application leads on consolidated Methodology approach Consolidated list of conventions and standards to be followed by all system/application leads Collaborate with each all system/application leads to drive produce future state lineage/dataflow/datamapping Drive for collaboration on all common rules, coding and routines for all systems/applications Development Drive to complete ALL Development ITPD docs.
When needed - complete the Deliverables.
Drive for on-time, certifiable delivery of application developing (coding) of all required functionality set forth in the BRD, FDD and DDD for all systems/applications from all system managers and technology leads.
(See checklist for additional details) Drive for on-time, certifiable testing of application developing (coding) of all required functionality set forth in the BRD, FDD and DDD for all systems/applications from all system managers and technology leads.
(See checklist for details regarding defect management) Drive for on-time, certifiable delivery of Infrastructure for all required functionality set forth in the BRD, FDD and DDD for all systems/applications from all system managers and technology leads.
Unit testing Testing Drive to complete ALL Testing EPLC docs.
When needed - complete the Deliverables System Integration Test - Support data loads, Defect remediation User Acceptance Test - Support data loads, Defect remediation Dress Rehearsal Test - Defect remediation Test Deliverables Implementation Change management process Deployment task Deployment deliverables Deployment validation Data Migration and validation Post production load validation If interested, please contact Margot Parsons at mparsons@genuent.
com or call 714-465-5478 #LI-MP1.
Estimated Salary: $20 to $28 per hour based on qualifications.
Must understand the design and architecture (doesn't need to be an SME).
Definite understanding of UI, dataflow, mapping, nuances of data, must have leadership skills, it's a matrix environment, very good communication skills, must be proactive, take this as your own business, keep people together.
Banking experience is a must.
BSA AML and Sanctions is preferred.
Must have some engineering, computer science background.
70% of the work is data mapping and 30% is functional.
Project Deliverables:
Data and Impact Analysis Documentation and analysis of the data linkages from Systems of Records (SoRs) to downstream systems.
The following features will be identified and documented for each Key Data Item (KDI) and associated items:
Analyze large datasets and perform impact analysis of identified issues.
Work with Impacted Systems to analyze ETL code and perform root cause analysis of issues Document findings and prepare analysis presentations for stakeholders Database schema and file specifications of SoRs and downstream systems Data mapping and ETL logic from SoRs to downstream systems, including any and all intermediary systems Filtering and transformation logic Record counts Scheduling jobs and configurations Risk & Compliance Application:
Understand the requirements and approach for Risk & Compliance application projects and work with the customer on the design, development, and testing and deployment phases as defined by the ITPD process.
Responsibilities:
Planning Engage potentially impacted system/application managers based on the BRD Requirements, DRD and KDE candidates Drive to gather system/application attributes on each potentially impacted system with a custom Questionnaire/survey.
Drive to gather current state data mapping for each systems Drive to gather data/file attributes for each system Drive collaboration with the Enterprise Architect for delivery of an approved Architecture Solution Document (ASD) Create an high-level dataflow or wireframe diagram for use during our initial engagement with all the system/application leads and Technology Stakeholders Create and merge DRD, file attribute and current state data-mapping into workbook.
Create ISA Work Breakdown Structure and merge with PM WBS when feasible Design Create Functional Design Document - FDD, Data Sourcing Request (DSR), Detailed Design Document - DDD Drive to gather inputs from all impacted system/application leads Update high-level dataflow or wireframe diagram Drive to identify all KDE candidates per system/application with system/application leads and document accordingly Drive to solution design of inputs from all impacted system/application leads on consolidated Methodology approach Consolidated list of conventions and standards to be followed by all system/application leads Collaborate with each all system/application leads to drive produce future state lineage/dataflow/datamapping Drive for collaboration on all common rules, coding and routines for all systems/applications Development Drive to complete ALL Development ITPD docs.
When needed - complete the Deliverables.
Drive for on-time, certifiable delivery of application developing (coding) of all required functionality set forth in the BRD, FDD and DDD for all systems/applications from all system managers and technology leads.
(See checklist for additional details) Drive for on-time, certifiable testing of application developing (coding) of all required functionality set forth in the BRD, FDD and DDD for all systems/applications from all system managers and technology leads.
(See checklist for details regarding defect management) Drive for on-time, certifiable delivery of Infrastructure for all required functionality set forth in the BRD, FDD and DDD for all systems/applications from all system managers and technology leads.
Unit testing Testing Drive to complete ALL Testing EPLC docs.
When needed - complete the Deliverables System Integration Test - Support data loads, Defect remediation User Acceptance Test - Support data loads, Defect remediation Dress Rehearsal Test - Defect remediation Test Deliverables Implementation Change management process Deployment task Deployment deliverables Deployment validation Data Migration and validation Post production load validation If interested, please contact Margot Parsons at mparsons@genuent.
com or call 714-465-5478 #LI-MP1.
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
