Data Engineer

Travel Required: Up to 10%. Must be able to obtain and maintain a federal or DHS "Public Trust" clearance.

About the Role

Guidehouse seeks a Data Engineer with some AI experience to support building, optimizing, and maintaining data pipelines, AI solutions, and analytics platforms. The ideal candidate will collaborate with cross-functional teams to deliver high-quality, scalable data solutions.

Responsibilities

• 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 as 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.

Requirements

• U.S. Citizenship or Green Card is required.
• 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 Git and GitHub.
• Experience operating in Agile development environments.

Preferred Qualifications

• 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.

Pay

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.

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, 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.