Senior Business Intelligence Analyst - Remote

Overview

The Senior Business Intelligence Analyst at WPP Media will assist in the development and maintenance of the reporting infrastructure to help stakeholders gain insights in their advertising campaigns. This role involves retrieving, compiling, and transforming data to create the intelligence layer leading to analysis and optimization of media investments.

In Short

• Manage the QA of data between media platforms and reporting outputs using tools such as Alteryx, SQL, and/or Excel.
• Identify data gaps requiring manual entry and escalate to investment teams.
• Monitor data feeds for gaps or failures.
• Build and maintain automated data QA workflows using Alteryx.
• Update Tableau dashboards based on new requests.
• Setup and maintain automated data feeds/pipelines through API, FTP, or scheduled email reports.
• Troubleshoot data discrepancies or issues.
• Fulfill ad hoc data pulls for client deliverables.
• Manage QA of data provisioning to MMM vendors or client data warehouses.

Requirements

• Bachelor’s degree in a related field with 1-3 years of experience in data management, visualization, and analytics.
• Experience with building dashboards in Tableau.
• Experience with Alteryx for business logic design.
• Experience in Cloud environments (Azure, GCP).
• Experience with SQL and Python is a plus.
• Strong communication skills.
• Analytical and problem-solving skills.
• The ability to thrive in a fast-paced environment.
• Collaborative mindset.

Benefits

• Competitive medical, retirement plans, vision, and dental insurance.
• Significant paid time off.
• Preferential partner discounts.
• Employee mental health awareness days.
• Opportunities for professional growth and networking.