Affiliate Marketing Analyst - Los Angeles, United States - Centerfield Corporation

Description

The Opportunity...Centerfield is looking for a talented Marketing Data Analyst to join our team This position provides an excellent opportunity to leverage data, analytics, and performance metrics to drive revenue and profit for Centerfield within the Home Services Division.

This person will be generating and automating reports to analyze digital marketing performance across both advertisers and affiliates, and aiding in administering affiliate tracking tools for our Home Services Affiliate team.

You'll join an enthusiastic, fast-paced, lean team of marketing professionals, collaborating to deliver top-notch results to a diverse set of top brands worldwide.

Your core responsibilities will be translating data into actionable insights for the Affiliate team, as well as generating and automating visual reports and dashboards for use across the business.

You will also run predictive analyses and modeling to provide insights and recommendations for the client success, media buying, finance, and sales teams.

Outstanding candidates will thrive in an entrepreneurial, startup environment, work well both independently and with a team, have strong intellectual curiosity, and a roll-up-your-sleeves attitude.

If you love to work with large sets of data to drive conclusions, but also thrive in understanding, identifying and positively impacting the key drivers in performance marketing - this is the perfect role for you.

How You'll Contribute...Operate as a member of the Home Services team, acting as a subject matter expert, performing regular and ad-hoc analyses as business requirements dictate; while actively monitoring and reporting on program performance daily, developing reporting and insights capabilities and establishing processes to effectively assess progress and identify opportunities in real-timeCollaborate closely with stakeholders across teams (client success, finance, media, sales, product, AdOps, etc.) to gather requirements and criteria for effective data analysis, reporting, and dashboardsCreate, enhance, maintain, and automate reports and dashboards that provide actionable insights and help relevant teams make faster and better decisionsSynthesize and analyze affiliate performance and campaign-specific data to provide insights to the Home Services team - you will be an active contributor to business strategy and recommendations by translating data into digestible and highly visual applications that elevate analytics into actionable informationIdentify upsell, pivot and optimization opportunities for the Affiliate team by modeling "what-if" scenarios and analyzing various payment models for profitability, deep diving into campaign and product level performance analytics to uncover deficits and drive growthDig into channel level performance data to drive advertiser- and/or affiliate-specific testing, optimization and analysis to identify key levers and opportunities for improvementCommunicate performance readouts to key stakeholders and cross functional teams to promote business-wide understanding of strategy, ROI and future opportunitiesHave ownership stake in administration of a third party Affiliate tracking and reporting platform, including ongoing front end maintenance, liaising with technology teams for back end proficiencies and ensuring Affiliates always have the necessary visibility into their campaign performance and related earningsTake a proactive role in continuously monitoring affiliate account activity, evaluating performance metrics (and profitability), recommending innovative strategies to boost revenue generation and sales volumeCreate and automate reports in Tableau (and related BI tools) and Excel, utilizing advanced formulas, VLOOKUPs and pivot tables, as neededCreate data download processes through Tableau workbooks and SQL databases using tools such as python, SQL, and VBA (Visual Basic for Applications)Create and interpret charts and graphs to identify trends in data and provide insights to the Home Services teamBe proficient in data modeling and predictive forecasting to most accurately scale business growthProvide training and support to users (both internal and external) on proper use of reports and dashboardsContinuously seek ways to improve data reporting and analytical processes, staying updated and well-versed with the latest trends, tools and best practices in marketing analytics.

What We're Looking For...2+ years of experience with performance marketing reporting and data analysis (preferably in the affiliate space)Highly motivated, self-starter with a passion for meeting and exceeding objectivesCollaborative team player, yet comfortable working independently to solve problems and lead projectsExperience with performance marketing KPIs (CPC/PPC/CTR/CPA, etc.) and a thorough understanding of the digital media landscape, including hands-on experience with various marketing distribution channels (search, social, email, display, etc.)Strong digital analytics experience (site analytics, media projections, performance results, etc.)Must have strong Tableau data manipulation and visualization skills, as well as experience with 3rd party media and/or affiliate tracking platformsAbility to understand unstructured business problems and translate into actionable insightsAdvanced understanding of Python, SQL, and VBA, with high-level proficiency in MS Excel - you view yourself as an "Excel Master"Strong communication and interpersonal skills, with a unique ability to effectively illustrate and communicate quantitative findings with non-technical team membersStrong analytical skills (ability to confidently identify data anomalies, assess/calculate risks, and escalate issues)Significant comfort level with economic principles and profit modelingAble to work with a high degree of accuracy and incredible attention to detailHighly organized, with an innate ability to prioritize and deliver in a high-pressure environmentLife at Centerfield...If you are located in Los Angeles, CA, this is a hybrid position, and employees are expected to come into our Playa Vista, CA office every Tuesday, Wednesday & ThursdayCompetitive salary + bi-annual bonusUnlimited PTO - take a break when you need itIndustry-leading medical, dental, and vision plans + generous parental leave401(k) company match plan - fully vested on day 1Outside patio overlooking Playa Vista + cabanas, firepits & working grillsMonthly happy hours, catered lunches + daily food trucksAward-winning culture & unprecedented team spirit (featured in LA Business Journal & Built In LA)Fully stocked kitchens with snacks & drinksBreakroom supplied with games, couches, workout equipment + weekly in-office exercise classes hosted by professional instructors (yoga, kickboxing & circuit training)Free onsite gym + locker roomsPaid charity and volunteer days (local mentor programs, adopt a pet, beach cleanup, etc.)Monthly team outings (ball games, casino night, hikes, etc.)