Data Engineer

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 experience
Snowflake 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.