Data Analyst

Carbon Data Reporting - Data Analyst In summary, a data analyst in a media agency needs a blend of technical expertise in data analysis tools, business acumen in media and advertising, and strong interpersonal skills for effective communication and collaboration. Responsibilities Data Collection and Analysis 1. Collecting data from various sources through Data Refinery such as social media platforms, advertising campaigns apis to feed into the output requirements for Carbon Data Reporting. 2. Cleaning and organising data to ensure accuracy and reliability using tools such as Databricks to transform the data. 3. Analysing data to be able to provide a good understand on how to produce the output required for Carbon Data Reporting. Reporting and Visualisation 1. Visualising data using tools like Power BI to facilitate understanding and decision-making. 2. Ability to follow a templated design and produce the required outcomes based on the Carbon Data dashboard. Strategy Development 1. Collaborating with different stakeholders to map the correct fields to the required outputs to produce the Carbon Data Reporting requirements. 2. Understand the end-to-end process of how the Carbon Data Reporting pipelines are build and can support trouble shooting when there are issues or challenges. Skills Technical Skills 1. Data Analysis Tools Proficiency in tools such as Excel, SQL, Python for data manipulation and analysis. 2. Data Visualisation Experience with visualization tools like Tableau, Power BI, or similar for creating impactful visual representations of data. 3. Database Management Knowledge of database systems and querying languages (SQL) for efficient data extraction and manipulation. 4. Understand Data Refinery or API platform like Adverity in order to support the ingestion of the required data in order to achieve the required Carbon Data Dashboards and Reports. 5. Ability to understand a mapping document and support the stakeholders with completing it for the purpose of generating the Carbon Data Dashboards and Reports. Business Skills 1. Industry Knowledge Understanding of media industry dynamics, advertising strategies Media life cycle. 2. Campaign Management Ability to analyse and understand media campaign performance. Interpersonal Skills 1. Communication Clear and effective communication of complex data insights to non-technical stakeholders. 2. Collaboration Working closely with cross-functional teams. 3. Problem-Solving Ability to identify issues from data analysis and propose actionable solutions. 4. Attention to Detail Ensuring accuracy in data collection, analysis, and reporting. Additional Considerations 1. Adaptability Ability to work in a fast-paced environment with evolving data sources and technologies. 2. Project Management Organisational skills to manage multiple projects and deadlines effectively.