Flock Safety is looking to build a "single pane of glass" for investigators to connect disparate data sources, making it easier to "connect the dots" and build a picture around their case work. The technical challenges to enable these tools are diverse and sophisticated, requiring strong engineers to build integrations and strengthen bindings to the overall Flock Software Platform.
Requirements
- Strong proficiency in Python for data processing, with the ability to switch to TypeScript/Node.js to support our PERN stack application.
- Extensive experience designing and building scalable ETL workflows and data pipelines. (Experience with orchestration tools like Airflow or Prefect is a strong plus).
- Deep expertise with PostgreSQL and advanced SQL skills. You are comfortable writing complex queries, optimizing performance, and handling integrations across a variety of different database systems.
- Experience architecting robust 3rd party integrations, ensuring data consistency and reliability when communicating with external APIs.
- Familiarity with the React ecosystem (or similar frameworks like Vue/Angular), with the ability to contribute to the frontend of our full-stack applications when necessary.
- Confidence in system architecture with a focus on scaling data pipelines and managing high-volume data ingestion.
- Confidence with Docker for local development and remote deployment via Helm to Kubernetes.
Responsibilities
- build integrations to the many data sources
- build stronger bindings to the overall Flock Software Platform
- designing and building scalable ETL workflows and data pipelines
- writing complex queries, optimizing performance, and handling integrations across a variety of different database systems
- architecting robust 3rd party integrations, ensuring data consistency and reliability when communicating with external APIs
- contribute to the frontend of our full-stack applications when necessary
- scaling data pipelines and managing high-volume data ingestion
Other
- Love for coding and a commitment to continuous learning.
- A resourceful problem-solver mindset, excelling in ambiguous situations and taking initiative.
- Desire to grow your role and directly influence the growth of a young company.
- Excitement about working on a fast-paced, constantly evolving product.
- If an offer is extended and accepted, this position requires the ability to obtain and maintain Criminal Justice Information Services (CJIS) certification as a condition of employment. Applicants must meet all FBI CJIS Security Policy requirements, including a fingerprint-based background check.
