Data Analyst, BI

Job Description About Us At Assembly, we help brands find the change to fuel business growth. We are an award-winning global brand performance agency, home to 1,600 talented people across 25 offices globally. We create unique data, technology and media solutions that enable faster and smarter problem solving and an inspired, collaborative workplace culture. At Assembly we embody three core values: Show Up - actively contribute to a space of personal and collective growth; Make Change - embrace obstacles as opportunities, taking intentional steps to drive positive change; and Win Well - approach success with integrity, responsibility, and a commitment to collaboration, understanding that the journey is as important as the destination. Together, we create an environment that fosters continuous learning, adaptability, and a shared passion for making a meaningful impact. We stay ahead of what's next, providing fresh insights to spark new ideas. We're a trusted partner to our clients, working behind the scenes to bring imagination, depth, and clarity to their biggest challengesin entertainment, technology, lifestyle, sports, and gaming. Together, we create with confidence Overview We're looking for a BI Specialist to join the Business Intelligence function responsible for consolidating technical knowledge to develop consistent processes across the agency. The Function is responsible for managing data collection, analysis, insight and tech solutions for our digital marketing clients. The BI Function sits within the Client Teams and this role will be to support the planning and management of digital marketing campaigns. Internally you will oversee the integration of a client's technology stack into our own systems and processes, working alongside activation and consultancy teams to ensure this data is being correctly utilised across reporting, analysis, forecasting and planning. Responsibilities The BI Analyst will be responsible for ; - With 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 - P erform 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 t o resolve day to day challenges encountered on datasets and perform different data analytics tasks on different platform s - M anag e, 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 - C reat e , manage and improve new or existing datasets where needed Required Skills - 2 + years of working experience in data or digital marketing - B achelor's degree in computer science, data science , or related field preferred - Proficient in SQL - Experience in visualisation tools such as Tableau, Looker , PowerBI , Datorama - Strong analytical individual who enjoys lateral thinking and problem solving - Attention to detail with the ability to effectively troubleshoot issues across various data sources and platforms - Experience working with and consolidating multiple data sources (direct from engines, google sheets, FTP, HTTP etc.) - Proactive, motivated, self-starter and willing to learn - Fluent 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 Clou d, Tableau, PPC, Display, Programmatic, Paid Social etc Benefits - Annual Leave in number of 20 allotted to all employees beginning of every calendar year. - Sick Leave in number of 12 is allotted effective DOJ and beginning of ever calendar year. - Other Leaves-Maternity Leave & Paternity Leaves, Birthday Leave Entitlement - Dedicated L&D Budget for all Teams to upskill & get certified - All employees are entitled for Group Personal Accident Cover & Life Cover Insurance. - Insurance coverage for the entire family (Employee + up to 7 dependents - Self, Spouse, up to 4 children, and Parents) - Monthly Cross Team Lunch - Rewards and Recognition program-Employee of the month, Star Performer, Tenure Celebration & many more Equal Opportunities Assembly is an advocate for equal opportunity in the workplace. We are committed to ensuring equal opportunities regardless of race, colour, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability and gender identity. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. If you have a disability or special need that requires accommodation, please let us know. Social and Environmental Responsibility At Assembly, we have a responsibility to bring impact into our every day. This means we must always look for ways in which to be conscious citizens in our roles to support society and environmental sustainability. We encourage employees to; be a conscious citizen by actively participating in our organisation's sustainability efforts, help us promote environmentally friendly practices within the workplace, collaborate with community organisations and stakeholders to support initiatives aligned with our company's values, participate in volunteer activities that benefit the community. Employees are also encouraged to make suggestions and evaluate our business practices to identify areas for improvement in social and environmental performance. Employees at Assembly demonstrate commitment to sustainability and inclusivity in their actions and behaviors.