Business Data Analyst - Charlotte, NC

23 Jun 2024

Vacancy expired!

DTS is looking for Business Data Analyst

for a long term contract with our direct client Position in Charlotte, NC.

Position DescriptionThe Business Data Migration Analyst plays a pivotal role in the strategic program which is modernizing key Information Technology systems and building the foundation that drives business transformation, while maintaining the integrity of data. The Analyst will drive through the data management needs of migration and data merge activities to ascertain the source data is transferred correctly, properly tested and accurately reflected in the target application and the original data in the target application remains unencumbered.

Job Responsibilities
  • Write SQL code in Oracle to complete comparative analysis of data from source to target to identify data integrity or conversion issues.
  • Analyze current-state solutions, primarily SQL and UI review of the legacy system and target application data to recommend target-state, remediation solutions.
  • Deliver support of the converted and merged date to enable customers to self-serve.
  • Become a subject matter expert by combining technical knowledge and business acumen, to creatively share the completion of the migration cycles and current status of the data. Explain the results with every day terms rather than technical terms.
  • Deliver quantity and quality results within established timeline; leverage developed SQL reporting to complete comparative analysis between the source and target data in the migration space.
  • Produce test cases; and execute tests within planned schedules (currently monthly, but cycles may increase) for the program deliverables; research test results when defects/bugs are found to help pinpoint root cause of data differences.
  • Develop and test data, complete data analysis, reporting, and analytics solutions, often ad hoc to ascertain the data meets business stakeholder requirements.
  • Work with IT mainframe team to complete data validation / conversion of source data.
  • Navigate through research of source data fields and profiling to provide recommendations for data governance updates.
  • Research and develop various data clean-up strategies, data mapping documents, data migration documentation to support the movement of data for governance and controls.
  • Enhance

    Power BI reporting to support the migration data validation results.
  • Develop reporting to support merge of migrated data in multiple phases and review/analyze the data the migrated data will be merged into to provide evidence of successful migrations.

Qualifications
  • Excellent

    Oracle SQL Developer skills is a must with at least 3 years of experience.
  • Writing and execution of test cases leveraging qTest is preferred.
  • Experience with migration of data from a legacy system to a HTML application with tables and User Interface (UI) is preferred.
  • At least 3 years of experience with Business Intelligence technologies such as Power BI.
  • Experience conducting data analysis and Financial Services or Banking working knowledge is desired.
  • Understanding of mainframe data conversions.
  • Is capable of quickly learning legacy systems and data, transformation of data and UI for each to maintain the current migration cycles to

    write tests, write SQL, execute tests, review results of migration cycles, write summary reports and present data results.
  • Excellence at test throughput and reporting.
  • Is able to participate in demonstrations of the migrated data after completion of UI validation.

Desired Skills
  • Develop automated test cases, reporting and uploads to qTest.
  • Willingness to travel to support deployment and operation resource activities.

Contact:

Kuldeep Singh

Digital Technology Solutions

  • ID: #43554656
  • State: North Carolina Charlotte 28202 Charlotte USA
  • City: Charlotte
  • Salary: DoE
  • Job type: Contract
  • Showed: 2022-06-23
  • Deadline: 2022-08-21
  • Category: Et cetera