AI Data Platform Engineer

Jet Support Services, Inc. (JSSI); Chicago (IL); On-site; USD 120,000 - 180,000; Full time

Job summary

Jet Support Services, Inc. (JSSI) is building an AI‑first data platform. The AI Data Engineer will own data pipelines, lakehouse, and governance to enable AI and analytics across the organization.

You will ensure data quality, leverage Claude Code, and collaborate across business units to accelerate AI delivery. This is an individual contributor role focused on building scalable data infrastructure. We value hands‑on proficiency with Fabric, lakehouse architectures, Power BI Direct Lake, and

Qualifications

• Hands-on experience building and maintaining data pipelines in Microsoft Fabric, including Lakehouse architecture and OneLake.
• Proficiency with Bronze / Silver / Gold medallion architecture and semantic layer modeling.
• Experience with Azure SQL, ADLS Gen2, and data ingestion across multiple source systems.
• Understanding of data governance, security, and PII handling practices, including Entra ID alignment.
• Experience exposing data products via APIs or MCP‑style interfaces for downstream AI or analytics consumption.
• Active use of AI coding tools (such as Claude Code) as part of your development workflow — not aspirational, but current practice.

Responsibilities

• Own Bronze / Silver / Gold pipelines in Microsoft Fabric and OneLake.
• Model governed semantic layers; serve Power BI via Direct Lake.
• Ingest business‑unit data into Fabric & Azure SQL with quality and lineage controls.
• Enforce data governance, security, and PII handling aligned to Entra ID.
• Expose curated datasets to AI agents through approved MCP servers only.
• Use Claude Code to build pipelines against JSSI standards; review and validate all AI‑generated code before it ships.
• Orchestrate, monitor, and optimize pipelines for reliability, performance, and Fabric capacity (CU) cost.
• Manage Git‑based version control and Fabric deployment pipelines across dev / test / prod.
• Handle ad‑hoc requests (report enhancements and fixes, and dataset enhancements and fixes) across Microsoft Fabric and Power BI.
• Build and maintain paginated (operational) reports; write, debug, and tune SQL for reporting, data investigation, and fixes.
• Use Claude Code to investigate and diagnose platform, data‑quality, and reporting issues; trace root cause across pipelines and semantic models.
• Support and optimize Power BI semantic models and DAX for downstream consumers.

Skills

Fabric Lakehouse

OneLake

Semantic layer modeling

Power BI Direct Lake

Azure SQL

Data governance

PII handling

Claude Code

APIs for data products

AI data pipelines

Tools

Claude Code

Direct Lake

Power BI

Job description

Jet Support Services, Inc. (JSSI) is building an AI‑first data platform. The AI Data Engineer will own data pipelines, lakehouse, and governance to enable AI and analytics across the organization.

You will ensure data quality, leverage Claude Code, and collaborate across business units to accelerate AI delivery. This is an individual contributor role focused on building scalable data infrastructure. We value hands‑on proficiency with Fabric, lakehouse architectures, Power BI Direct Lake, and