Job Description

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 aroundfor 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. Demonstrated ability to manage multiple projects with tight deadlines while maintaining high attention to detail. **We are unable to offer employment visa assistance for this role.** The monthly salary range for this position is $6,250 - $6,667, with an annualized equivalent of $70,000 - 80,000. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position. The Company reserves the right to modify this pay range at any time. As an Equal Opportunity Employer, at RPA we hire without consideration to race, religion, creed, color, national origin, age, gender, sexual orientation, marital status, veteran status, disability, or any other classification protected by federal, state, or local law. Create a Job Alert Interested in building your career at RPA? Get future opportunities sent straight to your email. Apply for this job indicates a required field First Name * Last Name * Preferred First Name Email * Phone * Resume/CV * Enter manually Accepted file types: pdf, doc, docx, txt, rtf Enter manually Accepted file types: pdf, doc, docx, txt, rtf LinkedIn Profile What salary range are you looking for in your next opportunity? * Are you currently living in the southern California area? * Select... This is a hybrid role, working from our Santa Monica office a few times per week. Are you willing and able to commute to our offices each week? * Select... What interests you specifically about this position? * If hired, would you need RPA to act as the petitioner for a visa petition on your behalf now or in the foreseeable future? * Select... What are your preferred pronouns? U.S. Standard Demographic Questions We invite applicants to share their demographic background. If you choose to complete this survey, your responses may be used to identify areas of improvement in our hiring process. How would you describe your gender identity? (mark all that apply) Select... How would you describe your racial/ethnic background? (mark all that apply) Select... How would you describe your sexual orientation? (mark all that apply) Select... Do you identify as transgender? Select... Do you have a disability or chronic condition (physical, visual, auditory, cognitive, mental, emotional, or other) that substantially limits one or more of your major life activities, including mobility, communication (seeing, hearing, speaking), and learning? Select... Are you a veteran or active member of the United States Armed Forces? Select... #J-18808-Ljbffr RPA

Job Tags

Similar Jobs