Remote Data Engineer — Snowflake & Data Pipelines

Full Tilt Data, LLC; United States; Remote; USD 110,000 - 150,000; Full time

Benefits offered by this job

Health benefits

Discretionary bonuses

Professional development reimbursement

Job summary

Full Tilt Data, LLC is seeking a Data Engineer, Snowflake (Mid-Level) to build scalable cloud data solutions for a federal program. You will design data pipelines, develop training- and production-ready data models, and enable AI-assisted search with Snowflake Cortex Search.

A background check equivalent to a Federal Public Trust is required, and quarterly in-person meetings may be needed. You will collaborate with a fast-paced team, contribute to CI/CD pipelines, and advance data sharing and

Qualifications

• 3–5+ years of data engineering experience, with 1–2 years in Snowflake.
• Strong SQL and Snowpark (Python) skills for pipelines.
• Knowledge of star schema and fact/dimension modeling.
• Experience with structured and semi-structured data (VARIANT, JSON, Parquet).
• Familiarity with Git-based CI/CD workflows.
• Ability to obtain/maintain a Federal Public Trust clearance.

Responsibilities

• Design, build, and maintain data pipelines in Snowflake using SQL and Snowpark (Python).
• Develop and improve canonical/unified data models (UDM) for onboarding datasets.
• Implement RAG and vector search with Snowflake Cortex Search and VECTOR data types.
• Contribute to Snowflake CI/CD pipelines (schemachange, dbt, Snowflake CLI/DevOps).
• Develop Python-based integrations between OPA/Rego and Snowflake for access controls.
• Support Secure Data Sharing, OCR workflows, and Streamlit-in-Snowflake apps.
• Package patterns into reusable reference implementations for agencies.
• Participate in weekly standups and monthly status reporting.

Skills

SQL

Snowpark (Python)

Dimensional modeling

CI/CD workflows

Git

Public Trust clearance

Tools

Snowflake

dbt

schemachange

Snowflake CLI/DevOps

Job description

Full Tilt Data, LLC is seeking a Data Engineer, Snowflake (Mid-Level) to build scalable cloud data solutions for a federal program. You will design data pipelines, develop training- and production-ready data models, and enable AI-assisted search with Snowflake Cortex Search.

A background check equivalent to a Federal Public Trust is required, and quarterly in-person meetings may be needed. You will collaborate with a fast-paced team, contribute to CI/CD pipelines, and advance data sharing and