> Markdown version of [/jobs/ext/1350065-ai-engineer-hybrid](https://www.wearedevelopers.com/jobs/ext/1350065-ai-engineer-hybrid). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # AI Engineer - Hybrid - **Company:** Jobot - **Location:** Addison, United States - **Experience:** Experienced - **Salary:** $120,000.0 - $160,000.0 - **Contract:** Permanent contract - **Skills:** Query Performance, Microsoft Windows, Application Programming Interfaces (APIs), Artificial Intelligence, ARM Architecture, Continuous Integration, Information Engineering, Data Infrastructure, Extract Transform Load (ETL), Data Transformation, Data Warehousing, Database Queries, Monitoring of Systems, Python (Programming Language), NoSQL, Operational Databases, Query Optimization, QuickBooks (Software), Role-Based Access Control, Sage Accounting, Runbook, Search Technologies, Microsoft SharePoint, SQL Databases, Scripting, File Transfer Protocol (FTP), Macros, Data Ingestion, Large Language Models, Snowflake, Prompt Engineering, Data Lineage, Star Schema, Nintex, Machine Learning Operations, Domo, Api Design, Restful APIs - **Published:** July 19, 2026 - **Apply:** https://www.dice.com/job-detail/0f26a130-689d-4b56-9eaf-386de396c03b ## About the Role Data Warehouse (required) Snowflake + Cortex AI (Cortex Agents, Cortex Search, Cortex Analyst, Semantic Views) Data Ingestion (required) Fivetran (strongly preferred); Airbyte or equivalent considered; Domo Writeback (transitional); Python for uncovered sources Data Transformation (required) dbt - models, tests, sources, snapshots, incremental, CI/CD BI / Visualization Domo (read-only MART layer) AI / LLM Claude (Anthropic) - direct API and via Cortex Field Service Platform ServiceTitan Productivity Stack Microsoft 365, SharePoint, Teams What We're Looking For Required - Data Engineering * 4+ years owning production data pipelines as a data engineer or analytics engineer * Expert SQL; strong data modeling - star schema, SCD Types 1/2, incremental load patterns * Hands-on dbt in production - models, tests, sources, snapshots, macros, CI/CD, project ownership * Managed connector experience - Fivetran strongly preferred; Airbyte, Stitch, or equivalent considered if connector setup, schema mapping, schema change policies, and MAR/MTU cost management are demonstrated * Direct Snowflake experience - schema design, warehouse management, RBAC, query optimization, task scheduling; SnowPro Core preferred * Domain MART design - grain, SLA, ownership, and data contracts a small team can maintain * Pipeline monitoring and observability - SLA definition, drift alerting, and incident response before business users are impacted; experience with Elementary, Monte Carlo, or dbt's built-in freshness and source monitors preferred * Python for custom ingestion - SFTP, REST APIs, email-delivered files * Data quality as default - dbt tests, freshness monitors, and schema assertions in every pipeline Required - AI Foundation * Genuine drive to build AI capabilities; understands clean data is the prerequisite to reliable AI * LLM API experience (Anthropic, OpenAI, or equivalent) - prompt engineering, structured outputs, basic agent patterns * Familiarity with RAG and vector search; able to implement Cortex Search without prior vector DB experience * Python for pipeline scripting and API integration Preferred * Snowflake Cortex AI hands-on - Cortex Analyst, Cortex Search, Cortex Agents, or Semantic Views * Multi-location or multi-brand data environment * ServiceTitan or field service platform experience * AI governance framework experience (NIST AI RMF or equivalent) ## Description Our client is a collection of industry-leading residential and commercial HVAC, electrical, and plumbing companies. Our mission is to provide exceptional residential and commercial services by upholding the legacies of our brand partners, empowering their growth, elevating performance, and enhancing the quality of life in the communities we serve., 1. Data Engineering & Snowflake Platform | Primary Focus * Design and own the three-layer Snowflake architecture: RAW STAGING MART * Build and maintain domain MARTs (operations, call center, finance, workforce, marketing) using dbt - grain, ownership, SLA, and data contracts defined per MART * Own Snowflake RBAC - Domo read-only on MART, AI scoped to mart.ai_features, row-level policies and masking applied where needed * Build and maintain Semantic Views as the authoritative metric layer (booked rate, avg ticket, revenue per tech per day) - single source of truth for all tools * Monitor pipeline health, warehouse costs, and query performance; optimize proactively 2. Data Ingestion & ETL/ELT | Core Ownership * Own ingestion end-to-end - Fivetran is the primary tool; configure and manage connectors for ServiceTitan, QuickBooks/Sage Intacct, Paycom, CCaaS, and marketing platforms * Handle sources Fivetran does not cover with lightweight Python scripts (SFTP, REST APIs, email-delivered files); bias toward replacing custom scripts with managed connectors over time * Own the dbt project as an engineering artifact - structure, CI/CD, dev/prod environments, packages, documentation * Manage schema drift - catch upstream source changes before they break downstream MARTs; configure Fivetran schema change policies and dbt source assertions * Define and maintain pipeline SLAs and alerting - failures surface before business users notice * Own data lineage - every MART table traceable to source via dbt lineage graph * Manage Fivetran MAR costs - optimize sync frequency without sacrificing freshness 3. AI Engineering | Built on the Data Foundation * Implement Cortex Analyst + Semantic Views for NL-to-SQL querying of MARTs - no SQL required for GMs and ops users * Build enterprise knowledge search via Cortex Search - SOPs, runbooks, and operational docs indexed within the Snowflake perimeter * Deploy Cortex Agents orchestrating across Cortex Search and Cortex Analyst for multi-step business questions * Connect external systems (ServiceTitan, M365) via Snowflake MCP Server; use N8N or LangChain for workflows outside Snowflake * Build AI feature pipelines in mart.ai_features under the same governance standards as all other MARTs 4. Governance & Enablement * Define AI governance framework: acceptable use, risk tiers, PII handling, vendor evaluation * Ensure AI pipelines inherit existing Snowflake RBAC and masking - no parallel governance layer * Train end users on CoWork and Cortex Analyst; build internal tools for ops, finance, and service teams First 90 Days * Audit Domo pipelines and produce a source inventory - ingestion method, refresh schedule, and downstream consumers for every source * Stand up Snowflake three-layer architecture, RBAC, and dbt project scaffold with dev/prod environments * Configure first Fivetran connectors (ServiceTitan first); ship mart.operations with dbt tests passing and Domo read-only connected * Deliver AI governance framework and acceptable use policy * Present 12-month roadmap to leadership - ingestion milestones gating MART build gating AI capabilities ## Related Videos - [Leveraging Real time data in FSIs](https://www.wearedevelopers.com/videos/806-leveraging-real-time-data-in-fsis) - [Shipping Faster with Less: Render on Cloud Hosting, AI Workloads, and the Future of DevOps](https://www.wearedevelopers.com/videos/1894-shipping-faster-with-less-render-on-cloud-hosting-ai-workloads-and-the-future-of-devops) - [NoSQL Data Modeling for Front-end Developers](https://www.wearedevelopers.com/videos/297-nosql-data-modeling-for-front-end-developers) - [AI in Production: applied AI & enterprise use cases](https://www.wearedevelopers.com/videos/100130-ai-in-production-applied-ai-enterprise-use-cases) - [Developer Experience, Platform Engineering and AI powered Apps](https://www.wearedevelopers.com/videos/990-developer-experience-platform-engineering-and-ai-powered-apps) - [Tomorrow's cloud data platforms - fully managed database-as-a-service (DBaaS)](https://www.wearedevelopers.com/videos/254-tomorrow-s-cloud-data-platforms-fully-managed-database-as-a-service-dbaas) ## Related Articles - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Best US AI Conferences for CTOs in 2026: Build vs. Buy, Vendor Evaluation, and Peer Intelligence](https://www.wearedevelopers.com/magazine/736-best-us-ai-conferences-for-ctos-in-2026-build-vs-buy-vendor-evaluation-and-peer-intelligence) - [From Prototype to Production: Build AI Agents with This Free 4-Course Learning Path](https://www.wearedevelopers.com/magazine/655-from-prototype-to-production-build-ai-agents-with-this-free-4-course-learning-path) - [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift)