Junior AI Data Engineer (Marketing)

Tax Relief Advocates is a client-focused company dedicated to guiding individuals through the tax resolution process with integrity, empathy, education, and care. The Junior AI Data Engineer (Marketing) will build and maintain data pipelines, API integrations, automated quality checks, and deployment processes that support accurate, unified, AI-ready marketing data and real-time campaign reporting.

What you'll do:

• 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
• Build and test integrations against REST APIs
• Handle authentication, pagination, rate limits, and error handling
• Write tests that catch failures early
• 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
• Set up and maintain CI/CD pipelines
• Deploy and monitor scheduled jobs on cloud infrastructure
• Maintain clean version control and participate in code review

What they're looking for:

• 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
• Location: Irvine, CA - onsite
• Position Type: Full-time, permanent
• PostgreSQL, Supabase, Power BI, FastAPI, Docker, dbt/Airflow, or experience working with LLM APIs