Data Engineer / Systems Architect

Socket.dev; Tacoma (WA); Hybrid; USD 125,000 - 150,000; Full time

Job summary

JLGOV LLC is seeking a backend-focused Data Engineer / Systems Architect to drive enterprise data integration for a high-priority federal program supporting the Washington National Guard.

This role emphasizes backend data modernization, architecture, and pipeline engineering to enable analytics, automated reporting, and decision dashboards. Contingent upon contract award, it offers a strong path into DoD cloud architectures.

Qualifications

• 3+ years of enterprise data engineering, cloud architecture, and/or DoD systems integration experience.
• Strong experience with SQL, ETL/data pipelines, APIs, relational data modeling, and database architecture.
• Experience with Army Vantage/Palantir Foundry, Advana/Databricks, or Dataverse/Army 365.

Responsibilities

• Design, develop, test, and sustain secure ETL/data pipelines and system integrations.
• Integrate and transform Army Vantage and Advana data into Microsoft Dataverse/Army 365.
• Develop relational/star-schema data models, APIs, and automated data connections.
• Perform data cleansing, harmonization, validation, reconciliation, and quality assurance.
• Implement RBAC, row-level security, and IL5 security controls.
• Monitor and troubleshoot data pipelines and integration performance.
• Maintain data dictionaries, ERDs, technical documentation, and performance metrics.
• Coordinate technical activities with Government stakeholders.

Skills

SQL

ETL/Data pipelines

APIs

Relational data modeling

Database architecture

Cloud architecture

DoD systems integration

Tools

Army Vantage / Palantir Foundry

Advana / Databricks

Microsoft Dataverse / Army 365

Job description

We are fast-tracking interviews to identify a lead Systems Architect for an upcoming Washington National Guard mission. Review the full criteria below to submit your qualifications for immediate consideration.

Company: JLGOV LLC
Location: Camp Murray, WA
Employment: Full-Time | FLSA Exempt
Salary: $125,000–$150,000 annually, based on experience and qualifications
Work Arrangement: Hybrid – approximately 75% remote / 25% onsite
Schedule: Monday–Friday, 6:00 AM–2:30 PM Pacific
Citizenship: U.S. Citizenship Required
Security: Favorably adjudicated Tier 1 investigation or higher; must meet CAC and Government system-access requirements
Status: Contingent upon contract award

Position Summary

JLGOV LLC is actively seeking a backend-focused Data Engineer / Systems Architect to drive enterprise data integration for a high-priority federal program supporting the Washington National Guard.

This role focuses entirely on backend data modernization, architecture, and pipeline engineering. In this position, you will build the foundational systems that enable critical downstream data analytics, automated reporting, and tactical decision-making dashboards.

Note: This position is contingent upon imminent contract award, offering an excellent gateway into stable, long-term DoD cloud architecture platforms.

Key Responsibilities

• Design, develop, test, and sustain secure ETL/data pipelines and system integrations.
• Integrate and transform Army Vantage and Advana data into Microsoft Dataverse/A365.
• Develop relational/star-schema data models, APIs, and automated data connections.
• Perform data cleansing, harmonization, validation, reconciliation, and quality assurance.
• Implement RBAC, row-level security, and IL5 security controls.
• Monitor and troubleshoot data pipelines and integration performance.
• Maintain data dictionaries, ERDs, technical documentation, and performance metrics.
• Coordinate technical activities with Government stakeholders.

Required Qualifications

• 3+ years of enterprise data engineering, cloud architecture, and/or DoD systems integration experience.
• Strong experience with SQL, ETL/data pipelines, APIs, relational data modeling, and database architecture.
• Demonstrated experience with one or more of:
  • Army Vantage / Palantir Foundry
  • Advana / Databricks
  • Microsoft Dataverse / Army 365
• Experience supporting secure enterprise/cloud environments; DoD/IL5 experience preferred.
• Strong troubleshooting, data-quality, and system-integration skills.
• U.S. Citizenship required.
• Must possess or satisfy required Tier 1 investigation, CAC, cybersecurity training, and Government system-access requirements.

Work Location

This is not a fully remote position. Approximately 75% of work may be performed remotely and 25% onsite at Camp Murray, Washington. Mission requirements may occasionally require increased onsite support.

Equal Employment Opportunity

JLGOV LLC is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable federal, state, or local law. JLGOV provides reasonable accommodations to qualified individuals with disabilities and for sincerely held religious beliefs, as required by law.