Back to jobs

Contract Lead Data Engineer

Job description

Role: Contract Lead Data Engineer

Length: 6 Months

Location: Cardiff (Mainly remote)

Rate: Negotiable

IR35 Status: Outside

Our client is looking for a Contract Lead Data Engineer to assist them on an ongoing project for an initial 6-month period.

Milestones within the contract:

  1. Months 1 & 2 - Database schema design complete, dev and prod DB's productionised
  2. Months 3 & 4 - ETL abstraction layer implemented, all dataflows complete
  3. Month 5 - sematic models build and available for reporting
  4. Month 6 - support with presentation layer build

Tasks that will be undertaken during the contract:

  1. Review job stories and refactor requirement statements where unclear
  2. Confirm high level solution design
  3. Coordinate with central IT to establish dev and production environments
  4. Create database project
  5. Create database schema
  6. Implement source control via GitHub
  7. Design ETL packages
  8. Design tabular semantic models
  9. Implement dataflows
  10. Merge data from legacy sources into new Datawarehouse solution
  11. Implement process auditing e.g., tracking job completion, notifying team of dataflow errors etc

Skills and experience required:

  • MS SQL 2016 or higher
  • SQL Server Integration Services
  • SQL Server Analysis Services - tabular
  • GitHub
  • DAX
  • R or Python
  • SSDT 2017 or Visual Studio equivalent