AI-Powered Full-Stack Engineer for Enterprise Analytics

247Hire; Burbank (CA); On-site; USD 140,000 - 190,000; Full time

Job summary

247Hire is building an AI-powered analytics platform for enterprise portfolio management. This role will design, build, and maintain reporting solutions that integrate data from our portfolio management system and multiple upstream systems, defining key metrics and delivering trusted insights for leadership.

This is a greenfield project focused on architecture, the semantic layer, and the AI pipeline, with supporting work in an existing Power BI environment.

Qualifications

• 5+ years of full-stack engineering experience with Python and/or TypeScript/JavaScript.
• Strong SQL and data warehouse experience with modern platforms.
• Hands-on experience with LLM APIs, prompt engineering, and summarization.
• Experience with RAG architecture, embeddings, and vector databases.

Responsibilities

• Design and build a text-to-SQL pipeline converting natural-language questions into safe SQL queries.
• Build a semantic layer defining table relationships, meanings, and business terminology.
• Integrate LLM providers for query generation, orchestration, and result summarization.
• Create automated dashboards and an analytical UI to visualize results and value metrics.

Skills

Full-stack engineering

Python

TypeScript/JavaScript

SQL & data warehouse

LLM APIs

RAG architecture

React/Next.js

CI/CD

Documentation

Architectural decisions

Education

Bachelor's degree in CS / related field

Tools

Snowflake

BigQuery

Redshift

Job description

247Hire is building an AI-powered analytics platform for enterprise portfolio management. This role will design, build, and maintain reporting solutions that integrate data from our portfolio management system and multiple upstream systems, defining key metrics and delivering trusted insights for leadership.

This is a greenfield project focused on architecture, the semantic layer, and the AI pipeline, with supporting work in an existing Power BI environment.