Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Aivanta Tech Inc

NewBe an early applicant

Lead Data Engineer / Architect

Posted Updated

Description

Role: Lead Data Engineer / ArchitectLocation: Cary, NC
Work Model: Day 1 onsite; hybrid schedule, Tuesday–Thursday onsite
Experience: 10–15 years

2. Mandatory Skills – Must-Have

  1. Python, PySpark, Scala and SQL – strong production-level data engineering skills.
  2. Azure Databricks – Delta Lake, Spark performance tuning, Jobs/Workflows and Unity Catalog.
  3. Azure data services – ADLS Gen2 and Azure Data Factory (ADF).
  4. Lakehouse / Medallion Architecture – proven experience implementing Bronze, Silver and Gold layers at enterprise scale.
  5. Data Pipeline Engineering – metadata-driven ingestion frameworks, data transformation, data quality and large-scale pipeline optimization.
  6. Production AI/LLM Experience – hands-on experience designing and deploying LLM-based solutions, including RAG, embeddings, retrieval and prompt engineering.
  7. LLM Frameworks – experience with LangChain, LlamaIndex or LangGraph, plus Azure OpenAI, OpenAI or Databricks Model Serving.
  8. Azure DevOps / CI-CD – experience automating data pipeline deployments; Terraform and Databricks Asset Bundles are highly relevant.
  9. Technical Leadership – ability to design solutions, write production code, review code and guide data engineering teams.
  10. Financial services or insurance data, especially financial reconciliation, general ledger or accounting data.
  11. AI-driven data quality, anomaly detection and automated reconciliation.
  12. Knowledge graphs, ontologies, semantic layers or enterprise Text-to-SQL solutions.
  13. Azure security, data governance, PII protection and fine-grained access controls.
  14. MLOps/LLMOps, model evaluation and production AI monitoring.

Important: This is a hands-on Lead Data Engineer position, not a purely managerial or coordination role. Candidates must demonstrate recent production coding experience.

4. Recruiter Screening Checklist

Confirm all of the following before submission:

  • 12–18 years of relevant experience.
  • Visa status and eligibility to meet the applicable compensation terms.
  • H-1B transfer candidate, if applicable, can start upon receipt of the transfer receipt notice.
  • Willing and able to work onsite in Cary, NC, from Day 1, Tuesday–Thursday.
  • Strong hands-on Python, PySpark, Scala and SQL.
  • Strong Azure Databricks, Delta Lake, ADLS Gen2 and ADF experience.
  • Proven enterprise lakehouse / medallion architecture experience.
  • Production experience building and deploying LLM/RAG solutions.
  • Recent production coding and technical leadership experience.
  • Compensation expectations confirmed before submission

Skills

What Lead Data Engineering jobs ask for — and how much of it you have →
Apply

See also

Data Engineering jobs by country — openings, pay and top skills →