Full Stack Software Engineer (AI)
On-siteBurbank Los Angeles County, California, United States
Job Summary
Design and build a text-to-SQL pipeline converting natural-language questions into safe, permission-aware queries while establishing a semantic layer for table relationships and business terminology. Implement multi-step agent workflows to clarify requests, chain tool calls, and recover from errors, integrating LLM providers for orchestration and result summarization. Create guardrails for validation, cost limits, and access control, then design analytical UIs for charts and AI-generated summaries. Support the existing Power BI environment and maintain API gateways for governed data access across the warehouse and AI application. Partner with stakeholders to define requirements, document architecture, and deliver automated dashboards tracking performance metrics and forecast accuracy.
Required Qualifications
- 5+ years of full-stack engineering experience with Python and/or TypeScript/JavaScript, including strong server-side and API design skills
- Strong SQL and data warehouse experience, including schema design, joins, performance, and platforms such as Snowflake, BigQuery, or Redshift
- Hands-on experience with LLM APIs, including prompt engineering, tool calling, structured outputs, and summarization
- Practical experience with RAG architecture, embeddings, vector databases, and common failure modes
- Front-end experience building analytical interfaces using React/Next.js and charting or data-grid libraries
- Ability to work independently in ambiguous, 0-to-1 environments and document key architecture decisions
- Strong technical and functional documentation skills
- Experience designing governed API layers across multiple systems and consumers
- Strong UI/UX judgment with a focus on clear, accessible, data-driven experiences
- Solid engineering fundamentals, including testing, CI/CD, version control, code review, and performance optimization
- Proven track record of developing comprehensive dashboards to monitor business performance, focusing on financial health, forecast-to-actual variance, trend analysis, pipeline prioritization, and strategic outcome value metrics
- Excellent communication skills with the ability to translate complex technical concepts for varied audiences
- Experience with LLM orchestration or agent frameworks such as LangGraph, CrewAI, AutoGen, or custom state-machine orchestration
- Experience evaluating LLM output accuracy and identifying unsupported or hallucinated results
- Bachelor's degree in Computer Science, Information Systems, Software, Electrical or Electronics Engineering, or a comparable field of study, and/or equivalent work
Desired Qualifications
- Power BI experience, including data models, DAX measures, and calculated tables
- Experience with portfolio tools such as Smartsheet or Clarity PPM, and integrations with Jira, SAP, or ServiceNow
- Familiarity with semantic layer tools such as dbt metrics, Cube, or LookML
- Cloud and containerization experience using AWS, GCP, Azure, or Docker
- Experience with caching layers such as Redis for latency-sensitive workloads
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.