Senior Data Engineer

JobCubby; McLean, Northern (VA, KY); Hybrid; USD 120,000 - 190,000; Full time

Benefits offered by this job

Medical insurance

401(k) plan

Paid holidays

Job summary

Guidehouse is hiring a Senior Data Engineer to design, build, and operate Azure Lakehouse architectures using Azure Databricks, ADLS Gen2, Synapse, and Data Factory for analytical and operational workloads in a federal context.

You will develop scalable ETL/ELT pipelines with Spark, Delta Lake, Python, SQL, and Scala; collaborate across teams; and implement data quality, performance, and cost optimization.

Qualifications

• Must be able to obtain and maintain a Federal or DoD Public Trust security clearance.
• Bachelor’s or Master’s degree in CS/Engineering/Data Science or equivalent.
• 5+ years of experience as a Data Engineer, including 3+ years on Azure with Databricks and native Azure data services.
• Hands-on experience designing, building, and operating Azure Lakehouse architectures.
• Experience with Spark, Delta Lake, Python, SQL, and Scala for large-scale data processing.
• Experience building scalable ETL/ELT pipelines with Databricks, Spark, and Delta Lake.

Responsibilities

• Design, build, and operate Azure Lakehouse architectures using Azure Databricks, ADLS Gen2, Synapse, and Data Factory.
• Develop, maintain, and optimize scalable ETL/ELT pipelines ensuring reliability and data quality.
• Process large-scale structured and unstructured data with batch and streaming pipelines using Spark and Delta Lake.
• Collaborate with cross-functional teams to deliver enterprise Azure solutions and support deployments.
• Implement data quality, performance tuning, and cost-optimization practices.

Education

Bachelor’s or Master’s degree in Computer Science, Engineering, Data Science

Tools

Azure Databricks

Azure Synapse Analytics

Azure Data Factory

ADLS Gen2

Delta Lake

Apache Spark

Python

SQL

Scala

Job description

Job Family

Data Science & Analysis

Travel Required

Up to 10%

Clearance Required

Ability to Obtain Public Trust

What You Will Do

• Design, build, and operate Azure Lakehouse architectures using Azure Databricks, Azure Data Lake Storage (ADLS Gen2), Azure Synapse Analytics, and Azure Data Factory to support analytical and operational workloads.
• Develop, maintain, and optimize scalable ETL/ELT pipelines using Databricks Workflows, Spark jobs, and Delta Lake to ensure reliability, performance, and enterprise-grade data quality.
• Process large-scale structured and unstructured datasets using optimized batch and streaming pipelines leveraging Apache Spark, Delta Lake, Python, SQL, and Scala.
• Collaborate with cross-functional teams to deliver enterprise solutions on Azure and support production deployments, monitoring, and operational excellence.
• Implement data quality, performance tuning, and cost-optimization practices for data platforms and pipelines.

What You Will Need

• Must be able to OBTAIN and MAINTAIN a Federal or DoD "Public Trust" security clearance; candidates must obtain approved adjudication of clearance prior to onboarding with Guidehouse. Candidates with an ACTIVE "Public Trust" or higher-level clearance are preferred.
• Bachelor’s or Master’s degree in Computer Science, Engineering, Data Science, or equivalent experience.
• FIVE (5) or more years of experience as a Data Engineer, including THREE (3) years delivering enterprise solutions on Azure, specifically using Azure Databricks and Azure-native data services.
• Hands-on experience designing, building, and operating Azure Lakehouse architectures using Azure Databricks, ADLS Gen2, Azure Synapse Analytics, and Azure Data Factory.
• Experience in Apache Spark, Delta Lake, Python, SQL, and Scala, with demonstrated ability to process large-scale structured and unstructured datasets using optimized batch and streaming pipelines.
• Experience designing, developing, and maintaining scalable ETL/ELT pipelines using Databricks Workflows, Spark jobs, and Delta Lake, ensuring reliability, performance, and data quality at enterprise scale.
• Experience with real-time and batch data processing.

What Would Be Nice To Have

• Azure certifications (for example, Azure Data Engineer) or equivalent cloud/data platform certifications.
• Experience implementing CI/CD for data engineering, MLOps pipelines, or data platform automation.
• Familiarity with data governance, observability, and cost-optimization practices at scale.

What We Offer

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
• Personal and Family Sick Time & Company Paid Holidays
• Parental Leave
• 401(k) Retirement Plan
• Group Term Life and Travel Assistance
• Voluntary Life and AD&D Insurance
• 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
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Care.com annual membership
• Employee Assistance Program
• 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

About Guidehouse

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

Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.