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.
Apply directly at Guidehouse →Create a free account for alerts like thisView Guidehouse immigration profile
This listing is sourced directly from Guidehouse's careers page and normalized into a canonical job model.