Junior Data Engineer (Marketing)
Summary
Builds AI-driven marketing automation and data pipelines to replace manual processes, ensuring clean, real-time data for campaign analytics and reporting using Python, SQL, and Supabase.
Location: Newport Beach, CA | On-site ||| Employment Type: Full-time
About the Role
Are you ready to lead a marketing transformation through quality assurance and automation? As the Junior Data Engineer (Marketing), you’ll be the driving force behind ensuring the quality and performance of our marketing systems. This role builds the data and automation backbone for TRA’s marketing operations - replacing manual Google Sheet processes, automating data cleaning, and enabling real-time reporting across all campaigns. This role ensures that marketing, analytics, and operations teams have accurate, unified, and data from all sources (radio, digital ads, affiliates, CRM, etc.).
What You'll Do
Build and maintain the unified database
- Develop ETL/ELT pipelines pulling from internal systems and third-party APIs into a centralized warehouse
- Write and optimize SQL for transformations and reporting layers
- Model data so it's consistent and documented across sources
API integration
- Build and test integrations against REST APIs
- Handle authentication, pagination, rate limits, and error handling
- Write tests that catch failures early
Data quality ownership
- Build validation and monitoring to catch missing, duplicate, corrupted, or inconsistent records before they reach a dashboard
- Investigate discrepancies and reconcile against source systems
- Establish reusable automated checks
Deployment and automation
- Set up and maintain CI/CD pipelines
- Deploy and monitor scheduled jobs on cloud infrastructure
- Maintain clean version control and participate in code review
Testing and code quality
- Write unit and integration tests for pipelines, integrations, and internal services
- Maintain and grow test coverage as the codebase expands
- Participate in code review and help keep engineering standards consistent across the team
What You Bring
- Bachelor's degree in Computer Science, Data Science, or a related technical field
- 1+ year of hands-on experience (internships and substantial project work count)
- Proficiency in Python and SQL
- Experience calling, testing, and debugging REST APIs
- Working knowledge of Git
- Working familiarity with AWS and/or Azure
- Understanding of CI/CD and automated deployment
- Strong technical reading comprehension and attention to detail
Nice to Have: PostgreSQL, Supabase, Power BI, FastAPI, Docker, dbt/Airflow, or experience working with LLM APIs. Don't have all of these? No problem — we're happy to help you grow into them.
What We Offer
- Comprehensive health, dental, and vision insurance
- Supplemental benefits like: Life Insurance, flexible spending, and many more...
- 401k with a 4% employer match
Compensation: $80,000 - $85,000 per year, depending on experience
Application Process
Qualified applicants will be invited to complete a brief AI-facilitated interview designed to help us learn more about your experience and qualifications. After the AI interview, a member of our recruiting team will personally review your responses and follow up with next steps if you're selected to move forward. This AI tool is used solely to support our recruiters in the initial screening process -- all final hiring decisions are made by our talent acquisition team.
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law. is an Equal Opportunity Employer. We value diversity and encourage all qualified individuals to apply.
Skills
As published by greenhouse · 14 questions · 2 written answers
Basics
First Name, Last Name, Email, Phone, Resume/CV, Cover Letter
Short answers (3)
- Preferred First Name optional
- What is your available start date?
- Where do you currently reside (City, State)?
Pick from a list (9)
- Have you worked for this company or any related entities in the past?
- Do you have any relatives or friends currently working at the company?
- What is your desired salary?
- Are you legally authorized to work in the US and can you provide proof if offered a position?
- Are you currently authorized to work in the United States without the need for visa sponsorship, now or in the future?
- Are you at least 18 years or older?
- Are you willing to undergo a background check, in accordance with local law/regulations?
- Are you able to commit to a daily commute to Irvine, CA?
- Do you consent to receiving SMS from TRA at the number provided? Message and data rates may apply. Messaging frequency may vary. You can opt out at any time by texting STOP. For assistance, text HELP or visit our website at www.tra.com. Visit https://tra.com/cms/privacy-policy for privacy policy and www.tra.com for Terms of Service. optional
Written answers (2)
- How many years of experience do you have in marketing automation or campaign operations? In which professional role(s)?
- Which Marketing and Sales Automation Platforms or CRMs (e.g. Cake, HubSpot, Salesforce, Zapier) do you have experience working with? In which professional role(s)?