Data Migration Lead
Redolent · Not specified · onsite · Posted 1d ago
Undisclosed3–9 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
KEY RESPONSIBILITIES:
We are seeking a Data Lead/Specialist to lead and execute data ETL from disparate sources (mainly Excel) to
Accolade (vendor PPM system) via templates.
The ideal candidate will have hands-on experience in data extraction, transformation, and loading (ETL), strong Excel
skills, proven ability to collaborate with Business stakeholders across timezones and external SaaS vendors and
knowledge and familiarity of Project/Programme Delivery/Governance metrics (e.g. plans, RAID, financials,
governance etc).
We are seeking a Data Lead/Specialist to lead and execute data ETL from disparate sources (mainly Excel) to
Accolade (vendor PPM system) via templates.
The ideal candidate will have hands-on experience in data extraction, transformation, and loading (ETL), strong Excel
skills, proven ability to collaborate with Business stakeholders across timezones and external SaaS vendors and
knowledge and familiarity of Project/Programme Delivery/Governance metrics (e.g. plans, RAID, financials,
governance etc).
The project is within a few weeks of the formal closure of the vendor sprint delivery cycle and finalisation of the data
upload templates. Work is underway to collate programme/project data attributes across target portfolios in excel and
map this to the fields in the vendor upload templates. We ll build a programmatic ETL for the conversion. The sources
for this are varied and fragmented. We anticipate there to be multiple iterative data loads and a phase for Dev (for
testing/PoC), CQA (for UAT) and phase by Programme for Prod.
upload templates. Work is underway to collate programme/project data attributes across target portfolios in excel and
map this to the fields in the vendor upload templates. We ll build a programmatic ETL for the conversion. The sources
for this are varied and fragmented. We anticipate there to be multiple iterative data loads and a phase for Dev (for
testing/PoC), CQA (for UAT) and phase by Programme for Prod.
Therefore, the requirement for a data specialist is as follows:
- Assimilate the work done so far and help co-develop it to cover mappings to templates pending
- Maintain the on-going changes /refinements to above which will be needed during data upload phase
- Add business logic validation to above
- Work with project/program teams to get data transformed to be complete and accurate (requires functional
knowledge of PPM concepts)
- Assist teams and trouble-shoot data validation issues in the tool
- Version & change control of ETL layers
- Assist teams with question during Dev/CQA upload
- Perform periodic Dev/CQA/Prod uploads
- Data-centric support during Prod and hypercare period
- Maintain the on-going changes /refinements to above which will be needed during data upload phase
- Add business logic validation to above
- Work with project/program teams to get data transformed to be complete and accurate (requires functional
knowledge of PPM concepts)
- Assist teams and trouble-shoot data validation issues in the tool
- Version & change control of ETL layers
- Assist teams with question during Dev/CQA upload
- Perform periodic Dev/CQA/Prod uploads
- Data-centric support during Prod and hypercare period
REQUIRED SKILLS
Strong technical expertise in Excel (Power Query, pivot tables, advanced formulas).
Exposure to Powershell is recommended but not mandated.
Familiarity with ETL concepts and tools.
Excellent problem-solving and stakeholder communication skills.
Strong technical expertise in Excel (Power Query, pivot tables, advanced formulas).
Exposure to Powershell is recommended but not mandated.
Familiarity with ETL concepts and tools.
Excellent problem-solving and stakeholder communication skills.
JOB TITLE: Data Lead/Specialist
EXPERIENCE: 10+ year of data/migrations
EXPERIENCE: 10+ year of data/migrations
ADDITIONAL INFORMATION:
Alignment to UK working hours.
Confirmation that being assigned to the project will negate any requirement for the colleague to attend
Cognizant offices.
Alignment to UK working hours.
Confirmation that being assigned to the project will negate any requirement for the colleague to attend
Cognizant offices.
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Skills
querydata extractioncqaTroubleshootingvendorData MigrationPPMexcelData ValidationPowershell