Automation & Data Specialist at teamlewis

Beijing, Beijing, China -

Full Time

Start Date

Immediate

Expiry Date

27 Apr, 26

Salary

0.0

Posted On

27 Jan, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Automation, Python, SQL, Google Apps Script, Data Analytics, Data Reporting, Data Cleaning, Data Organisation, Data Visualisation, Analytical Skills, Attention to Detail, Communication Skills, Project Management, Problem Solving, Team Collaboration, Integrated Communications

Industry

Marketing Services

Description

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 Foundation. In 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 donation. In addition, nominated causes can also benefit from a donation in kind of expertise, time, and resources. In the past year, TEAM LEWIS has donated almost $2million to 445 causes around the world. You can read more about TEAM LEWIS Foundation at https://www.teamlewis.com/impact/. 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 automation. In 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 Python,Google 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 client’s 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.

Responsibilities

The Automation & Data Specialist will design, build, and maintain scalable data pipelines while collaborating with various stakeholders to deliver data solutions. They will also ensure the accuracy and timely delivery of reports to clients, translating data into actionable insights.