Senior Java Data Ingestion & API Engineer

Guidehouse; McLean (VA); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Medical insurance

401(k) plan

Paid holidays

Tuition reimbursement

Life insurance

Job summary

Guidehouse is seeking a senior Data/Systems Engineer to design, develop, and maintain enterprise data ingestion pipelines and onboarding workflows using Java and Informatica. You will modernize legacy pipelines within a Databricks lakehouse on AWS, and build API-driven data services for secure cross-system data exchange.

You will collaborate with cloud engineering and platform operations to ensure scalable, secure ingestion, with robust logging and governance to meet regulatory requirements.

Qualifications

• Seven+ years of experience in application and data engineering.
• Five+ years of experience with ETL tools (e.g., Informatica) developing large-scale data ingestion pipelines.
• Experience designing and implementing data ingestion pipelines and onboarding workflows for structured and semi-structured data sources.
• Experience integrating legacy data systems with cloud-based platforms, including AWS services and modern lakehouse architectures.
• Experience building and maintaining API-based data services for enterprise data exchange and system interoperability.

Responsibilities

• Design, develop, and maintain enterprise data ingestion pipelines, onboarding workflows, and API-based data services using Java and ETL platforms.
• Implement intake and onboarding solutions that support end-to-end lifecycle activities with governance requirements.
• Modernize legacy ingestion pipelines with AWS and Databricks lakehouse architecture.
• Develop API-driven data services for secure data exchange across enterprise systems and analytics platforms.
• Implement logging, auditing, and monitoring across ingestion workflows for traceability and reliability.

Skills

Java

ETL frameworks

Informatica

API development

AWS

Databricks

Logging & monitoring

Security & compliance

Education

Bachelor’s degree

Tools

Delta Lake

Kafka/Kinesis

EventBridge

CI/CD

Job description

Guidehouse is seeking a senior Data/Systems Engineer to design, develop, and maintain enterprise data ingestion pipelines and onboarding workflows using Java and Informatica. You will modernize legacy pipelines within a Databricks lakehouse on AWS, and build API-driven data services for secure cross-system data exchange.

You will collaborate with cloud engineering and platform operations to ensure scalable, secure ingestion, with robust logging and governance to meet regulatory requirements.