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