Data Management and BI, Senior Analyst, GOC

Bachelor’s degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics or related field. 1 – 3 years of work experience in data management, data visualization, and data analytics, preferably in a marketing and/or media agency. Experience with building dashboards in Tableau is required. Experience with Alteryx for business logic design required. Experience working with SQL required. Experience working in Cloud environment (Azure, GCP) is low priority. Experience working with digital data from ad serving platforms, campaign planning tools, website analytics software, paid search engine marketing data sources is strongly preferred. Strong analytical, critical thinking, and problem-solving skills. Strong attention to detail. Ability to thrive in a fast-paced and deadline-driven environment. Strategic Thinker & Doer. Curious and excited to learn. High sense of accountability and ownership. Collaborative with a partnership mindset. Strong speaking and written professional communication skills.

Manage QA of data between media platforms and reporting outputs using Alteryx, SQL, and/or Excel. Identify and resolve data gaps, escalating to investment teams. Monitor data feeds for failures and take action. Build and maintain automated data QA workflows using Alteryx. Update Tableau dashboards based on requests. Build and maintain taxonomy generators and enforcers. Set up and maintain automated data feeds/pipelines through API, FTP, or scheduled email reports. Troubleshoot data discrepancies. Fulfill ad hoc data pulls for client deliverables. Manage QA of data provisioning to MMM vendors or client data warehouses.