What are the responsibilities and job description for the Junior Business System Analyst (AI & Data Focus) position at H/L Agency?
Are you starting your journey in the tech world and excited to explore how data and AI can solve real-world business challenges? This role is an opportunity to build technical skills and gain hands-on experience in data automation, Python scripting, and AI-driven solutions while working at the intersection of marketing and technology.
We’re looking for a curious and motivated learner with a foundation in data, SQL, and coding who’s ready to grow and contribute to cutting-edge data projects in a fast-evolving industry.
This is a hybrid role, with both office-based work at the H/L Oakland office and remote work.
WHAT YOU’LL DO:
Learn how to build and manage data automation processes within a modern marketing technology ecosystem.
- Collaborate with data engineers to help build systems that automate and store data from platforms like Facebook, Google Ads, LinkedIn, and Marketo
- Work on data projects using Python, SQL, and AI tools (like GPT) to automate tasks, improve data quality, and deliver client-facing dashboards
- Help create and manage ETL (Extract, Transform, Load) processes to move data efficiently between systems
- Contribute to documentation efforts and help map out processes for automation and reporting
- Support dashboard development (using tools like Tableau) and assist in generating actionable insights
ABOUT YOU:
We’re not looking for a seasoned pro—just someone excited to grow and build their technical skills. Here’s what will set you up for success:
- Basic SQL knowledge (you know how to write queries and work with databases)
- A foundation in Python—even if it’s from personal projects, classes, or online courses
- An interest in AI tools and automation—you’re curious about how GPT and other AI technologies can help solve problems
- Some exposure to digital marketing concepts or data is a plus, but not required
- A collaborative mindset—you enjoy working with others and are not afraid to ask questions
THE IDEAL CANDIDATE:
- You’re eager to learn new technologies and apply them to solving real problems
- You enjoy tinkering and problem-solving, whether it’s writing scripts, building dashboards, or finding ways to improve processes
- You’re detail-oriented and willing to dig into data to ensure accuracy and quality
- You’ve completed projects or coursework in data, coding, or analytics
- You want to grow your career in data, automation, and AI
WHY JOIN US:
- Hands-on experience with modern tools and AI technologies in the data space
- Mentorship and guidance from experienced data engineers and AI experts
- Opportunities for growth in data automation, AI tools, and marketing analytics
- A collaborative, supportive environment that encourages innovation and continuous learning
For SF Bay Area / CA based: H/L offers a projected salary range for a position as an estimate of what the company believes is a reasonable pay scale. The salary range for this position is expected to be between $69,000 and $75,000 per year. The actual salary offered to a successful candidate will depend on various factors, including the job’s scope and responsibilities, the candidate’s qualifications, budget availability, internal pay equity, geographic location, and external market pay rates for similar positions. These factors will determine the final compensation, which may vary within the stated range.
Due to the high volume of applications we receive, we are unable to provide an individual response to every candidate.
About H/L:
Since 1985, H/L has been fiercely independent and Making Momentum. Our strengths include local and national media activations, creative development, insights and analytics, full-scale digital and video production, multicultural marketing, and PR.
We’re headquartered in Oakland, California, with people in 21 states and offices in Atlanta, Miami, Phoenix, and St. Louis. What unites H/Lers across the country is a common drive: to pioneer new ways to push clients’ businesses forward and serve the communities we call home.
Learn more at www.hl.agency.
Salary : $69,000 - $75,000