Job Closed
This listing is no longer active.
We are the first public safety operating system empowering over 2500 cities to eliminate crime.
Analytics Engineer
Location
California + 5 moreAll locations: California | Colorado | Illinois | New York | Massachusetts | Texas
Posted
106 days ago
Salary
$125K - $150K / year
Seniority
Senior
Job Description
Analytics Engineer
Flock Safety
• Own end-to-end analytics solutions from definition to data architecture and data visualization. • Streamline single source of truth insights for business in an analytics as code environment. • Drive impact to business stakeholders and balance between technical ownership and business partnership.
Job Requirements
- BS/MS in Computer Science, Mathematics, Statistics, Engineering or related field, or equivalent industry experience.
- 5+ years of proven experience as an analytics engineer, business intelligence engineer, or data analyst.
- Ability to communicate and drive end to end data solutions for complex and abstract problems.
- All-star SQL skills (Redshift a strong plus).
- Experience implementing data modeling best practices in an enterprise data warehouse.
- Expertise in building business intelligence and reporting solutions (Sigma experience a strong plus).
- Familiarity with DBT and GIT, as well as working with Data Engineering and Data Architecture organizations.
- Prior experience with Salesforce and working directly with Revenue, Sales, Customer Success, or Finance teams is a strong plus.
Benefits
- Flexible PTO: We offer non-accrual PTO, plus 11 company holidays.
- Fully-paid health benefits plan for employees: including Medical, Dental, and Vision and an HSA match.
- Family Leave: All employees receive 12 weeks of 100% paid parental leave. Birthing parents are eligible for an additional 6-8 weeks of physical recovery time.
- Fertility & Family Benefits: We have partnered with Maven, a complete digital health benefit for starting and raising a family. Flock will provide a $50,000-lifetime maximum benefit related to eligible adoption, surrogacy, or fertility expenses.
- Spring Health: Spring Health offers a variety of mental health benefits, including therapy, coaching, medication management, and digital tools, all tailored to each individual's needs.
- Caregiver Support: We have partnered with Cariloop to provide our employees with caregiver support.
- Carta Tax Advisor: Employees receive 1:1 sessions with Equity Tax Advisors who can address individual grants, model tax scenarios, and answer general questions.
- ERGs: We want all employees to thrive and feel like they belong at Flock. We offer four ERGs today - Women of Flock, Flock Proud, LEOs and Melanin Motion. If you are interested in talking to a representative from one of these, please let your recruiter know.
- WFH Stipend: $150 per month to cover the costs of working from home.
- Productivity Stipend: $300 per year to use on Audible, Calm, Masterclass, Duolingo and so much more.
- Home Office Stipend: A one-time $750 to help you create your dream office.
Related Guides
Related Categories
Related Job Pages
More Analytics Engineer Jobs
• Developing novel, parallel algorithms to accelerate core problems in data processing and power the next generation of data center workflows • Implementing solutions in C++ and CUDA • Contributing to open source projects, such as cuDF, Velox, Presto and Spark • Benchmarking, profiling, and optimizing code • Working closely with the world’s top experts in GPU hardware, software and workflows
• Take ownership of our BI ecosystem and drive high-impact improvements in data reliability, performance, and business insights. • This role sits at the intersection of data engineering, analytics, and business strategy, working closely with Marketing and cross-functional teams to ensure data is not only accurate — but actionable. • Play a key role in transforming how the company uses data to make decisions. • Own and improve the reliability and performance of dashboards and reporting systems • Design and optimize data models and SQL transformations in the data warehouse • Build and maintain scalable BI solutions using Tableau and cloud data platforms • Implement data quality checks, monitoring, and anomaly detection systems • Partner with stakeholders to translate business needs into robust data products • Improve query performance and reduce reporting inefficiencies • Define and standardize KPI frameworks, especially for Marketing metrics • Ensure documentation, ownership, and governance across all BI assets
• Define and own the multi-year roadmap for the data platform, aligning investments in infrastructure, tooling, and headcount with business strategy. • Lead and grow two high-performing teams—Data Engineering and Analytics Engineering—cultivating a collaborative, feedback-rich environment with clear career pathways. • Architect and oversee scalable data pipelines across ingestion, transformation, orchestration, and delivery, for both batch and streaming use cases. • Champion best practices in analytics engineering, including semantic layer design, dbt modelling standards, data contracts, and metrics governance. • Partner with Data & Decision Science, Product, Finance, and Commercial teams to deliver high-quality, self-serve data solutions aligned to business needs. • Ensure data platform reliability, observability, SLAs, and incident response, treating the platform as a product with real users. • Drive vendor and tool evaluations for the modern data stack (cloud warehouse, orchestration, cataloging, transformation, reverse ETL, etc.). • Set and enforce data quality, documentation, and governance standards to build trust across the business. • Champion use of AI coding assistants and LLM-powered tooling (e.g. Cursor, GitHub Copilot, Claude) to accelerate delivery and reduce toil. • Implement AI-native patterns—LLM-generated documentation, anomaly detection, data quality monitoring, and automated root-cause analysis. • Prototype NL-to-SQL and AI-powered BI tools to empower self-serve analytics for non-technical users. • Build foundational data infrastructure (feature stores, vector stores, model metadata, evaluation datasets) to enable AI and ML experimentation and scale.
• Architect and maintain robust, modular data models in Snowflake using dbt, following industry-standard modeling methodologies (e.g., Kimball). • Write and tune advanced SQL to ensure optimal query performance, cost-efficiency, and resource management within the Snowflake environment. • Implement and manage automated testing, monitoring, and alerting frameworks to ensure data accuracy, freshness, and lineage. • Partner with business units to define KPIs, capture requirements, and translate business logic into technical data specifications. • Own the full data lifecycle from ingestion to production-grade data marts and strategic BI visualizations and dashboard building. • Apply software engineering best practices to data development, including version control (Git), CI/CD, and detailed technical documentation. • Continuous refactoring of legacy code and data structures to improve maintainability and scalability of the analytics stack.




