BI Analyst, Data

We are an assembly of data, talent and technology.
Assembly and ForwardPMX have joined forces to form the new Assembly, a global marketing services company designed with the modern mixture of omnichannel media expertise, powered by data, technology and business consulting solutions that help the best brands on the planet find the change that fuels growth.
We’re not built like anyone or anything else. We’ve assembled a market-leading collection of data, talent and technology to deliver something that’s truly distinct and capable of driving transformation, change and growth to marketing leaders worldwide.
When you become part of AssemblyGlobal, you become part of a global community of digitally-led experts - with 1,500 people in over 20 countries and 30 office locations around the world. We pride ourselves in our global thinking, matched by a specialized local approach that enables brands to understand, engage and move consumers anywhere they are.
We believe in a world where Purpose is on par with Profit, and as a modern business in a dynamic and influential space, we have a responsibility to use our position to impact meaningful change. It keeps us connected to each other and to the world around us, and we are here to make our mark.

The BI Analyst will be responsible for;
- Support and coordinate with the web analytics team and BI team on day to day challenges encountered on datasets and perform different data analytics tasks on different platforms.
- Assist senior team members to troubleshoot data discrepancy issues and solve ad-hoc requests from the clients.
- With data 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 platform 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
- Work with the team to manage, modify, QA, and incorporate any additional data sources upon clients’ data requirements.
- 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.
- Addressing challenges or opportunities presented by clients or teams and creating bespoke solutions using technology

The role will have the potential to span all existing channels (including but not limited to display, paid social, organic performance, affiliates, content creation and localisation) as well as working on standalone propositions and new services centred around the use of structured data.

**Requirements**:
**Requirements**:

- Must have good understanding of SQL and able to write queries
- 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
- Data driven approach to optimisation and testing to show full value of changes
- Proactive individual who is confident taking the initiative and working with colleagues across teams and departments
- 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 in English, any other language is a plus

Desired Skills
- Experience with visualization tools is a plus, such as Google Data Studio, Tableau, PowerBI, Datorama.
- Any additional coding or data management experience
- Understanding of data ecosystem and mainstream data platforms
- 1-3 years working experience in digital marketing industry is a plus
- Experience working in data management or educational background in digital and analytics is a plus