ETL Developer (Talend)

  • Job Reference: HQ00009205
  • Date Posted: 23 November 2017
  • Recruiter: E-Resourcing
  • Location: South West London
  • Salary: £45,000 to £50,000
  • Sector: IT (general)
  • Job Type: Permanent
  • Work Hours: Full Time

Job Description

ETL DEVELOPER

Job​ ​Title: ​ ​ETL Developer (Tableau, Talend)

Department: ​ ​Business​ ​Intelligence

Reports​ ​to: ​ ​Business​ ​Intelligence​ ​PM/Head

My client is ​looking​ ​for​ ​an​ ​experienced​ ​BI​ ​Analyst / ETL Developer​ (with​ ​experience​ ​of Tableau​ ​and​ ​Talend)​ ​to join​ ​their​ ​new​ ​Business Intelligence/Analytics​ ​team. You​ ​will​ ​be​ ​working​ ​on​ ​an​ ​exciting​ ​Greenfield​ ​BI​ ​project​ ​and​ ​will​ ​be​ ​responsible​ ​for developing​ ​applications​ ​and​ ​processes​ ​that​ ​are​ ​required​ ​to extract, ​ ​transform, ​ ​cleanse, ​ ​and​ ​manage​ ​data​ ​and​ ​metadata​ ​to​ ​be​ ​loaded​ ​into​ ​a​ ​data warehouse, ​ ​data​ ​mart,​ ​or​ ​data​ ​lake.

Tableau / Talend

Main​ ​Responsibilities:

  • Works​ ​with​ ​Head​ ​of​ ​BI​ ​and​ ​Technical​ ​Lead​ ​to​ ​understand​ ​solution​ ​vision​ ​and​ ​create data​ ​integration​ ​design
  • Designs, ​ ​develops,​ ​automates,​ ​and​ ​supports​ ​complex​ ​applications​ ​to​ ​extract, transform,​ ​and​ ​load​ ​data​ ​from​ ​multiple​ ​sources​ ​into​ ​accessible​ ​and​ ​performant structures​ ​that​ ​support​ ​analytic​ ​needs
  • Oversees​ ​basic​ ​and​ ​advanced​ ​transformation​ ​activities​ ​such​ ​as​ ​normalisation, cleansing, ​ ​aggregation,​ ​summarisation,​ ​and​ ​integration
  • Defines​ ​and​ ​implements​ ​data​ ​quality​ ​logic​ ​associated​ ​with​ ​data​ ​processing​ ​flows
  • Plans​ ​and​ ​conducts​ ​ETL​ ​unit​ ​and​ ​development​ ​tests; ​ ​monitors​ ​results​ ​and​ ​takes corrective​ ​action
  • Ensures​ ​source​ ​system​ ​data​ ​availability​ ​and​ ​update​ ​accessibility, ​ ​data​ ​integrity, restart​ ​ability,​ ​and​ ​error​ ​handling
  • Identifies​ ​and​ ​manages​ ​interfaces, ​ ​service​ ​levels,​ ​standards,​ ​and​ ​configurations
  • Interacts​ ​directly​ ​with​ ​client​ ​stakeholders​ ​who​ ​are​ ​in​ ​business​ ​and/or​ ​technical​ ​roles (as​ ​needed)
  • Adheres​ ​to​ ​data​ ​security​ ​requirements​ ​at​ ​all​ ​stages​ ​of​ ​data​ ​processing
  • Follows​ ​industry​ ​standards​ ​and​ ​best​ ​practices

Minimum​ ​requirements:

  • Must​ ​have​ ​at​ ​least​ ​3-5​ ​years'​ ​experience​ ​with​ ​design,​ ​development,​ ​automation,​ ​and support​ ​of​ ​applications​ ​to​ ​extract,​ ​transform,​ ​and​ ​load​ ​data
  • Must​ ​have​ ​written​ ​ETL​ ​within​ ​a​ ​BI​ ​environment
  • Proficient​ ​in​ ​SQL​ ​and​ ​SQL​ ​scripts
  • Familiarity​ ​with​ ​Big​ ​Data​ ​Solutions​ ​(e.g.​ ​Data​ ​Lake​ ​/​ ​BigQuery)
  • Experience​ ​developing​ ​analytics​ ​solutions​ ​hosted​ ​in​ ​the​ ​Cloud​ ​is​ ​preferred​ ​(e.g. Google​ ​Cloud​ ​Platform,​ ​AWS)
  • Bachelor's​ ​Degree​ ​or​ ​equivalent​ ​work​ ​experience
  • Ability​ ​to​ ​work​ ​in​ ​an​ ​agile​ ​environment
  • Experience​ ​of​ ​Talend

Key​ ​behaviours

  • Ability​ ​to​ ​be​ ​self-driven,​ ​pro-active,​ ​systematic,​ ​well​ ​organised​ ​and​ ​rigorous​ ​about details
  • Ability​ ​to​ ​operate​ ​in​ ​a​ ​highly​ ​multidisciplinary​ ​and​ ​collaborative​ ​environment​ ​where effective​ ​exchange​ ​of​ ​knowledge​ ​between​ ​peers​ ​is​ ​crucial
  • A​ ​"can-do"​ ​mindset​ ​pursuing​ ​excellence
  • Ability​ ​to​ ​relay​ ​technical​ ​knowledge​ ​to​ ​internal​ ​and​ ​external​ ​stakeholders​ ​with​ ​various levels​ ​of​ ​technical​ ​knowledge​ ​and​ ​at​ ​all​ ​levels​ ​of​ ​seniority
  • Credible​ ​and​ ​articulate,​ ​with​ ​excellent​ ​communication​ ​and​ ​interpersonal​ ​skills​ ​both client​ ​facing​ ​and​ ​internally
  • Ability​ ​and​ ​eagerness​ ​to​ ​pass​ ​on​ ​knowledge​ ​to​ ​other​ ​team​ ​members
  • Ability​ ​to​ ​work​ ​to​ ​defined​ ​timelines Reporting​ ​line
  • The​ ​jobholder​ ​reports​ ​directly​ ​to​ ​the​ ​Business​ ​Intelligence​ ​Head/PM
  • Must​ ​be​ ​a​ ​team​ ​player​ ​and​ ​a​ ​self-starter​ ​who​ ​can​ ​work​ ​independently

Tableau / Talend