Guidehouse

Guidehouse

Data Engineer - Senior Consultant

McLean, Virginia · Senior

No sponsorshipDetected 27 days ago
PythonSQLDatabricksAWSCI/CDKafkaData EngineeringAgileAuditingTest AutomationUnityCommunication

About the role

  • 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.
  • Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event.

Responsibilities

  • Develop and maintain scalable data ingestion, transformation, and curation pipelines using Databricks (Delta Lake, Delta Live Tables, Auto Loader) and AWS services, supporting consistent delivery of analytics-ready datasets across the Data Platform.
  • Implement standardized batch and near real-time data pipelines that integrate legacy systems and cloud-native data sources, contributing to enterprise-wide data access, reuse, and platform consistency.
  • Support full data pipeline lifecycle activities, including intake, requirements analysis, source profiling, and technical implementation, aligning development work with defined intake processes, SLAs, and governance.
  • Build production-ready data pipelines that meet defined technical and documentation standards, including participation in validation, testing, and release processes to enable reliable and compliant production deployments.
  • Apply data quality checks, validation rules, and observability practices to improve pipeline reliability, support monitoring, and contribute to platform stability and operational performance targets.
  • Integrate pipelines with AWS services (e.g., S3, streaming frameworks, APIs) and enterprise data tools to support secure, scalable data movement and interoperability across the ecosystem.
  • Support analytics and reporting use cases by preparing curated datasets and enabling consumption through SQL-based access, dashboards, and enterprise BI tooling.
  • Experience working with Databricks and Delta Lake to support ingestion, transformation, and curated data layer development.

Requirements

  • Clearance Required
  • Ability to Obtain Public Trust
  • Bachelor's degree is required
  • Minimum FOUR (4) years of experience in data engineering, with hands-on development of data pipelines in cloud or distributed data environments.
  • Strong proficiency in Python, PySpark, and SQL for building and maintaining scalable ETL/ELT pipelines.

Nice to have

  • What Would Be Nice To Have

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
  • Position may be eligible for a discretionary variable incentive bonus
  • Parental Leave and Adoption Assistance
  • 401(k) Retirement Plan
  • Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
  • Short-Term & Long-Term Disability
  • Tuition Reimbursement, Personal Development & Learning Opportunities
  • Mobility Stipend

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's careers page and normalized into a canonical job model.