Data Engineer

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Arlington, VA, US

Salary Range: $ To $ Annually

Pioneering Evolution is seeking a Data Engineer to design, develop, integrate, and operate secure enterprise data solutions for the SyncPoint program. The Data Engineer will work closely with software engineers, the Chief Engineer, product teams, analysts, and the AI/ML Engineer to build reliable data pipelines, data models, integrations, and analytical data services. The role ensures that SyncPoint data is accurate, traceable, secure, performant, and readily available to operational applications, reporting capabilities, external integrations, and AI-enabled features.

The ideal candidate brings strong experience with PostgreSQL, Microsoft Azure, data modeling, ETL/ELT, APIs, and event-driven architectures, combined with an interest in operating data solutions within regulated DoD environments. This role is expected to develop deep familiarity with DoD financial data domains including Navy ERP, PIEE, EDW, and the PPBE lifecycle. This position aligns to the Data Engineer (Services Lead) role defined in the SyncPoint staffing plan.

• Design and maintain relational and analytical data models supporting SyncPoint’s complex DoD financial management domains.
• Develop normalized transactional schemas and denormalized models optimized for application, integration, and analytical workloads.
• Define relationships, constraints, indexes, and data-integrity rules; support multi-tenant isolation strategies.
• Develop strategies for historical data, auditing, lineage, provenance, and retention aligned to DoD requirements.
• Participate in architecture reviews; document data flows, ownership, and system-of-record boundaries.

• Design, develop, test, and maintain reliable ETL/ELT pipelines for importing, transforming, validating, and distributing data across SyncPoint.
• Build repeatable processes for migrating legacy financial, planning, project, funding, and operational data from predecessor systems.
• Implement data validation, reconciliation, deduplication, and quality-control processes.
• Support incremental, scheduled, and event-driven data synchronization across services and environments.

• Develop and optimize complex PostgreSQL queries, views, indexes, functions, and stored procedures.
• Analyze query execution plans and resolve database performance issues.
• Design and maintain hierarchical data structures; develop safe schema migration, seed-data, and data‑correction scripts.
• Support database schema evolution across development, test, and production environments.

• Build and maintain integrations between SyncPoint and external government and commercial systems including Navy ERP, PIEE, and EDW.
• Develop transformations between external schemas and SyncPoint’s internal canonical data models.
• Support secure service-to-service REST API integrations with appropriate authentication and authorization patterns.

• Prepare trusted, structured datasets for AI, machine-learning, and analytics capabilities.
• Support development of Retrieval-Augmented Generation (RAG) capabilities and data retrieval services for generative AI workflows.
• Work with the AI/ML Engineer to establish data selection, metadata, provenance, lineage, and access-control requirements.
• Ensure AI systems retrieve only information the requesting user or service is authorized to access.

• Establish automated data-quality checks for completeness, validity, consistency, uniqueness, and referential integrity.
• Maintain data lineage and traceability for critical financial information; document data mappings, transformation rules, and data dictionaries.
• Support data retention, archival, and deletion requirements appropriate to DoD and compliance environments.

• Design data solutions appropriate for DoD Impact Level 4 (IL4) environments.
• Support secure handling and protection…