Guidehouse

Software Developer

Guidehouse • $110K — $130K *
Mclean, VA 22101In-Person
Information Technology
5 - 7 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Bachelor's degree in a relevant field
  • 6+ years of experience in data engineering or ETL development
  • Proficient in building and maintaining data pipelines for structured and semi-structured datasets
  • Experienced in developing Java-based data services and APIs
  • Familiar with AWS data components and lakehouse architecture
  • Skilled in embedded data quality validation and production-ready solutions implementation
  • Experience in Agile and CI/CD methodologies

Responsibilities

  • Design and develop data ingestion and curation pipelines using Informatica and ETL tools
  • Extend legacy ETL pipelines into AWS and Databricks environments
  • Build Java-based data services and APIs for secure data access
  • Support requirements analysis and implement standardized data integration patterns
  • Develop production-ready data services adhering to security and documentation standards
  • Implement data quality validation and performance optimization for pipelines
  • Integrate data services with AWS and Databricks components

Benefits

  • 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 and Flexible Spending Accounts
  • Transits and Parking Commuter Benefits
  • Short-Term & Long-Term Disability
  • Tuition Reimbursement and Learning Opportunities
  • Employee Referral Program
  • Corporate Sponsored Events & Community Outreach
  • Care.com annual membership
  • Employee Assistance Program
Full Job Description
Job Family:
Systems Engineering

Travel Required:
Up to 10%

Clearance Required:
Ability to Obtain Public Trust

What You Will Do:
  • Design, develop, and maintain data ingestion, transformation, and curation pipelines using Informatica and related ETL tools, enabling consistent delivery of high-quality, analytics-ready datasets across the Data Platform.
  • Extend and integrate legacy ETL pipelines into AWS and Databricks lakehouse environments, supporting batch and near real-time ingestion patterns and improving enterprise data availability and reuse.
  • Build and support Java-based data services, APIs, and integration layers that enable secure, governed access to curated data for analytics, reporting, and downstream consumption.
  • Contribute to intake and onboarding activities by supporting requirements analysis, source profiling, and implementation of standardized data integration patterns aligned to defined intake processes and SLAs.
  • Develop production-ready data pipelines and services that meet defined technical, security, and documentation requirements, supporting controlled promotion into production through established SDLC and CI/CD processes.
  • Implement data quality validation, transformation logic, and performance optimization to improve pipeline reliability, scalability, and operational efficiency.
  • Integrate data pipelines and services with AWS components (e.g., S3, messaging/streaming services) and Databricks environments to support secure, scalable data movement and platform interoperability.
  • Support governed data engineering practices by implementing metadata capture, lineage tracking, access control patterns, and audit logging to meet compliance, traceability, and security requirements.

What You Will Need:
  • Bachelor's degree is required
  • SIX (6) or more years of experience in data engineering or ETL development using Informatica or similar enterprise data integration platforms.
  • Experience building and maintaining data pipelines supporting ingestion, transformation, and curation of structured and semi-structured datasets.
  • Experience developing Java-based data services, APIs, or integration layers supporting enterprise data access and interoperability.
  • Working experience with AWS data platform components (e.g., S3, IAM, networking) and familiarity with lakehouse architecture such as Databricks.
  • Experience implementing production-ready solutions with embedded data quality validation, monitoring, logging, and error handling patterns.
  • Experience working within Agile and CI/CD-enabled delivery environments supporting secure and repeatable deployments.


What Would Be Nice To Have:
  • Experience modernizing legacy ETL pipelines into cloud-native or lakehouse-based architectures.
  • Familiarity with data governance concepts, including metadata management, lineage, and access controls within regulated environments.
  • Familiarity with Databricks capabilities (Delta Lake, Unity Catalog) and downstream analytics enablement patterns.
  • Experience with event-driven or streaming integration patterns (e.g., Kafka, Kinesis, EventBridge).
  • Exposure to enterprise metadata/catalog tools (e.g., Informatica EDC, Axon) supporting governed data platforms.
  • Experience supporting federal data platforms or operating in highly regulated environments with strict security and audit requirements.
  • Knowledge of secure data access patterns, including RBAC/ABAC, encryption, and audit reporting aligned to FISMA and FedRAMP requirements.


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 a management consulting firm headquartered in Washington, D.C. The firm provides consulting services to clients in the public and commercial sectors, with a focus on energy, financial services, healthcare, national security, and aerospace and defense. Guidehouse was founded in 2018 as a spin-off from PwC. The firm has over 7,000 employees and operates in more than 50 locations worldwide.
Learn more about Guidehouse
Size
8,000 employees
Industry
Business Services
Founded
2018
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Guidehouse

More Information Technology Jobs

Find similar Software Developer jobs:

NationwideMclean, VA