Guidehouse Inc.

Guidehouse Inc.

AWS Lakehouse Data Engineer

US - Remote (Any location)

No sponsorship$113k-$188kDetected 5 days ago
PythonGitSQLRedshiftDatabricksAWSCloud PlatformsTerraformCI/CDGitHub ActionsJenkinsDevOpsMachine LearningAirflowData EngineeringData VisualizationRAGStatisticsCybersecurityNetwork SecurityTest AutomationEHR/EMRCommunicationCollaboration

Stay score

odds of building a lasting career here

57Sponsors, lottery-bound
Cap-exempt (no lottery)0
Sponsors this role90
Entry-level history0
PERM / green-card track0
Lottery odds (Level III)83
Fits your clock70

Sponsors, but it's cap-subject — you still face the weighted lottery (~45% per draw at Level III). Good if you win; have a cap-exempt backup on your list.

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 9 green-card filings in this occupation, 100% were for a worker who already held the job.

Green-card follow-through: 29%

Of 7 labor certifications old enough to have been used, 5 expired without the employer filing the next step. Median time from filing to decision: 493 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

6 transfer filings in the last year, covering 6 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

  • The annual salary range for this position is $113,000.00-$188,000.00.
  • All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @guidehouse.com or guidehouse@myworkday.com.
  • Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse.

Responsibilities

  • Build and Operate Data Pipelines (Batch and Streaming)
  • Design and implement batch and streaming ingestion from APIs, relational databases, file drops, event streams, and external partners.
  • Implement incremental processing, change data capture (CDC), data contracts, schema validation, and reusable transformation frameworks.
  • Deliver an AWS-Native Lakehouse Data Platform
  • Design and implement a Delta Lakehouse-style data platform using AWS-native services to provide Databricks-like capabilities for data engineering, analysis, and data visualization.
  • Build and manage a scalable lakehouse on Amazon S3 using Apache Iceberg and open columnar formats such as Apache Parquet.
  • Implement SQL-like table reliability for data stored in Amazon S3, including ACID transactions, schema evolution, partition evolution, snapshot isolation, time travel, and rollback capabilities using Apache Iceberg.
  • Optimize performance and cost through partitioning, compaction, file sizing, statistics, caching, lifecycle policies, and efficient separation of compute and storage.
  • Implement data governance and fine-grained access control using AWS-native services, including AWS Lake Formation, AWS Glue Data Catalog, AWS Identity and Access Management (IAM), AWS Key Management Service (KMS), and related security services.
  • Implement a managed metadata repository for dataset cataloging, ownership, business definitions, tagging, classification, and discoverability.

Requirements

  • Travel Required:
  • Clearance Required:
  • Ability to Obtain Public Trust
  • Apply policy-based access, least-privilege permissions, row-, column-, and cell-level controls where required, data classification, retention, encryption, and secure data handling.
  • Bachelor's degree in Engineering, Information Technology, Computer Science, Data Engineering, or a related field, or FOUR (4) years equivalent practical experience in leu of degree.

Compensation

  • Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.
  • Care.com annual membership

Benefits

  • Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.
  • Benefits include:
  • Medical, Rx, Dental & Vision Insurance
  • Parental Leave
  • 401(k) Retirement Plan
  • Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts
  • Transit and Parking Commuter Benefits
  • Short-Term & Long-Term Disability
  • Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
  • Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
  • Position may be eligible for a discretionary variable incentive bonus

Equal opportunity

  • Equal Opportunity Employer-Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation.

This listing is sourced directly from Guidehouse Inc.'s careers page and normalized into a canonical job model.