We are Assembly – and we’re not like the rest. We’re the modern alternative agency, bringing together industry-leading data, talent, and tech to Find the Change That Fuels Growth for the best brands on the planet, including Lane Crawford, Marina Bay Sands, and more. Our diverse, global community of over 1,600 passionate experts combines global thinking with unmatched local expertise in more than 20 markets worldwide – enabling brands to engage and move consumers anywhere. We use STAGE, Assembly’s proprietary, privacy-centric data solutions platform, to surface powerful insights that transform into actionable brand opportunities. We’re at the cutting edge of new media, technology, and platforms embedded in the lives of today’s consumers, and we’re tapped into how culture and communities’ needs change. We do this while staying steadfast in our commitment to Leave the World Better Than We Found It through measurable social and environmental impact work. 
Assembly was named The Drum’s APAC Media Agency of the Year in 2021 

This is an exciting opportunity in an environment where you will embark on an exciting journey that goes beyond just an internship. We believe in empowering our interns to make a real impact in the dynamic and ever-evolving digital marketing landscape. You will work closely with our regional senior data team leadership on daily basis and all round data & project related tasks. In addition, you will be exposed to sizable internal & external projects that make true impact to our business and to our clients. 

WHAT YOU’LL BE DOING ON ANY GIVEN DAY 

• Collaborate with Data Manager and regional data team to build data solutions for clients 

• Support maintenance of existing data products 

• Perform query writing to clean, consolidate, manipulate raw dataset according to project needs  

• Connect, modify, QA, and incorporate any data sources needed  

• Data visualization with Tableau 

• Data and query QA 

• Regular reporting and hygiene checks  

• Support dashboard building 

• Any other tasks as directed 

DOES THIS SOUND LIKE YOU? 

• Data-related educational background  

• Must know and can write SQL well  

• Proficient in Tableau (Preferred) / Power BI / Google Data Studio  

• Native in Mandarin and fluent in English

• Self-motivated and keen to learn  

NICE-TO-HAVE (Not Required): 

• Knowledge of media buying. i.e. google ads, baidu ads, red ads 

• Experience automating data workflows using Python