Data Engineer

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

Data Engineer

Location: Orlando, FL or Los Angeles, CA
Must be willing to relocate/work onsite (2 weeks' notice from time of offer accept)
Zero exceptions will be made, as this is corporate policy - no delayed remote start, no remote work
Duration: 1+ year

What You'll Do

• 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.

Required Skills & Experience

• 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.

Preferred 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.
• The conversation explored both technical and business-facing requirements.

Core Technical Requirements Discussed

• Power BI development experience
• ETL experienceSnowflake knowledge
• Reporting platform expertise (future-state need)
• Reporting development background

Additional Desired Skills

Smartsheet experience was mentioned as a desirable but difficult-to-find qualification.

Experience Level

The original role referenced:

• Senior-level experience
• Five-plus years of experience

The participants also discussed remaining flexible and evaluating candidates based on actual capability rather than strictly on years of experience.

Onsite Expectations

• Four days per week onsite.

Schedule Expectations

• The candidate must be flexible enough to support stakeholders across multiple time zones.

The discussion highlighted:

• East Coast candidates may need to work later hours.
• West Coast candidates may need earlier starts.
• The goal is reasonable overlap with both coasts rather than extreme schedules.