Hybrid Data Engineer: Snowflake, dbt & AI Pipelines

Australia-Employment; Addison (TX); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Top benefits

Great culture

Job summary

Jobot is seeking a Data Engineer to design and own a three-layer Snowflake data architecture in Addison, TX. The role focuses on building MARTs, managing RBAC, and embedding AI-enabled data workflows.

You'll handle ingestion, pipeline quality, and governance while optimizing costs and performance. Ideal candidates bring 4+ years of experience building production data pipelines, expertise in SQL and data modeling, and hands-on dbt, Snowflake, and Fivetran.

Qualifications

• 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

Responsibilities

• Design and own the three-layer Snowflake architecture: RAW → STAGING → MART
• Build and maintain domain MARTs 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)
• Monitor pipeline health, warehouse costs, and query performance; optimize proactively
• Own ingestion end-to-end - Fivetran connectors for ServiceTitan, QuickBooks/Sage Intacct, Paycom, CCaaS, and marketing platforms
• Handle sources Fivetran does not cover with lightweight Python scripts; 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
• 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
• Implement Cortex Analyst + Semantic Views for NL-to-SQL querying of MARTs
• Build enterprise knowledge search via Cortex Search - SOPs, runbooks, and operational docs
• Deploy Cortex Agents orchestrating across Cortex Search and Cortex Analyst
• Connect external systems via Snowflake MCP Server; use N8N or LangChain for workflows
• Build AI feature pipelines in mart.ai_features under governance standards

Skills

SQL

Data modeling

dbt

Fivetran

Python

Snowflake

Tools

Snowflake

dbt

Fivetran

Python

Job description

Jobot is seeking a Data Engineer to design and own a three-layer Snowflake data architecture in Addison, TX. The role focuses on building MARTs, managing RBAC, and embedding AI-enabled data workflows.

You'll handle ingestion, pipeline quality, and governance while optimizing costs and performance. Ideal candidates bring 4+ years of experience building production data pipelines, expertise in SQL and data modeling, and hands-on dbt, Snowflake, and Fivetran.