AI / Full Stack Software Engineer
Creative Solutions Services, LLC
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
Software Resources is actively seeking a Senior AI / Full Stack Software Engineer for a greenfield, contract role in Burbank, CA, onsite 4 days a week with remote Fridays. You'll build a text-to-SQL layer, a semantic data layer, and an AI pipeline, while supporting an existing Power BI environment and API gateways across a data warehouse ecosystem.
The ideal candidate has 5+ years of experience in full-stack development, strong SQL/data warehouse skills (Snowflake/BigQuery/Redshift), and
Qualifications
- 5+ years of full-stack engineering experience with Python and/or TypeScript/JavaScript, including server-side and API design.
- Strong SQL and data warehouse experience with Snowflake, BigQuery, or Redshift.
- Hands-on experience with LLM APIs, prompt engineering, tool calling, structured outputs, and summarization.
- Experience with RAG architecture, embeddings, vector databases, and failure modes.
- Frontend experience with React/Next.js and charting/data-grid libraries.
- Ability to work independently in ambiguous environments and document architecture decisions.
- Strong technical and functional documentation skills.
- Experience designing governed API layers across multiple systems.
- Strong UI/UX judgement for data-driven interfaces.
- CI/CD, testing, version control, and performance optimization.
- Proven dashboards development for monitoring business performance.
Responsibilities
- Design and build a text-to-SQL pipeline converting natural-language questions into permission-aware SQL queries.
- Create a semantic layer defining table relationships, meanings, and business terminology.
- Implement retrieval over schema documentation, business logic, and query examples to improve accuracy.
- Design multi-step agent workflows with clarifications, tool calls, and error recovery.
- Integrate LLM providers for query generation, orchestration, and result summarization.
- Build guardrails for query validation, cost limits, row limits, and access control.
- Develop evaluation processes for query accuracy and detection of unsupported outputs.
- Design and maintain an analytical UI for results, charts, and AI summaries.
- Support Power BI environment including data models, DAX measures, and calculated tables.
- Develop API gateways for governed data access across warehouse, Power BI, and AI app.
- Integrate portfolio reporting data with tools like Smartsheet, Jira, Clarity PPM, ServiceNow, SAP.
- Collaborate with data engineering to maintain clean warehouse schemas.
- Own architecture docs, APIs, data dictionaries, workflows, and user guides.
- Partner with Portfolio Management to define requirements and iterate on solutions.
- Design, build, and maintain dashboards tracking performance metrics and business value.
- Support planning, prioritization, stakeholder communication, and high-quality code delivery.
Skills
Education
Tools
Job description
Software Resources has an immediate, contract job opportunity for a AI / Full Stack Software Engineer with a major corporation in Burbank, CA. 4 days per week onsite, Remote Fridays. The candidate must be flexible enough to support stakeholders across multiple time zones.
10+ month contract Pay Rate: $80 - $86/hr DOE
We are building an agentic natural-language query layer for enterprise portfolio management reporting. This platform will deliver standardized data, analytics, and visualizations for enterprise portfolio management reporting. It will enable business users to ask plain-English questions about technology projects, resources, timelines, budgets, and milestones and receive accurate answers, charts, and dashboards. This role will design, build, and maintain reporting solutions that integrate data from our portfolio management system and multiple upstream systems, define key metrics, and provide trusted, actionable insights that enable leadership to make strategic, data-driven decisions.
This is a greenfield build focused on architecture, the semantic layer, and the AI pipeline. The role will also support an existing Power BI environment as a separate workstream.
Clear technical and functional documentation will be critical to maintainability, adoption, and stakeholder confidence.
- Design and build a text-to-SQL pipeline that converts natural-language questions into safe, permission-aware SQL queries.
- Build a semantic layer that defines table relationships, column meanings, and business terminology.
- Implement retrieval over schema documentation, business logic, and query examples to improve accuracy.
- Design multi-step agent workflows that can clarify requests, chain tool calls, and recover from query errors.
- Integrate LLM providers (OpenAI, Anthropic, etc.) for query generation, orchestration, and result summarization.
- Build guardrails for query validation, cost limits, row limits, and permission-based access.
- Create evaluation processes to measure query accuracy and detect unsupported outputs.
- Design and build a clear analytical UI for results, charts, and AI-generated summaries.
- Support the existing Power BI environment, including data models, DAX measures, and calculated tables.
- Design and maintain API gateways for governed data access across the warehouse, Power BI, and AI application.
- Integrate portfolio reporting data, project information, and health metrics from tools such as Smartsheet, Jira, Clarity PPM, ServiceNow, and SAP.
- Partner with data engineering to maintain clean, well-documented warehouse schemas.
- Own technical and functional documentation, including architecture, APIs, data dictionaries, workflows, and user guides.
- Partner with the Portfolio Management team and business stakeholders to define requirements and iterate on solutions.
- Design, build, and maintain automated dashboards that track performance metrics, identify historical trends, analyze forecast accuracy, and visualize business value outcomes to drive data-backed prioritization decisions.
- Support planning, prioritization, stakeholder communication, and delivery of high-quality code.
- 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.
- 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.
- Power BI development experience
- ETL experience
- Snowflake knowledge
- Reporting platform expertise (future-state need)
- Reporting development background
Smartsheet experience was mentioned as a desirable but difficult-to-find qualification.
Senior-level experience, Five-plus years of experience
Bachelor's degree in Computer Science, Information Systems, Software, Electrical or Electronics Engineering, or a comparable field of study, and/or equivalent work
Software Resources, founded more than 3 decades ago, is a trusted staffing partner specializing in Technology (IT, Creative, & Marketing), Finance, & Accounting placements. We work with companies nationwide that need skilled professionals and connect them with candidates like you looking for the right opportunity.
We are always looking for professionals at all experience levels and in various specialties to meet our clients' hiring needs. As a member of our team, you will have access to benefits including medical, dental, and vision coverage, a 401(k) with company match, short-term disability, life insurance with AD&D.
If this position fits interests you, we encourage you to apply. You can view all our job openings at Software Resources Careers.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
