Job Description

The purpose of this role is to provide technical know-how to our database marketing solutions. The role is well adept in relational database concepts, and is proficient in SQL. The role will be responsible for creating and modifying database code, as well as helping with operational aspects of the database.: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.Location: DGS India - Bengaluru - Manyata N1 BlockBrand: MerkleTime Type: Full timeContract Type: Permanent

dentsu