Data Engineer, Data and Analytics

M&C Saatchi Performance, Scotland-wide

Data Engineer, Data and Analytics

Salary Not Specified

M&C Saatchi Performance, Scotland-wide

  • Full time
  • Permanent
  • Remote working

Posted 2 weeks ago, 20 Nov | Get your application in now before you miss out!

Closing date: Closing date not specified

job Ref: 06c45897c99c455189498e5bd3d95515

Full Job Description

This is a permanent role on the Data and Analytics team, based at our Bangalore Office, reporting to the Head of Technology and working alongside Data, Legal and Process colleagues., We're looking for someone who can oversee the delivery of our client dashboards, media reporting and other data projects, working closely with our clients and the individual team leads (e.g. Planning, Buying, Search & Social). There are two key challenges with this role, firstly the continued development of the M&C Saatchi Performance proposition, delivering market-leading outputs to our clients, and secondly, to help develop the individuals across the teams. What you will be responsible for

  • Building and maintaining our data lakes/data warehouse
  • Building and maintaining our ETL jobs across both batch and real-time datasets
  • Building data quality processes to ensure the accuracy of our data
  • Create standards, conventions, processes, SLAs to reduce time and increase quality of delivery of the Data Engineering team.
  • Evaluate different tools and technologies to be used by the team.
  • Work in an agile way and to do so closely with colleagues
  • Provide documentation and training material to support knowledge retention

    Experience writing high quality, maintainable SQL/Python on large datasets.
  • Experience working on building/optimizing logical data model and data pipelines while delivering high data quality solutions that are testable and adhere to SLAs.
  • Experience working with ETL tools like Alteryx, Matillion etc.
  • Experience working with data quality tools like Great Expectations is preferred
  • Experience with Amazon Redshift, S3, EC2 and other AWS technologies
  • Sound knowledge of the digital media landscape, standard client KPIs and digital campaign metrics
  • Proven track record of strong verbal/written communication & data presentation skills, including an ability to effectively communicate with both business and technical teams.
  • Experience in using various data design patterns and knows when/when not to use one.
  • Experience with standardising all aspects of a data pipeline like creating UDFs, parameterised workflows etc., so that they can be reused across different clients/use cases
  • Experience working with Data Science and/or Analytics teams in an agile environment is preferred
  • Solid understanding of and demonstrated experience in using appropriate delivery management tools e.g. JIRA

    M&C Saatchi Performance is a global digital media agency, connecting brands to people. We deliver business growth for our clients through effective, measurable, and evolving digital media strategies. As an agency we aim to change advertising together.