Senior Data Engineer — AI-Driven Analytics

Siri InfoSolutions Inc; Los Angeles (CA); On-site; USD 120,000 - 150,000; Full time

Job summary

Siri InfoSolutions Inc is seeking a Data Engineer to design and build data pipelines, semantic layers, and analytics interfaces. You will work onsite in Orlando, FL or Los Angeles, CA with a 1+ year duration and relocation flexibility.

You will implement LLM-driven query generation, governance, and dashboarding, plus integrate with Power BI and multiple data sources. The role emphasizes architectural decisions and documentation across teams.

Qualifications

• 5+ years of full-stack engineering with Python and/or TypeScript/JavaScript.
• Strong SQL and data warehouse experience with Snowflake/BigQuery/Redshift.
• Hands-on with LLM APIs, prompt engineering, and summarization.
• Experience with RAG, embeddings, and vector stores.
• Front-end analytics with React/Next.js and data grids/charts.
• Ability to work independently in ambiguous environments and document decisions.
• Strong technical and functional documentation skills.
• Experience designing governed API layers across systems.
• UI/UX judgment for clear, data-driven experiences.
• Proven dashboard development for financial health, forecast variance, and metrics.

Responsibilities

• Design and build a text-to-SQL pipeline converting natural language questions to safe SQL.
• Create a semantic layer defining table relations and business terms.
• Implement retrieval over schema docs, logic, and examples to improve accuracy.
• Design multi-step agent workflows for clarification and error recovery.
• Integrate LLM providers for query generation, orchestration, and summarization.
• Build guardrails for query validation, costs, and permission-based access.
• Develop evaluation processes to measure query accuracy and detect issues.
• Create analytical UI for results, charts, and AI summaries.
• Support Power BI data models, DAX, and calculated tables.
• Develop API gateways for governed data access across warehouse, Power BI, and AI apps.
• Integrate portfolio reporting data from Smartsheet, Jira, Clarity PPM, ServiceNow, SAP.
• Work with data engineering to maintain clean warehouse schemas.
• Document architecture, APIs, data dictionaries, workflows, and guides.
• Partner with Portfolio Management to define requirements and iterate solutions.
• Design, build, and maintain automated dashboards tracking performance metrics and trends.
• Support planning, prioritization, stakeholder communication, and delivery of high-quality code.

Skills

Python

TypeScript/JS

SQL/Data Warehouse

Snowflake/BigQuery/Redshift

LLM APIs

React/Next.js

Documentation

API Design

CI/CD

Dashboards

Data Modeling

ETL

Cloud/Docker

LangGraph

dbt LookML

Tools

React/Next.js

Job description

Siri InfoSolutions Inc is seeking a Data Engineer to design and build data pipelines, semantic layers, and analytics interfaces. You will work onsite in Orlando, FL or Los Angeles, CA with a 1+ year duration and relocation flexibility.

You will implement LLM-driven query generation, governance, and dashboarding, plus integrate with Power BI and multiple data sources. The role emphasizes architectural decisions and documentation across teams.