Pyramid Consulting Inc.

Pyramid Consulting Inc.

Data Engineer (AI & LLM Expertise)

Plano, Texas, USA · Contract

Sponsorship not specifiedDetected 112 days ago
PythonGitSQLSnowflakeVector DatabasesAWSGCPAzureCloud PlatformsTerraformCI/CDMachine LearningdbtData EngineeringLLMsMLOpspytestProblem Solving

Stay score

odds of building a lasting career here

42Risky
Cap-exempt (no lottery)0
Sponsors this role100
Entry-level history0
PERM / green-card track0
Lottery odds40
Fits your clock70

Thin sponsorship signal and lottery-bound. A low-probability bet with your clock running. Prioritize cap-exempt roles and proven entry-level sponsors first.

Lottery odds assume a STEM candidate.

Personalize to your clock →

Employer immigration record

from this employer's Department of Labor filings

Green-card filing pattern in this occupation

Context, not a finding about this posting: of this employer's 12 green-card filings in this occupation, 100% were for a worker who already held the job.

Third-party placement is common here

59% of this employer's visa filings place the worker at a client company rather than at the employer itself, across 33 clients. Your visa, salary band and layoff exposure would follow the employer of record, not the client.Most common: BANK OF AMERICA · Fidelity Investment · Fidelity Investments

Green-card follow-through: 86%

Of 7 labor certifications old enough to have been used, 1 expired without the employer filing the next step. Median time from filing to decision: 417 days.100% of their filings were for a worker who already held the job.Only certifications past the 180-day window are counted — recent ones cannot have expired yet.

Files H-1B transfers

81 transfer filings in the last year, covering 81 workers. Median labor-condition decision: 7 days. An employer that already files transfers is one that can take over an existing H-1B.

Sourced from Department of Labor LCA, PERM and prevailing-wage disclosure data. Employer matching is by name, so figures may be split across an employer's legal entities. Absence of a filing means none appears in our copy of the data, not that none exists.

Community outcomes

No reports yet — be the first to help the next applicant.

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

  • Must have skills: Data Engineer", "Snowflake SQL, "DBT", "Git", "Github Copilot", "AI.
  • 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.
  • 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.
  • Familiarity with prompt engineering principles for interacting with LLMs.
  • Strong analytical and problem-solving skills, with a proactive approach to learning new AI technologies.
  • US military Background is required.

Benefits

  • Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Company info

  • Our client is a leading Banking and Financial Industry, and we are currently interviewing to fill this and other similar contract positions.
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.