Senior Data Engineer (AI & Cloud Platforms)

Job Description

Title: Senior Data Engineer (AI & Cloud Platforms)

\n

Location: Remote

\n

Need U.S. Citizens

\n

\n

About the Role

\n

Rockwoods is hiring a Senior Data Engineer for a high-visibility engagement with an insurance client.

\n

This is not a traditional ETL or reporting role. We are looking for a senior engineer who understands how scalable data systems power modern AI applications including LLM integrations, semantic search, vector-based retrieval, AI-ready data modeling, and production-grade pipelines.

\n

This role is for you if you:

\n

\n
• Enjoy solving messy, complex, real-world data problems.
\n
• Build and optimize scalable systems hands-on.
\n
• Understand performance, scale, and reliability inside out.
\n
• Have moved beyond proof-of-concepts and deployed production-grade solutions.
\n

\n

If you want strong technical influence, architecture ownership, and the opportunity to build modern AI-ready data infrastructure, we’d love to connect.

\n

\n

What You’ll Do

\n

\n
• Build & Scale: Architect and optimize scalable Python + Snowflake + dbt pipelines supporting both analytics and AI production use cases.
\n
• AI Architecture: Design modern data architectures for LLM workflows, RAG patterns, semantic search, and AI-enabled applications.
\n
• Ingestion Frameworks: Develop robust API and event-driven ingestion frameworks for structured and unstructured data.
\n
• AI Readiness: Prepare high-quality, curated datasets optimized for AI/ML inference and downstream consumption.
\n
• Performance & Costs: Fine-tune Snowflake performance, optimize transformation efficiency, and keep compute costs low.
\n
• Reliability & Quality: Improve overall platform reliability, observability, and data quality standards.
\n
• Collaboration & Leadership: Partner with engineering and business teams while establishing modern engineering standards and best practices.
\n

\n

\n

What We’re Looking For

\n

\n
• 7+ years of hands-on Data Engineering experience.
\n
• Core Tech Stack: Strong mastery of Python, Snowflake, SQL, and dbt .
\n
• AI/LLM Experience: Hands-on experience supporting AI/LLM workflows (Open AI, Anthropic, embeddings, vector search, semantic retrieval, or RAG architectures).
\n
• Orchestration: Hands-on experience with Airflow or similar orchestration engines.
\n
• Production Focus: Proven track record of building scalable platforms and handling imperfect enterprise data at scale.
\n
• Autonomy: Ability to lead architectural decisions and work independently in a fast-moving environment.
\n

\n

\n

Nice-to-Haves

\n

\n
• Insurance domain expertise (Claims, Policy, Billing, Underwriting, etc.).
\n
• Experience with specialized vector databases or AI search platforms.
\n
• Exposure to MLOps or end-to-end AI deployment workflows.
\n
• Experience designing reusable enterprise data frameworks.
\n

\n