Guidehouse

Data Engineer

Guidehouse$89K — $148K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • U.S. Citizenship or Green Card required; must obtain Public Trust clearance.
  • Bachelor's degree is mandatory.
  • 5+ years in data engineering or software development.
  • Proficient in Java, Python, SQL, and PySpark, with RESTful and SOAP API development.
  • Familiar with AI tools like Co-Pilot and CodeX.
  • Experience with data pipeline design and ETL processes.
  • Extensive knowledge of relational and NoSQL databases.

Responsibilities

  • Design and maintain data pipelines and ETL processes from diverse data sources.
  • Apply AI techniques, including prompt engineering and machine learning.
  • Optimize data architectures and models for analytics and reporting.
  • Implement CI/CD pipelines using version control tools like Git.
  • Develop cloud-based solutions using Azure Functions and containerization.
  • Collaborate on data models and APIs with DBAs and application developers.
  • Ensure data quality through monitoring and validation.

Benefits

  • Comprehensive medical, dental, and vision insurance.
  • Paid personal and family sick time, along with company holidays.
  • Parental leave offered for new parents.
  • 401(k) retirement plan with employer contributions.
  • Tuition reimbursement for education and certifications.
  • Community outreach and corporate-sponsored events participation.
  • Employee assistance program and Care.com membership.
Full Job Description

Job Family:

Data Science & Analysis


Travel Required:

Up to 10%


Clearance Required:

Ability to Obtain Public Trust

What You Will Do:
Guidehouse seeks a Data Engineer with some AI experience to support in building, optimizing, and maintaining data pipelines, AI solutions, and analytics platforms. The ideal candidate will have hands-on experience with modern data engineering tools, AI solutions, CI/CD, and version control, and will collaborate with cross-functional teams to deliver high-quality, scalable data solutions.

  • Design, develop, test and maintain data pipelines and ETL processes for ingesting, transforming, and loading data from diverse sources (SQL, R, Python).

  • AI experience with prompt engineering, machine learning, agentic AI and RAG concepts

  • Build and optimize data architectures and models to support analytics, reporting, and operational needs.

  • Implement and manage CI/CD pipelines for data engineering workflows using tools such Git.

  • Develop and deploy cloud-based solutions leveraging Azure Functions, and containerization (Docker, Kubernetes).

  • Collaborate with DBAs and application developers to design and integrate data models, stored procedures, and APIs.

  • Ensure data quality and integrity through validation, monitoring, and logging.

  • Successfully juggle multiple tasks across different priorities.

  • Troubleshoot and resolve issues in production environments, ensuring high availability and reliability.

  • Document data flows, processes, and technical solutions for knowledge sharing and compliance.

  • Stay current with emerging technologies and best practices in data engineering, cloud, and DevOps.


What You Will Need:

  • U.S. Citizenship/ Green Card is required and Must be able to OBTAIN and MAINTAIN a Federal or DHS "PUBLIC TRUST".

  • A bachelor’s degree is required.

  • FIVE (5) years of experience in data engineering, software development, or related roles.

  • Experience in programming languages and technologies, including Java, Python, SQL, and PySpark, as well as API development (RESTful and SOAP).

  • Experience with Co-Pilot and CodeX.

  • Experience designing and developing data pipelines and ETL processes.

  • Extensive experience with relational and NoSQL databases, such as MySQL, PostgreSQL, SQL Server, and MongoDB, including stored procedure development.

  • Experience working with Databricks.

  • Experience with CI/CD tools and pipelines, such as Gi and, GitHub.

  • Experience operating in Agile development environments.


What Would Be Nice To Have:

  • Experience supporting federal programs and/or large-scale data modernization projects.

  • Familiarity with version control and collaboration tools, including Git, Jira, and Confluence.

  • Ability to work independently in a fast-paced environment.

  • Strong analytical and troubleshooting skills.

  • Excellent verbal and written communication skills, with the ability to clearly communicate complex technical concepts to diverse audiences.

  • Familiarity with containerization and orchestration technologies

  • Experience with data visualization tools (e.g., Kibana, Tableau).

  • Familiarity with security best practices and compliance in federal environments.

  • Experience with microservices, Spring Boot, and integration of AI/ML components.

  • Previous consulting experience

The annual salary range for this position is $89,000.00-$148,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.


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
Founded
2018

Similar Jobs

  • Data Engineer
    $95K — $115K *
    American Financial Group, Inc.
    Cincinnati, OH 45238 (Hamilton County)
  • EATON
    Data Engineer
    $71K — $105K *
    EATON
    Carol Stream, IL 60188 (Dupage County)
  • OneOncology
    Data Engineer
    $110K — $130K *
    OneOncology
    Nashville, TN 37211 (Davidson County)
  • Guidehouse
    Data Infrastructure Engineer
    $113K — $188K *
    Guidehouse
    Remote
  • Data Engineer
    $95K — $115K *
    TrueScripts
    Washington, IN 47501 (Daviess County)
  • Data Engineer
    $110K — $130K *
    TrueScripts
    Remote

More Jobs at Guidehouse

More Information Technology Jobs

Find similar Data Engineer jobs: