Senior Software Developer / Solution Architect

At i360technologies, we deliver business consulting and technology solutions that support the mission of federal agencies. We are Database Developer to design and implement the data architecture supporting the federal agency’s BOAT low-code platform. This role is responsible for data modeling, integration, migration, and ensuring secure, scalable data operations aligned with federal data and security requirements.

Implements data model, data platform read/write, external API consumers, file metadata schema, and Data Migration Plan if applicable. Supports data security controls and ATO data-handling artifacts. Own the data and integration backbone of the BOAT platform for client. Design and implement the data model, file metadata schema, data platform read / write integrations, and external API consumers that connect BOAT to the pilot Program and the broader registration, inspection, compliance, and enforcement data ecosystem (SafeSpect, State PCR Repository, ELD data, TruData, CCFP Analysis Datamart). Produce the Data Migration Plan when applicable and lead all data-handling artifacts that support Authority to Operate (ATO).

Key Responsibilities

• Design and implement the BOAT data model supporting case management, dynamic data collection, role-based access, and persona-based reporting and analytics for the pilot Program.
• Build read / write integrations with the client data platform; implement external API consumers to ingest data from SafeSpect, State PCR repositories, ELD feeds, and other authoritative sources.
• Implement the file metadata schema for narrative reports, images, video, and other artifacts uploaded through the BOAT submission interface; ensure metadata associates each file to the correct case record.
• Author the Data Migration Plan when applicable — source-system profiling, mapping, transformation rules, validation, and rollback strategy — with delivery at the end of Discovery (Week 2).
• Implement and document data-security controls aligned to client policy, NIST SP 800-53, NIST SP 800-122 PII protection, and FIPS 140-2 encryption; produce data-handling evidence for the A&A artifact pack.
• Cross-train on BOAT platform configuration during Discovery and pair regularly with the Senior Software Developer to mitigate single-point-of-failure risk on platform-specific work.
• Support performance testing in Sprint 5 — query optimization, indexing, data volume profiling, concurrency tuning — and execute remediation in Sprint 6.
• Contribute to the Detailed Technical Design Document and the User Guide with data-layer architecture, schemas, integration contracts, and operations guidance.
• Sustain the data layer across option periods — refactor only where unique business rules require it; reuse and normalize patterns across applications to reduce long-term maintenance cost.

Qualifications

• Minimum 7 years of hands-on database development experience across relational engines (PostgreSQL, Oracle, SQL Server) and at least one document or non-relational store (MongoDB, DynamoDB, Cosmos DB, or equivalent). NOTE: this may changed based on Doug’s LC selection
• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related discipline (or equivalent professional experience).
• Demonstrated hands-on experience with AWS data services — RDS, Aurora, DynamoDB, S3, Glue, Lambda, or comparable — operating inside an AWS Virtual Private Cloud (VPC).
• Demonstrated data migration experience on regulated federal systems — including source profiling, schema mapping, transformation, validation, and rollback.
• Strong API design and integration experience — REST / JSON, OAuth, API gateways, message-based integration patterns.
• Working knowledge of federal data security and privacy requirements: FISMA, Privacy Act of 1974, NIST SP 800-53, NIST SP 800-122, DOT Order 1351.37, and Sensitive PII handling.
• Experience supporting Authority to Operate (ATO) — producing data-layer evidence for system security plans, control narratives, and continuous monitoring. Experience with APIs and data integration pipelines
• Experience working in agile development environments

Preferred Qualifications

• Hands-on experience with the proposed BOAT platform's data layer (Power Platform / Dataverse, Unqork, Appian, ServiceNow, or equivalent).
• Experience with regulated mission data sets.
• Familiarity with Login.gov or other federated identity solutions and how they propagate into row-level / role-based data access.
• Performance-tuning expertise on Oracle 19c PL/SQL, SQL Server, or PostgreSQL for high-volume federal workloads.
• Familiarity with SAFe Agile, two-week sprint cadence, and the JIRA / Confluence toolchain.

Key Attributes

• Strong analytical and data design skills
• Ability to work across application, integration, and analytics layers
• Detail-oriented with focus on data quality and performance

Security & Eligibility Requirements

• Ability to obtain and maintain a federal Public Trust (suitability) clearance
• Must be able to pass a federal background investigation
• U.S. Citizenship or Permanent Residency required (no visa sponsorship available)

Benefits

• Holidays - Eleven
• Adoption Assistance
• Retirement Plan (401k) Matching
• Tuition Reimbursement
• Family Leave, Maternity, Paternity
• Short-Term & Long-Term Disability
• Life Insurance (Basic, Voluntary & AD&D)
• Health Care Plan (Medical, Dental & Vision)
• Paid Time Off (0-3 years - 15 Days PTO | 3+ years 20 Days)

Equal Opportunity Employer Minority/Female/Veteran/Disability

All qualified applicants will receive consideration for employment regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or status within any other protected group.

Only direct applicants will be considered. Submissions from recruiting or staffing firms will not be accepted.