Data Engineering Lead, Data and Analytics

Job Location: Bangalore, India

To apply, submit your resume along with a cover letter explaining what makes you right for this role.
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.

What you need to know about us
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.

What we think you’ll want this role
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
• Manage and mentor junior members of the team.
• 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

What are the requirements of the role
• Experience writing high quality, maintainable SQL/Python on large datasets.
• Experience with Amazon Redshift, S3, EC2 and other AWS technologies
• Experience working with ETL tools like Alteryx, Matillion etc.
• Experience working with data quality tools like Great Expectations is preferred
• Experience working with data cataloguing tools like DataHub is preferred.
• Sound knowledge of the digital media landscape, standard client KPIs and digital
campaign metrics
• Experience with managing a team of data engineers, keeping them motivated and
upskilling them
• 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 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
• Proven track record of strong verbal/written communication & data presentation skills,
including an ability to effectively communicate with both business and technical teams.
• 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

What can you look forward to
• Being a part of the world’s largest independent advertising holding group.
• Family Health Insurance Coverage.
• Flexible Working Hours.
• Options available for Work from Home.
• Regular events including Reece Lunch & indoor games.
• Employee Training/Learning Programs