Database Architect; Remote

Applications for this position will be accepted through November 30, 2026

Koniag Data Solutions, a Koniag Government Services company, is seeking an experienced Data Architect to support the USDA APHIS Plant Protection and Quarantine (PPQ) Commodity Treatment Information System – Modernization (CTIS‑M) program. This fully remote role will support the data architecture design and modernization efforts required to implement the Regulated Garbage (RG) Module, replacing manual, paper‑based workflows with an integrated digital compliance capability inside CTIS‑M.

Benefits include medical, dental, and vision insurance, 401(k) retirement plan, paid time off, paid parental leave, life and disability insurance, flexible spending accounts, commuter benefits and tuition reimbursement.

The Data Architect will work closely with the CTIS‑M DME team, USDA APHIS leadership, and cross‑functional engineering teams to deliver enterprise data modeling, workflow‑aligned data structures, FOIA‑ready audit capabilities, and integration frameworks that comply with USDA, APHIS, FEA, and federal ICT standards. This position also participates directly in Agile sprint execution, documentation, requirements analysis, and Section 508 compliance processes. Must be able to obtain and maintain a Public Trust clearance.

• Guide the design and optimization of the CTIS‑M Azure SQL data architecture supporting all Regulated Garbage (RG) workflows.
• Develop conceptual, logical, and physical data models, ER diagrams, metadata structures, lineage rules, and retention policies.
• Ensure all data structures are compliant with USDA, APHIS, PPQ, FEA, federal regulatory, audit, and reporting requirements.
• Define and enforce enterprise data modeling standards, naming conventions, and governance practices.

• Translate APHIS Regulated Garbage Program Manual requirements into sustainable, automated data flows and scalable relational schemas.
• Support electronic workflows for Compliance Agreements, inspections, monitoring checklists, direct observations, incidents, escalations, and enforcement records.
• Enable FOIA‑ready audit trails and data structures aligned to regulatory workflows.
• Support integration and data exchange with external systems, including CBP Agricultural Workspace, APHIS ARM, IPHIS, FMD, and enterprise authentication systems (eAuthentication, UMS, Login.gov).

• Optimize T‑SQL queries, indexing, performance tuning, partitioning, and cloud SQL configuration.
• Ensure solutions comply with Section 508 accessibility requirements for system‑generated content, forms, and documents.
• Support performance, load, and stress testing for data‑layer components.
• Collaborate with developers to ensure secure, compliant, vulnerability‑free data implementation.

• Participate in Agile ceremonies including backlog grooming, sprint planning, sprint review, and retrospectives.
• Create and maintain user stories, functional and non‑functional requirements, data requirements, process flows, and technical design documentation.
• Support required Azure Dev Ops/TFS artifact population: backlog items, documentation, code repositories, burn‑down/velocity reports, and deployment artifacts.
• Contribute to architecture reviews and ensure alignment to CTIS‑M modernization strategy.

• Provide technical guidance to developers implementing data‑layer features.
• Collaborate closely with cross‑functional engineering, business, and federal stakeholder teams.
• Communicate complex data architecture concepts clearly to technical and non‑technical audiences.
• Support knowledge transfer…