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 Adobe, 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.ResponsibilitiesWith managers’ guidance, manage reports and datasets from various channels and platforms, including (but not limited to) various mainstream media platforms such as Google and Bing, and analytics platforms such as GA and AA.This includes setting up processes to pull data from platforms and channels, managing data sources, processing and manipulating the data and consolidating data across multiple data sources in SQL databases.Perform query writing to clean, consolidate, manipulate raw dataset according to project needs.Assist senior team members to troubleshoot data discrepancy issues and solve ad-hoc requests from the clients.Support to resolve day to day challenges encountered on datasets and perform different data analytics tasks on different platforms.Manage, modify, QA, and incorporate any additional data sources needed.Build, manage, modify and maintain dashboards.Support regular reports and presentations with key findings, observations, data insights and recommendation.Create, manage and improve new or existing datasets where needed.Requirements:2+ years of working experience in data or digital marketingBachelor's degree in computer science, data science, or related field preferredProficient in SQLExperience in visualisation tools such as Tableau, Looker, PowerBI, DatoramaStrong analytical individual who enjoys lateral thinking and problem solvingAttention to detail with the ability to effectively troubleshoot issues across various data sources and platformsExperience working with and consolidating multiple data sources (direct from engines, google sheets, FTP, HTTP etc.) Proactive, motivated, self-starter and willing to learnFluent English communication, verbal and written. A second Asian language is a plus.Understanding of data ecosystem and mainstream data platforms is a plus, including Google Analytics, Google Tag Manager, Google Cloud, Tableau, PPC, Display, Programmatic, Paid Social etc