Hands-On Data Engineer & Systems Architect

Agile Business Concepts, LLC; Washington (District of Columbia); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Agile Business Concepts, LLC is seeking a highly technical Data Engineer / Systems Architect to lead enterprise data solutions for a Federal/DoD environment. The role combines architecture design with hands-on implementation across Army Vantage/Palantir Foundry, Advana, Databricks, SQL, and Microsoft A365 Dataverse.

You will build ETL/ELT pipelines, design data models, ensure data quality and security, and guide integration with downstream applications while collaborating with government

Qualifications

• Bachelor's degree or equivalent professional experience.
• Strong hands-on experience with SQL, Databricks, ETL/ELT, APIs, relational databases and data modeling.
• Experience designing and implementing automated enterprise data pipelines.
• Knowledge of secure data integration including RBAC and PII/PHI protections.

Responsibilities

• Lead enterprise data discovery, architecture, engineering, integration, and data modeling.
• Design, develop, test, and maintain scalable ETL/ELT pipelines and workflows.
• Perform data transformation, cleansing, normalization, mapping, validation, and reconciliation.
• Develop and optimize complex SQL queries and relational data models.
• Integrate data through REST APIs, services and connectors.
• Support data integration across Army Vantage/Palantir Foundry, Advana, Databricks/SQL, and Dataverse.

Skills

SQL

Databricks

ETL/ELT

APIs

Relational databases

Data modeling

Education

Bachelor's degree in Computer Science, Information Systems, Data Engineering, Engineering, or related field

Tools

Army Vantage

Palantir Foundry

Advana

Databricks

SQL

Microsoft Dataverse

Microsoft Azure

Job description

Agile Business Concepts, LLC is seeking a highly technical Data Engineer / Systems Architect to lead enterprise data solutions for a Federal/DoD environment. The role combines architecture design with hands-on implementation across Army Vantage/Palantir Foundry, Advana, Databricks, SQL, and Microsoft A365 Dataverse.

You will build ETL/ELT pipelines, design data models, ensure data quality and security, and guide integration with downstream applications while collaborating with government