Senior Data Analyst 1

Job Description

Key Responsibilities

1. Strategic Analysis & Storytelling

• Analyze information independently to turn results into compelling stories that provide added value and ROI insights for clients.

• Create detailed ROI reports and dashboards that demonstrate the monetary value of sponsorships based on audience size and advertising rates.

• Conduct market research, including survey analysis and trend forecasting, to help brands understand emerging behaviors and demographics.

2. Project Management & Delivery

• Manage complex client analytical projects, serving as a liaison between Sales and Operations to ensure solutions meet client needs.

• Define scope, perform cost calculations, and conduct feasibility checks for projects, ensuring they meet budget expectations and profitability goals.

• Use project planning tools (such as ROSCO or Monday.com) to track project progress and coordinate with diverse media services teams to meet service-level agreements.

3. Process Optimization & Automation

• Drive the automation of standardized, repeatable business processes to improve efficiency and effectiveness.

• Utilize technical skills (Python, VB Script) to optimize delivery workflows and contribute to the continuous improvement of services.

• AI Integration: Design and implement AI workflows and utilize prompt engineering to enhance data processing speed and analytical capabilities. 

4. Media Valuation & Quality Indexing

• Oversee methodologies for "Media Value" determination, including Brand Tracking (identifying logos in video footage) and Quality Indexing (grading logo visibility, focus, and screen time).

• Ensure accurate valuation calculation using proprietary tools and audience data.

Qualifications

Essential Skills & Qualifications

• 3 - 6 yrs experience - Data Expertise: Strong proficiency in Excel, including advanced formulas, pivot tables, and complex data transformation techniques.

• Analytical Mindset: Possess an analytical mindset and strong time management and prioritization skills.

• Communication: Excellent communication and presentation skills, with the ability to turn analysis into clear recommendations for diverse audiences.

• Industry Knowledge: Deep knowledge of media and sponsorship within the advertising industry.

• Schedule Flexibility: Must be willing to work in shifts to provide seamless support to our USA market clients.

• Communication: Excellent spoken and written communication skills in English are mandatory for presenting recommendations to different audiences and building trust with stakeholders.

• Project Management: Strong time management and prioritization skills, with the ability to coordinate ongoing client projects independently.

• Global Mindset: Ability to collaborate with international colleagues and maintain an internal and external network.

Technical Proficiency

• Advanced Data Manipulation: High proficiency in Python and SQL to extract and manipulate data from a variety of sources is required.

• Visualization & BI Tools: Extensive experience with Power BI or Tableau. Candidates must understand the underlying architecture, not just the User Interface.

• Spreadsheet Mastery: Advanced skills in Google sheets, Microsoft Excel, including pivot tables and VLOOKUPs.

• AI & Automation: Exposure to basic AI concepts, including prompt engineering and the creation of AI workflows to automate data tasks.

• Statistical Analysis: Familiarity with statistical software such as SPSS or R is beneficial for research-heavy tasks. - Preferrable

• Technical Advantage: Experience with scripting or coding languages, such as Python or VBA (Visual Basic for Applications). 

• Automating various iterative tasks within MS Excel or any other tools using Python. 

Additional Information

Please be aware that job-seekers may be at risk of targeting by scammers seeking personal data or money. Nielsen recruiters will only contact you through official job boards, LinkedIn, or email with a nielsen.com domain. Be cautious of any outreach claiming to be from Nielsen via other messaging platforms or personal email addresses. Always verify that email communications come from an @nielsen.com address. If you're unsure about the authenticity of a job offer or communication, please contact Nielsen directly through our official website or verified social media channels.