Applied Machine Learning & Data Engineering Senior Consultant II

Allstate Allstate · Insurance · United States · Remote

This role focuses on building and optimizing AI-powered data pipelines and intelligent import tools to automate data ingestion, transformation, and mapping processes, leveraging LLMs and prompt engineering to reduce manual effort and improve data accuracy within an enterprise setting.

What you'd actually do

  1. Design and build AI-powered data pipelines to process and transform structured and unstructured data (PDF, Excel, CSV, etc.)
  2. Develop and optimize LLM-based solutions (prompt engineering, mapping, extraction, and transformation)
  3. Translate complex data and technical outputs into actionable insights for business stakeholders
  4. Partner with cross-functional teams (product, engineering, business SMEs) to define and deliver solutions
  5. Validate and improve solution accuracy through testing, iteration, and stakeholder feedback

Skills

Required

  • Python
  • SQL
  • Generative AI / LLMs (prompt engineering, APIs, or similar)
  • data transformation
  • file parsing
  • pipeline development
  • DevOps practices (CI/CD pipelines, version control, cloud deployment)
  • cloud platforms (preferably Azure)
  • communicate effectively with both technical and non-technical stakeholders
  • work in ambiguous, fast-evolving environments

Nice to have

  • C# / .NET integration or enterprise application development
  • LLM frameworks (LangChain, etc.)
  • document processing tools
  • API design
  • JSON processing
  • system integration patterns
  • insurance, healthcare, or other regulated industries

What the JD emphasized

  • high-impact AI and data automation initiatives
  • AI-assisted data mapping capabilities
  • AI/ML techniques
  • AI-driven pipelines
  • AI-powered data pipelines
  • LLM-based solutions
  • Generative AI / LLMs

Other signals

  • AI-assisted data mapping
  • AI/ML techniques to parse, normalize, and validate structured and unstructured data
  • LLM-based solutions (prompt engineering, mapping, extraction, and transformation)
  • AI-driven pipelines