Lead Business Analyst Jobs

Title: Lead Business Analyst

Location: Ontario, Canada(Remote)

Duration: Fulltime

About:

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.