Lead Data Engineer – AI/Machine Learning

Cincinnati, OH, US Senior Data Engineer

Interested in this Data Engineer role at Core specialty?

Apply Now →

Skills & Technologies

AwsAzureEmbeddingsGcpLangchainLlamaindexOpenaiPgvectorPineconePrompt Engineering

About This Role

AI job market dashboard showing open roles by category

We are looking for a Lead AI Engineer to help shape and drive AI/ML enablement and readiness across the organization. This role requires strong data engineering fundamentals: you will start hands-on, contributing directly to our data platform and pipelines, while progressively taking on a leading role in defining how the organization builds, deploys, and governs AI/ML capabilities.

Reporting directly to the VP, Head of Data, you will work autonomously to identify gaps, propose solutions, and bring innovative thinking to how our data and AI/ML ecosystem should evolve. You will partner closely with Data Governance, Data Engineering, and Product stakeholders to define our AI/ML frameworks and MLOps strategy, and to ensure the organization is well-positioned to adopt AI/ML responsibly and at scale.

Key Accountabilities/Deliverables:

  • Design, build, and optimize data pipelines, ingestion frameworks, and platform components that support analytics, reporting, and AI/ML use cases.
  • Take direct, autonomous ownership of complex engineering initiatives, from technical design through implementation and rollout, with minimal need for oversight.
  • Identify and resolve performance, scalability, and reliability issues across the existing data platform.
  • Bring innovative, well-reasoned solutions to data engineering problems, proactively identifying gaps and proposing improvements rather than waiting for direction.
  • Write clean, well-tested, well-documented code and infrastructure-as-code, maintaining strong engineering hygiene across your work.
  • Help define the organization's AI/ML frameworks, evaluating and recommending tools, platforms, and standards for building and deploying AI/ML solutions.
  • Build working prototypes that provide immediate value to the engineering teams
  • Shape and help implement our MLOps strategy, including approaches to model deployment, monitoring, versioning, and lifecycle management
  • Partner in deep, ongoing collaboration with Data Governance to ensure AI/ML frameworks and practices align with data governance, security, and compliance standards.
  • Design and advocate for data infrastructure patterns that support AI/ML use cases at scale (e.g., feature stores, curated/governed datasets, streaming access for training and inference).
  • Partner with Data Science, Data Engineering, and business stakeholders to assess AI/ML readiness gaps and build a roadmap to close them.
  • Act as a subject-matter expert and thought partner to the VP, Head of Data on emerging AI/ML technologies, practices, and industry trends.
  • Document AI/ML standards, frameworks, and decisions to support consistent adoption across the organization as the practice matures.
  • Act as a senior technical resource for the team, providing guidance on architecture, design patterns, and best practices AI/ML readiness and ML Ops frameworks
  • Partner closely with Enterprise Architecture on establishing architectural blueprints for AI readiness
  • Other Duties as Assigned.

Technical Knowledge and Understanding:

Data Engineering

  • Strong data engineering fundamentals: deep expertise in data pipeline design, optimization, and distributed data processing (e.g., Spark, dbt, Airflow, Kafka, or equivalent).
  • Platforms: hands-on experience with Snowflake, Databricks, and/or Azure Synapse Analytics, with the ability to architect and optimize workloads on one or more of these platforms.
  • Strong knowledge of cloud platforms (AWS, Azure, or GCP) and modern data warehouse/lakehouse architectures.

AI/ML Engineering

Programming & software engineering fundamentals

  • Strong Python (the de facto language for AI/ML tooling); solid software engineering practices (testing, version control, code review) since AI engineers ship production systems, not just notebooks
  • API design and integration — most AI engineering work today is building systems around models (orchestration, tool-calling, retrieval), not training them from scratch

LLM & foundation model fluency

  • Practical experience with LLM APIs (ie. OpenAI) and open-weight models
  • Prompt engineering and prompt evaluation as a discipline, not just trial-and-error
  • Understanding of context windows, tokenization, embeddings, and model limitations (hallucination, latency, cost tradeoffs)

RAG (Retrieval-Augmented Generation) & data retrieval

  • Vector databases (Pinecone, Weaviate, pgvector, etc.) and embedding models
  • Chunking strategies, hybrid search, reranking

Agentic systems & orchestration

  • Frameworks like LangChain, LangGraph, LlamaIndex, or custom orchestration
  • Tool-use / function-calling design, multi-step reasoning chains, agent memory and state management

Fine-tuning & model adaptation

  • When to fine-tune vs. prompt vs. RAG
  • Familiarity with parameter-efficient methods (LoRA, etc.) MLOps / LLMOps
  • Model evaluation frameworks, A/B testing for model outputs, observability (tracing, logging model calls)
  • Deployment patterns: latency/cost optimization, caching, streaming responses, fallback handling
  • Versioning prompts and models, not just code
  • Safety, evaluation & governance awareness
  • Bias/safety evaluation, guardrails, handling PII appropriately

Experience:

  • Minimum 7+years of experience in data engineering, with experience working on large-scale, mature data platforms.
  • 3+ years of experience developing ML or AI deliverables – includes deployment to production
  • Bachelor's degree in related field or demonstrated equivalent experience in a related field required.
  • Working knowledge of Agentic Workflows for engineering and architecture
  • Demonstrated experience taking autonomous technical ownership of complex projects from design through delivery, with minimal oversight.
  • Experience contributing to or shaping AI/ML enablement efforts, such as defining frameworks, evaluating MLOps tooling, or building infrastructure that supports model training and deployment.
  • Experience partnering with Data Governance, Data Science, or Compliance teams to align technical practices with governance and regulatory requirements.
  • A track record of proposing and driving innovative technical solutions rather than simply executing predefined plans.
  • Experience designing or implementing Agentic workflows for data engineering preferred.
  • Experience working with Property & Casualty insurance carriers preferred.
  • Experience with Data Vault 2.0 or Ensemble data modeling techniques preferred.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over work authorization sponsorship now or in the future for this position.

#LI-Hybrid

*

At Core Specialty, you will receive a competitive salary and opportunities for professional development and advancement. We offer medical, dental, vision, and life insurances; short and long-term disability; a Company-match of 100% of a 6% contribution 401(k) plan; an Employee Assistance Plan; Health Savings Account, Flexible Spending Account, Health Reimbursement Account, and a wellness program

Role Details

Company Core specialty
Title Lead Data Engineer – AI/Machine Learning
Location Cincinnati, OH, US
Category Data Engineer
Experience Senior
Salary Not disclosed
Remote No

About This Role

Data Engineers build the pipelines that feed AI models. They design ETL workflows, manage data lakes, and ensure training and inference data is clean, timely, and accessible. Without good data engineering, AI projects fail. It's that simple.

The AI era has expanded the data engineer's scope far beyond batch ETL jobs. You're building real-time embedding pipelines for RAG systems, managing vector databases, ensuring training data quality at scale, and building the infrastructure that lets ML teams iterate on data as fast as they iterate on models. Data quality is the biggest predictor of model quality, and you're the person responsible for it.

Across the 9,653 AI roles we're tracking, Data Engineer positions make up 1% of the market. At Core specialty, this role fits into their broader AI and engineering organization.

Data Engineer demand in AI contexts is strong and growing. Every company building AI needs clean, reliable data pipelines. The shift toward real-time AI applications (chatbots, recommendation engines, agent systems) means data engineering is more critical than ever. Companies are willing to pay premium salaries for data engineers with AI/ML pipeline experience.

What the Work Looks Like

A typical week includes: debugging a data pipeline that's producing stale embeddings for the RAG system, optimizing a Spark job that processes training data, building a data quality monitoring dashboard, meeting with the ML team to understand their next data requirements, and writing dbt models that transform raw event data into ML-ready features. The work is deeply technical and high-impact.

Data Engineer demand in AI contexts is strong and growing. Every company building AI needs clean, reliable data pipelines. The shift toward real-time AI applications (chatbots, recommendation engines, agent systems) means data engineering is more critical than ever. Companies are willing to pay premium salaries for data engineers with AI/ML pipeline experience.

Skills Required

Aws (9% of roles) Azure (8% of roles) Embeddings (2% of roles) Gcp (5% of roles) Langchain (3% of roles) Llamaindex (1% of roles) Openai (3% of roles) Pgvector Pinecone (1% of roles) Prompt Engineering (4% of roles)

SQL, Python, and distributed systems (Spark, Airflow, dbt) are core. Cloud data platforms (Snowflake, BigQuery, Redshift) are increasingly standard. Many AI-focused roles also want familiarity with vector databases and embedding pipelines. Understanding data modeling, pipeline orchestration, and data quality frameworks covers the essentials.

AI-specific data engineering skills include: building feature stores, managing training data versioning, implementing data lineage tracking, and building real-time embedding pipelines. Experience with streaming systems (Kafka, Flink) is valuable for real-time AI applications. Understanding ML data requirements (balanced datasets, data augmentation, evaluation set construction) makes you much more effective working with ML teams.

Strong postings specify the data stack, mention ML pipeline work, and describe the scale of data you'll be working with. Look for companies that understand the connection between data quality and model quality. Avoid roles that conflate data engineering with data analysis.

Compensation Benchmarks

Data Engineer roles pay a median of $177,825 based on 160 positions with disclosed compensation. Senior-level AI roles across all categories have a median of $228,700.

Across all AI roles, the market median is $213,400. Top-quartile compensation starts at $264,230. The 90th percentile reaches $319,400. For comparison, the highest-paying categories include AI Safety ($253,100) and Research Engineer ($252,000). By seniority level: Entry: $110,408; Mid: $193,200; Senior: $228,700; Director: $272,275; VP: $235,000.

Core specialty AI Hiring

Core specialty has 1 open AI role right now. They're hiring across Data Engineer. Based in Cincinnati, OH, US.

Location Context

Across all AI roles, 6% (568 positions) offer remote work, while 9,010 require on-site attendance. Top AI hiring metros: New York (2,878 roles, $221,000 median); San Francisco (2,413 roles, $264,500 median); Los Angeles (1,340 roles, $210,000 median).

Career Path

Common paths into Data Engineer roles include Backend Engineer, Database Administrator, Analytics Engineer.

From here, career progression typically leads toward Senior Data Engineer, ML Engineer, Data Platform Lead.

Master SQL and Python first. Then learn a distributed processing framework (Spark or its modern alternatives) and a pipeline orchestrator (Airflow, Dagster, Prefect). Build a portfolio project that demonstrates end-to-end pipeline construction: ingest, transform, validate, serve. If you want to specialize in AI data engineering, add vector databases and embedding pipelines to your skill set.

What to Expect in Interviews

Expect SQL deep-dives (query optimization, partitioning strategies, data modeling), Python coding focused on data pipeline patterns, and system design questions about building scalable ETL workflows. Companies with ML teams will ask about feature stores, embedding pipelines, and training data management. Be ready to discuss data quality monitoring, pipeline orchestration, and how you'd handle schema evolution in a production data lake.

When evaluating opportunities: Strong postings specify the data stack, mention ML pipeline work, and describe the scale of data you'll be working with. Look for companies that understand the connection between data quality and model quality. Avoid roles that conflate data engineering with data analysis.

AI Hiring Overview

The AI job market has 9,653 open positions tracked in our dataset. By seniority: 193 entry-level, 4,500 mid-level, 3,455 senior, and 1,505 leadership roles (Director, VP, C-Level). Remote roles make up 6% of the market (568 positions). The remaining 9,010 roles require on-site or hybrid attendance.

The market median for AI roles is $213,400. Top-quartile compensation starts at $264,230. The 90th percentile reaches $319,400. Highest-paying categories: AI Safety ($253,100 median, 57 roles); Research Engineer ($252,000 median, 419 roles); AI Engineering Manager ($251,622 median, 51 roles).

Data Engineer demand in AI contexts is strong and growing. Every company building AI needs clean, reliable data pipelines. The shift toward real-time AI applications (chatbots, recommendation engines, agent systems) means data engineering is more critical than ever. Companies are willing to pay premium salaries for data engineers with AI/ML pipeline experience.

The AI Job Market Today

The AI job market spans 9,653 open positions across 16 role categories. The largest categories by volume: AI/ML Engineer (7,301), Data Scientist (441), AI Software Engineer (438). These three account for the majority of open positions, though smaller categories often have higher per-role compensation because of specialized skill requirements.

The seniority mix tells a story about where AI teams are in their maturity. Entry-level roles (193) are outnumbered by mid-level (4,500) and senior (3,455) positions, reflecting that most companies are past the 'build a team from scratch' phase and need experienced engineers who can ship production systems. Leadership roles (Director, VP, C-Level) total 1,505 positions, representing the bottleneck between technical execution and organizational strategy.

Remote work availability sits at 6% of all AI roles (568 positions), with 9,010 requiring on-site or hybrid attendance. The remote share has stabilized after the post-pandemic correction. Senior and specialized roles (Research Scientist, ML Architect) are more likely to be remote-eligible than entry-level positions, partly because experienced hires have more negotiating power and partly because these roles require less hands-on mentorship.

AI compensation is structured in clear tiers. The market median sits at $213,400. Top-quartile roles start at $264,230, and the 90th percentile reaches $319,400. These figures include base salary with disclosed compensation. Total compensation (including equity, bonuses, and sign-on) runs 20-40% higher at companies that offer those components.

Category matters for compensation. AI Safety roles lead at $253,100 median, while Prompt Engineer roles sit at $141,440. The spread between highest and lowest-paying categories reflects the premium on specialized technical skills versus broader analytical roles.

The most in-demand skills across all AI postings: Python (1,605 postings), Aws (916 postings), Azure (724 postings), Rag (634 postings), Gcp (522 postings), Pytorch (495 postings), Kubernetes (384 postings), Claude (383 postings). Python dominates, appearing in the vast majority of role descriptions regardless of category. Cloud platform experience (AWS, GCP, Azure) is the second most common requirement. The newer entrants to the top skills list (RAG, vector databases, LLM APIs) reflect the shift from traditional ML toward generative AI applications.

Frequently Asked Questions

Based on 160 roles with disclosed compensation, the median salary for Data Engineer positions is $177,825. Actual compensation varies by seniority, location, and company stage.
SQL, Python, and distributed systems (Spark, Airflow, dbt) are core. Cloud data platforms (Snowflake, BigQuery, Redshift) are increasingly standard. Many AI-focused roles also want familiarity with vector databases and embedding pipelines. Understanding data modeling, pipeline orchestration, and data quality frameworks covers the essentials.
About 6% of the 9,653 AI roles we track offer remote work. Remote availability varies by company and seniority level, with senior and leadership roles more likely to offer location flexibility.
Core specialty is among the companies actively hiring for AI and ML talent. Check our company profiles for detailed breakdowns of open roles, salary ranges, and hiring trends.
Common next steps from Data Engineer positions include Senior Data Engineer, ML Engineer, Data Platform Lead. Progression depends on whether you lean toward technical depth, people management, or product strategy.

Get Weekly AI Career Intelligence

Salary data, skills demand, and market signals from 16,000+ AI job postings. Every Monday.