Senior Data Engineer, Nova

Flock Safety is the leading safety technology platform, helping communities thrive by taking a proactive approach to crime prevention and security. The role involves building integrations to various data sources and enhancing the Flock Software Platform to support investigators in connecting disparate data for case work.

Responsibilities:

• Build integrations to the many data sources as well as build stronger bindings to the overall Flock Software Platform
• Work directly with customers and provide high value and real-life impacting results
• Contribute to the frontend of full-stack applications when necessary
• Architect robust 3rd party integrations, ensuring data consistency and reliability when communicating with external APIs
• Design and build scalable ETL workflows and data pipelines
• Optimize performance and handle integrations across a variety of different database systems
• Communicate across multiple teams to solve problems efficiently
• Contribute ideas for how we build better software

Requirements:

• 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
• 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 in microservices and system design
• Confidence with Docker for local development and remote deployment via Helm to Kubernetes
• Experience with AWS managed services (e.g., S3, API Gateway, SNS/SQS)
• Familiarity with Terraform or similar IaC patterns
• Ability to obtain and maintain Criminal Justice Information Services (CJIS) certification as a condition of employment