Night Shift Postgresql Jobs (NOW HIRING)

Job Summary:
Flock is dedicated to building technology that reduces crime and protects privacy. The Senior Software Engineer will drive the architectural evolution of Nightshift, creating backend systems that connect a conversational interface to a complex data platform, ultimately aiding investigators in solving cases more efficiently.
Responsibilities:
• Lead the effort to build reliable backend systems that connect a conversational interface to a large, complex data platform.
• Design the orchestration backend that manages complex LLM interactions.
• Develop high-performance integration pipelines connecting Nightshift to Flock's massive data platform.
• Build the agentic framework that allows Nightshift to "act" on behalf of investigators.
• Partner with ML engineers on agentic workflows and platform teams to design robust APIs that keep the system accurate and performant as we process billions of data points daily.
• Familiarize yourself with Flock’s investigative workflows and the massive data pipelines that power our platform.
• Pair with ML (agentic systems), Data Engineering (investigative datasets), and Platform teams to understand the existing API landscape.
• Complete your first push to production.
• Pick up initial sprint tickets focused on API integrations, backend bug fixes, or performance tuning for LLM streaming.
• Implement the backend orchestration layer for LLM tool calling and multi-step reasoning.
• Design and build the "connectors" that allow Night Shift to securely and efficiently query Flock’s core data services.
• Stand up robust tracing and logging for the AI system to monitor agentic decision-making and reliability.
• Own end-to-end backend features that connect the LLM to our internal APIs, ensuring low-latency responses for investigators.
• Lead the development of a core Nightshift capability—like automated lead generation or cross-camera correlation—that demonstrably closes cases faster.
• Establish best practices for testing and deploying AI agents within a microservices environment.
• Influence the product direction by identifying how new backend capabilities or AI breakthroughs can solve untapped investigator pain points.
Qualifications:
Required:
• Love for writing clean, performant code and a track record of building production-grade backend systems.
• Strong proficiency in Python or TypeScript (Node) for building scalable web services.
• Ability to write and optimize complex SQL queries and data access patterns to ensure LLMs are grounded in real-time data without sacrificing latency or system performance.
• Strong database confidence with PostgreSQL, OLAP Databases, and Redis. You know how to use the right tool for the job to ensure fast retrieval.
• A strong product instinct and a track record of shaping what you build based on direct customer feedback.
• Experience with microservice-oriented architecture and designing for scale (we handle 1B+ images daily).
• Experience with agentic patterns, including function calling, tool use (MCP), and orchestrating multi-step LLM workflows.
• Experience with OpenAI/Anthropic/Gemini APIs, prompt engineering, and managing complex conversation state/context.
• Proven ability to bridge unstructured LLM outputs and structured internal services, with robust error handling and schema validation.
• Proficient with AWS services, Kubernetes (EKS), Docker, and CI/CD build tooling.
• You thrive in 'zero-to-one' environments, taking ambiguous problems and turning them into technical roadmaps.
• Experience with LLM evaluation (LangSmith/Langfuse), vector search/RAG, or infrastructure-as-code (Terraform).
Company:
Flock Safety is the leading public safety platform designed to help communities prevent and reduce crime, not just respond to it. Founded in 2017, the company is headquartered in Atlanta, USA, with a team of 1001-5000 employees. The company is currently Late Stage.