Analytics Engineer

You are looking for a role that challenges you intellectually and lets you build data systems that truly matter. You have an analytical and entrepreneurial mindset, you enjoy solving complex technical problems, and you thrive in a fast-paced startup environment. Most of all, you want your work to drive meaningful impact at scale.

We're Darrow, a fast-growing legal tech startup with an open, action-driven culture unlike any other. Our mission is "frictionless justice," and we use advanced Machine Learning and AI to transform the justice system. Working at Darrow means knowing that every dataset you design, every pipeline you automate, and every dashboard you build contributes to justice at scale.

Darrow has more than 130 team members across Tel Aviv and New York and is backed by world-class investors including Georgian, F2 Venture Capital, Entree Capital, NFX, and Y Combinator.

We are looking for a analytics  Engineer to join our growing Data & Ops team. In this role, you will build the analytical infrastructure, datasets, and models that power the company's performance visibility, forecasting capabilities, and operational excellence. You will enable teams to move faster, rely on accurate data, and make smarter decisions — all while contributing to a mission that impacts the lives of millions.

If you are highly motivated, detail-oriented, and eager to turn data into scalable, automated insights, this role is for you. You're a team player, open-minded and collaborative, with the ability to translate business needs into technical solutions. You embrace ownership, move quickly, and are excited to help shape the BI systems that drive Darrow forward.

Responsibilities:   

• Design, build, and maintain scalable BI datasets, data models, and automated pipelines that serve core business and operational workflows.
• Collaborate closely with analysts, product stakeholders, FP&A, and legal data teams to understand their needs and translate them into reliable, scalable analytical solutions.
• Ensure data quality, system reliability, and smooth information flow across databases, BI models, and internal tools.
• Develop efficient SQL logic, transformation layers, and automation scripts that support high-quality dashboards and performance monitoring.
• Leverage AI tools and advanced prompting to enhance data enrichment, analytics automation, and stakeholder self-service capabilities.
• Document data models, define BI standards, and continuously improve performance, stability, and usability of analytical infrastructure.
• Stay up to date with modern analytical engineering practices, data modeling frameworks, and AI-driven analytics approaches to keep Darrow's BI ecosystem scalable and cutting edge.

• At least 3 years of hands-on experience as a BI Analyst / Analytics Engineer / BI Engineer, working with large-scale datasets and complex analytical environments- must.
• Expert-level SQL (PostgreSQL AND Bigquery) with proven ability to design data models, optimize heavy queries, and build scalable ETL/ELT pipelines for high-volume workloads.
• Strong analytical engineering skills, including building semantic layers, reusable metric logic, and BI data marts that support millions of records and near real-time analytics.
• Hands-on experience with Python for data transformations, automation scripts, and API integrations in production environments.
• Proven experience delivering dashboards and analytical applications (Power BI, Tableau, or similar).
• Deep understanding of data quality, governance, validation frameworks, and performance troubleshooting across the BI pipeline.
• Experience working with AI-assisted enrichment and LLM-based automation, with the ability to integrate AI tools into analytical workflows when beneficial.
• Strong problem-solving and communication skills, with the ability to translate ambiguous business questions into clear, scalable data solutions.
• High level of English.