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
This role is ideal for early-career engineers and recent CS, engineering, or data science graduates who want to master their hands-on experience writing complex SQL queries, building data pipelines, modeling relational systems, and using modern AI tools to accelerate workflow and analysis.
This role focuses on:
- SQL development and optimization
- Data modeling and relational entity design
- Working with analytical datasets and transformations
- Supporting analytics workflows
- Creating AI agents and using MCP to collaborate with other agentic-enabled services
- Documenting your work
Experience with LLM platforms like ChatGPT, Claude, or Copilot is helpful — but not required to apply.
What You’ll Be Working On
Data Engineering & Analytics Enablement
- Write, optimize, and maintain SQL queries for analytics and reporting
- Interpret and design relational data models and entity-relationship diagrams
- Manage datasets and transformations, primarily in BigQuery
- Maintain and troubleshoot pipelines feeding Domo and other BI tools
- Build and update datasets, ETL flows, and transformation logic
- Write automation pipelines using n8n
- Assist analysts with SQL tuning and data exploration
- Implement data quality checks and ensure data consistency across environments
- Document data models, transformations, and table-level business logic
- Monitor scheduled jobs and ensure reliable data refresh cycles
AI-Powered Workflow Support
- Contribute to AI automations connected to RPA’s data systems
- Develop structured prompts, templates, and AI-based utilities
- Help evaluate new LLM tools and identify high-value use cases
- Use MCP to communicate with agentic-enabled systems
- Use ChatGPT, Claude, or Copilot for documentation, QA, and data exploration
Cross-Functional Collaboration
- Translate business questions into technical data requirements
- Work closely with analysts, media teams, developers, and platform specialists
- Provide basic SQL and data literacy support to colleagues
- Document AI workflows and how they tie into underlying data structures
- Contribute to RPA technical documentation, standards, and shared best practices
How You’ll Excel In Your Role
Required Skills
- Bachelor’s degree in Computer Science or equivalent experience
- Demonstration of SQL skills (joins, aggregations, sub-queries, UNION, CASE, understanding of pivots)
- Ability to understand and design entity-relationship models
- Familiarity with LLM tools
- Clear communication skills
- Detail orientation with a proactive, curious mindset
Preferred Skills
- Experience with cloud data warehouses
- Hands-on experience with BigQuery or Google Cloud Platform
- Experience with Domo, Tableau, or similar BI platforms
- Magic ETL, dataflows, or Domo Workflows experience
- Experience with n8n for automation tasks
- Basic Python for automation or API calls
- Understanding of relational and dimensional data modeling
- Prompt engineering or LLM evaluation experience
- Familiarity with REST APIs or connector-based ingestion
We are not able to offer sponsorship for this role now or in the future.
This is an exempt position and is not eligible for overtime compensation.
The monthly salary range for this position is $6,250 - 7,083, with an annualized equivalent of $75,000 - $85,000.
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.
Top Skills
What We Do
RPA is a modern ad agency with a timeless perspective: People First.
We create work that matters to people, for brands that matter to people, in an environment where people matter.
Our #PeopleFirst culture attracts the best talent in the business.
We are a collective of specialists, with deep benches of talent in nearly every discipline a modern marketer needs today. All collaborating together with a shared philosophy and shared goal.
If you share that goal, we want to connect with you.
