Full-Stack Engineer

Spear AI is seeking a versatile software developer who works across both the client-side and server-side of web applications, with the skills to build complete, end-to-end solutions. This comprehensive role involves implementing responsive user interfaces, implementing business logic, building and optimizing databases, creating API integrations, and ensuring cross-platform compatibility.Beyond technical expertise, successful Full Stack Engineers demonstrate strong problem-solving abilities, effective communication with technical and non-technical team members, time management skills, and adaptability to learn new technologies. This role also provides opportunities for career advancement toward specialized positions, technical leadership, or engineering management.Spear AI servers the national security industry and deploys software to cloud environments that span unclassified, Secret, and Top Secret regions. We also deploy software to the edge in some of the harshest conditions, including US nuclear submarines.The ideal candidate has experience with both front-end and back-end development, with a strong comfort in relational databases. Candidates with a GitHub (or other open-source) profile stand out because we can check their work for attention to detail and code quality.Front-end (Essential)Tailwind CSSTypeScriptReact / Next.jsExperience with modern build tools (Vite, Webpack)Server-side rendering (SSR)React Error boundaries and suspenseFamiliar with RESTful APIs (GraphQL is a plus)State management (React Context, Zustand, Redux, etc.)Back-end (Essential)Node.jsPython / mypyAuthentication and authorization (OAuth, JWT, etc.)Validation (Zod, Valibot, etc.)Logging and monitoring (Sentry, etc.)Unit testing and integration testing (Vitest, etc.)Database ManagementRelational databases (PostgreSQL, MySQL, etc.)Data modelingSchema migrationsAdvanced SQL concepts (window functions, CTEs, materialized views, stored procedures, and triggers)Performance optimization (indexing, EXPLAIN ANALYZE, etc.)ETL and data pipelinesExperience with Kafka, RedPanda, or other streaming platforms is a plusDevOpsCI/CD (GitHub Actions, GitLab Pipelines, etc.)DockerDocker Compose (Kubernetes is a plus)Infrastructure as Code (Pulumi, Terraform, etc.)Semantic VersioningDeployment strategiesFeature flagsLinting / formatting (ESLint, Prettier, etc.)AWS or other cloud providers