Automation & Data Specialist

About TEAM LEWIS

The company is an integrated communications agency that has gone from start-up to multinational in a little over two decades. The company now ranks in the top 40 agencies worldwide and has 26 offices. Its success is due to a combination of factors talented people delivering award-winning campaigns; expanding client relationships into new markets or services; making strategic acquisitions. The agency its people and client campaigns have won many prestigious awards including Cannes Lions Holmes Report ICCO PRCA and European Excellence.

At the heart of the business is TEAM LEWIS January 2021 there was a need to respond to the challenges the COVID pandemic brought to communities and charitable organisations. TEAM LEWIS saw that support was crucial and change was needed to make that happen. Our local causes scheme was launched. Every member of TEAM LEWIS can nominate a local cause close to their heart to receive a cash addition nominated causes can also benefit from a donation in kind of expertise time and the past year TEAM LEWIS has donated almost $2million to 445 causes around the world.

You can read more about TEAM LEWIS Foundation at

Purpose of the role

We are seeking a proactive and driven Automation & Data Specialist to join our expanding Insights & Performance team supporting the APAC region. The ideal candidate is a self-starter with strong analytical capabilities and proven experience in data this role you will contribute key client accounts and new business opportunities by amalgamating data across various sources driving data cleaning organisation and automation to streamline workflows data analysis and visualisation to support deeper analysis.

You will play a crucial role in identifying data AI or tool trends and use cases applicable to our clients relevant industries or markets enabling the brands we work with to capitalise on emerging trends mitigate risks and optimise strategies. Often collaborate cross-functionally with various departments to uncover trends and insights to address specific business challenges.

This role requires diligence independence and technical savviness.

Key Responsibilities

Data Automation

• Designing building and maintaining scalable data pipelines using Python SQL and Google App Scripts

• Integrating data from multiple internal and external sources with advanced SQL queries and Python scripts

• Optimising data storage and retrieval for performance and efficiency with SQL tuning and Python or Google App Scripts automation

• Collaborating with data scientists analysts and other stakeholders to understand data needs and deliver solutions

• Automating data ingestion transformation and loading processes leveraging Python Google App Scripts and SQL

• Monitoring and maintaining the health and performance of data infrastructure

• Implementing effective data modelling and architecture solutions

• Managing metadata and maintaining data catalogs for data discovery and lineage

• Staying updated with emerging data engineering technologies and best practices

• Participating in code reviews and ensuring adherence to coding standards especially for PythonGoogle App Scripts and SQL

Data Analytics and Reporting

• Choosing which method to use for a particular request and formulating the logic/ flow to deliver results against agreed KPIs for analysis or visualisation. This will be done collaboratively with the media analyst team E.g. media monitoring data scrapping from web

• Ensure the delivery of excellent consistent service and results to clients; bring rigorous evaluation and measurement to campaign planning and reporting.

• Ensure the accuracy comprehensive coverage and timely delivery of reports on the clients data footprint.

• Translate and summarise data to deliver timely reports and alerts to inform the client of any impending developments

• Execute projects to create value and efficiencies for the client and the project/account servicing team.

• Utilise our tools and dashboard software suite to cover the end-to-end process of extracting raw data uncovering insights and delivering factual digestible reports to clients and account teams.

General

• Run and support training sessions with a view to maximising opportunities to expand team skills and grow revenues

About you

You are a highly curious individual with a foundation in data automation. You are open-minded and agnostic across data sets; on occasions with limited resources you are able to find workarounds prioritise what is available and provide caveats to ensure analysis integrity. You have a positive growth mindset and are a team player wanting to learn collaborate implement and contribute to any projects small or big

You have an eye for detail are a whiz at organising a large volume of data into easy-to-read charts and are obsessed with understanding the so what & why behind data.

• 2-3 years of experience in data automation particularly in communications or business intelligence

• Experience with data warehousing concepts and implementations

• Strong knowledge in Python and SQL

• Familiarity with Google Apps Script (JavaScript) and n8n

• Strong analytical skills with the ability to interpret and synthesise data from multiple sources

• Excellent attention to detail and organisational skills

• Strong written and verbal communication skills. Ability to work both independently and collaboratively in a fast-paced environment

• Ability to interact confidently with internal and external stakeholders

• Robust understanding of integrated communications; experience integrating PR with digital marketing content and broader marketing activities

• Can problem solve project manage multi-task remain calm under pressure and able to meet tight deadlines

• Integrity humility self-drive/initiative sense of responsibility and humour

This job description is not intended to be an exhaustive list of the responsibilities for this role. Other responsibilities may be added from time to time.

TEAM LEWIS is an Equal Opportunity Employer. We are committed to creating and fostering an environment focused on equality empowerment and respect. We strive to create an inclusive workplace that supports and celebrates our diversity. We continue to invest in our efforts to ensure that TEAM LEWIS is a place where everyone can thrive.