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 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. 

Job Tags

Similar Jobs