Job Description
Business Analyst Technical Lead
Looking for hands on Lead Business Analyst with at least 6 years of relevant experience.
Excellent communication and customer facing skills
Experienced in working in onshore/offshore model
Experienced in Agile program execution
Should be flexible to work in EST timezone
Extract/Source:
Analysis of source system in support of the collection of cleansing requirements for each source system with the technical and business system owners
Document data cleansing process and rules for cleansing source systems
Monitor cleansing activity for each in scope source migration system based on the data object supported and business requirements.
Support/Facilitate the source to target mapping of legacy data.
Take ownership of the source to target mapping file and maintain it in conjunction with the functional consultants and general target requirements.
Identify any additional requirements on the source side to support a load to SV such as data enrichment, harmonization, rationalization etc.
Help the source system owners define the active data set required for the migration by providing extraction rules that are documents and kept up to date.
Review the final data extract and verify that it is complete and fit for purpose.
Additional related tasks as required to support the delivery of source data for the migration.
Transform:
Ensure the delivery of extracted data onto the identified data migration staging area based on the agreed data extraction rules.
Work with markets and functional experts to ensure mapping rules and logic are documented, up to date and complete for each object in scope of the migration.
Ensure that each transformed file is accurate and complete based on the target structure and data design required to be loaded.
Take ownership in making sure all transformation issues are resolved by working with the technical transformation developer, CSG functional experts and local markets as needed/ required.
Work with the technical migration resource to develop, maintain and make updates to the ETL transformation code/load files as required.
Define any additional transformation requirement that needs to be performed on the active migration data set as required to support the load to the target model.
Ensure ETL unit testing is complete
Maintain and update mapping documents are required.
Provide migration issue resolution based on Unit, SIT, E2E, UAT testing cycles
Additional related tasks as required to support the delivery of transformed data for the migration.
Load:
Support CSG teams with any load issues as a result of load testing.
Ensure the delivery of target data to CSG based on the detail data migration plan.
Act as SPOC with the CSG team and business on any data related issues that require business input or decision to be made.
Review load error logs and provide triage and resolution/fix to support any load errors.
Provide source system data support where required across data cleansing activity impacting the data load.
Co-ordinate and facilitate the inclusion of data owners in the data validation exercise.
Support in the data validation activity where required and drive the process along with CSG functional owners.
Additional related tasks as required to support the delivery remediation off load data for the migration.