Pyramid Consulting Inc.
Data Engineer (AI & LLM Expertise)
Plano, Texas
Sponsorship not specified$0k-$0kDetected 26 days ago
PythonGitSQLSnowflakeVector DatabasesAWSGCPAzureCloud PlatformsTerraformCI/CDMachine LearningdbtData EngineeringLLMsMLOpspytestProblem Solving
About the role
- Immediate need for a talented Data Engineer (AI & LLM Expertise).
- This is a 06-12+months contract opportunity with long-term potential and is located in Plano, TX / San Antonio, TX(Onsite).
- Please review the job description below and contact me ASAP if you are interested.
Responsibilities
- Maintain and enhance dbt models across staging (DL2) and mart (DL3) layers.
- Support Control-M scheduling changes and DBT deployments.
- Write and maintain SQL models following SQLFluff lint standards (ruff, mypy for Python).
- Manage source freshness and data quality test failures.
- Develop and maintain robust Python code for ETL processes, with an understanding of how data is processed by LLMs.
- Document AI/ML data pipelines, including explanations of tokenization strategies and data transformations relevant to LLM processing.
Requirements
- Familiarity with prompt engineering principles for interacting with LLMs.
- US military Background is required.
- Experience with vector databases and embedding pipelines.
- Familiarity with MLOps principles and tools.
Skills
- SQL (Client dialect), dbt Core/Cloud basics.
- Basic Python (scripting, pytest), with a strong understanding of its application in data pipelines and AI/ML.
- Git / GitLab branching and MR workflows.
- Familiarity with Terraform (reading/editing.tfvars).
- Understanding of incremental models, source freshness, and dbt state: selectors.
- Control-M scheduling concepts.
- Client warehousing (sizing, multi-clustering).
- dbt Cloud CLI, Poetry.
- Github Copilot, Claude Code
- Foundational understanding of how LLMs work, including concepts like tokenization, embeddings, and context windows.
- Practical experience or strong theoretical knowledge of applying AI/LLMs to data processing tasks.
- Ability to understand and work with unstructured and semi-structured data for AI applications.
Compensation
- $55 - $60/hour.
Benefits
- Strong analytical and problem-solving skills, with a proactive approach to learning new AI technologies.
- Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
Apply directly at Pyramid Consulting Inc. →Create a free account for alerts like thisView Pyramid Consulting Inc. immigration profile
This listing is sourced directly from Pyramid Consulting Inc.'s careers page and normalized into a canonical job model.