Software Developer - Managing Consultant

Job Family : Data Engineering & Architecture Consulting

Travel Required : Up to 10%

Clearance Required : Ability to Obtain Public Trust

• Design, develop, and maintain enterprise data ingestion pipelines, onboarding workflows, and API-based data services using Java and ETL platforms (e.g., Informatica), enabling standardized and repeatable data intake into the Data Platform.
• Implement intake and onboarding solutions that support end-to-end lifecycle activities, including discovery, requirements analysis, source system profiling, and technical design, aligned to defined intake processes, SLAs, and governance requirements.
• Modernize and integrate legacy data ingestion pipelines with AWS and Databricks lakehouse architecture, supporting batch and near real-time ingestion patterns and enabling consistent data flow into enterprise data services.
• Develop and expose API-driven data services and integration patterns to facilitate secure data exchange across enterprise systems, analytics platforms, and downstream consumers.
• Build and maintain production-ready ingestion pipelines and onboarding frameworks that meet technical, security, and documentation requirements for controlled promotion into production environments.
• Implement robust logging, auditability, and monitoring capabilities across ingestion and integration workflows to support traceability, incident response, and operational reliability.
• Collaborate with cloud engineering and platform operations teams to integrate ingestion pipelines with AWS services (e.g., S3, messaging/streaming services) and ensure secure, scalable connectivity across systems.
• Contribute to governance and compliance practices by incorporating data classification, access control patterns, and lineage updates as part of onboarding and ingestion processes.

• Bachelor’s degree is required
• Minimum SEVEN (7) years of experience in application and data engineering, including strong hands‑on development in Java and enterprise integration frameworks.
• Minimum FIVE (5) years of experience with ETL tools (e.g., Informatica) developing and maintaining large-scale data ingestion pipelines.
• Experience designing and implementing data ingestion pipelines and onboarding workflows for structured and semi‑structured data sources.
• Strong experience integrating legacy data systems with cloud‑based platforms, including AWS services (e.g., S3, IAM, networking) and modern lakehouse architectures.
• Experience building and maintaining API‑based integration services for enterprise data exchange and system interoperability.
• Experience implementing production‑grade solutions with logging, auditing, error handling, and reliability patterns aligned to enterprise operations requirements.
• Familiarity with secure development practices, including access controls, encryption, and compliance requirements in regulated environments (e.g., FISMA, FedRAMP High).

• Experience supporting enterprise data intake and onboarding services within a governed data platform or similar large‑scale data modernization effort.
• Experience integrating with Databricks lakehouse architecture, including ingestion into Delta Lake and downstream analytics enablement.
• Familiarity with streaming and event‑driven architectures (e.g., Kafka, Kinesis, Event Bridge) for near real‑time data ingestion.
• Experience with Dev Sec Ops  practices, including CI/CD pipelines, automated testing, and controlled deployments across environments.
• Exposure to enterprise metadata, lineage, and catalog tooling supporting governed data platforms.
• Experience supporting federal clients or working in highly regulated environments with strict data protection and audit requirements

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
• Position may be eligible for a discretionary variable incentive bonus
• Parental Leave and Adoption Assistance
• 401(k) Retirement…