Sr. Analyst, Analytics

We’re RPA: an independent advertising agency that puts People First. It’s a unique philosophy for a different kind of agency: where we aspire to create work that truly matters to people, for brands that respect and value people, with a team we empower and treat like people. And we do it all in the heart of sunny Santa Monica, California.  

Why You’ll Never Want to Leave 

Our People First philosophy means creating a culture where people like you can thrive, do meaningful work, and — we hope — stick around  for a while. In an industry known for high turnover, people at RPA seem to recognize the value of an environment that truly wants to support our Associates’ lives and career growth. 

Who You’ll Be Collaborating With 

Every day, you’ll be teaming up with a diverse, enthusiastic, multi-disciplinary team of professionals with a smart sense of humor and a strong desire to grow and develop. 

Job Summary 

You’re a data-driven storyteller, passionate about turning complex performance data into strategic insights that shape media and marketing strategies. You excel at both cross-channel campaign analytics and technical data solutions, bridging the gap between performance reporting and advanced analytics. You bring hands-on expertise with media metrics, ad tech platforms, and data environments, and you thrive in a collaborative, fast-paced agency setting. You’re excited by the challenge of helping Honda and Acura make smarter advertising decisions through rigorous analysis, modern BI tools, and automation techniques. 

This is a Hybrid role, based in the Los Angeles area, working from the offices in Santa Monica a few times per week. 

 What You’ll Be Working On 

• Develop and lead holistic media performance reporting across digital, paid social, and traditional channels, delivering actionable insights that drive campaign optimization and strategic evolution. 
• Identify cross-channel trends, audience engagement patterns, and media mix opportunities that inform buying and planning strategies. 
• Pull, analyze, and synthesize data from key platforms including CM360, Meta Ads Manager, and other ad servers and media tools to assess media effectiveness. 
• Lead advanced analytics projects to support strategic initiatives for Honda/Acura, working with large, complex datasets that connect media exposures with business outcomes (e.g., sales, leads). 
• Write and optimize SQL queries to extract and join datasets in data clean room environments (e.g., LiveRamp, Habu), ensuring high data quality and integrity. 
• Build data pipelines and automate workflows using ETL tools such as Domo or Alteryx. 
• Develop predictive models and statistical forecasts to guide media investment and future campaign decisions. 
• Create dynamic dashboards and compelling data visualizations in Tableau, Power BI, or Domo that effectively communicate performance insights to stakeholders. 
• Collaborate with cross-functional teams to integrate analytics into planning, creative, and strategy workflows. 

 How You’ll Excel in Your Role 

• Experience in media analytics or marketing data science, preferably in an agency setting. 
• Deep understanding of media KPIs and experience analyzing campaigns across programmatic, digital direct, social, and offline channels. 
• Proficient in ad measurement tools such as CM360, DV360, Meta Ads Manager, and others. 
• Strong fluency in SQL; comfortable querying cloud-based data platforms (e.g., Google BigQuery, AWS, Snowflake). 
• Hands-on experience with data visualization tools like Tableau, Power BI, Domo, or Looker. 
• Familiarity with advanced analytics methods (predictive modeling, regression analysis, time-series forecasting). 
• Proficient in Python or R for data wrangling, statistical analysis, or automation (bonus points for experience with scikit-learn, pandas, or tidyverse). 
• Experience working with ETL tools (Domo ETL, Alteryx) and building scalable data pipelines. 
• Strong communicator with the ability to simplify technical findings for non-technical audiences, both internally and with clients.