Senior Full-Stack Data & AI Engineer – Portfolio Analytics

Milestone Technologies, Inc.; Burbank (CA); On-site; USD 120,000 - 150,000; Full time

Job summary

Milestone Technologies, Inc. is seeking a seasoned Data & BI Architect to design and build a text-to-SQL layer and a semantic data model for enterprise portfolio management.

You will integrate data from multiple upstream systems, define metrics, and deliver trusted insights through dashboards and charts in Power BI. The greenfield project emphasizes architecture, AI pipelines, and maintainable documentation.

Qualifications

• Strong SQL and data warehouse design experience.
• Hands-on with Snowflake, BigQuery, or Redshift.
• Experience building dashboards in Power BI.
• Experience with LLM APIs and agent frameworks.
• Front-end analytics interfaces using React/Next.js.
• Excellent documentation skills.
• Ability to work in ambiguous, 0-to-1 environments and document architecture decisions.
• Experience designing governed API layers across multiple systems and consumers.
• Cloud and containers: AWS/GCP/Azure/Docker.

Responsibilities

• Design a text-to-SQL pipeline converting 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 and business logic to improve accuracy.
• Design multi-step agent workflows that clarify requests, chain tool calls, and recover from query errors.
• Integrate LLM providers 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 a clear analytical UI for results, charts, and AI-generated summaries.
• Support the existing Power BI environment, including data models and DAX measures.
• Design and maintain API gateways for governed data access across the warehouse, Power BI, and AI application.
• Integrate portfolio reporting data from Smartsheet, Jira, Clarity PPM, ServiceNow, and SAP.
• Partner with data engineering to maintain clean warehouse schemas.
• Own architecture documentation and user guides.
• Collaborate with Portfolio Management to define requirements and iterate on solutions.
• Design, build, and maintain automated dashboards tracking performance metrics and forecast accuracy.

Skills

Strong SQL

Data warehouse

React/Next.js

LLM APIs

Python

CI/CD

Dashboard design

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

BigQuery

Redshift

LookML

dbt

Power BI

Jira

ServiceNow

SAP

LangGraph/CrewAI

Job description

Milestone Technologies, Inc. is seeking a seasoned Data & BI Architect to design and build a text-to-SQL layer and a semantic data model for enterprise portfolio management.

You will integrate data from multiple upstream systems, define metrics, and deliver trusted insights through dashboards and charts in Power BI. The greenfield project emphasizes architecture, AI pipelines, and maintainable documentation.