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 time-zones 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 diverse 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
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.
Additional Information:
- Alignment to UK working hours.
📌 Data Lead/Specialist (India)
🏢 9NEXUS
📍 India