Senior BI Engineer

Responsibilities

• develop incremental, tested and version-controlled transformations with dbt, Python and Airflow, ingesting data from internal services, SaaS tools and third-party APIs.
• implement tests, data contracts, monitoring and alerting so stakeholders can trust the numbers.
• tune queries, warehouses and models; keep Snowflake spend efficient as data volumes grow.
• build a well-defined semantic/metrics layer and clean, documented data that analysts, BI tools and LLM-based agents can query safely.
• use tools such as Claude Code / Copilot to accelerate development, and help the team adopt best practices around them.
• drive POCs, migrations and architecture decisions, and raise the bar through code reviews and mentoring.
• translate business questions from underwriting, finance, product and leadership into scalable data solutions.

Requirements

• Expert SQL skills, including reading query plans and optimizing performance at scale
• Strong experience in DWH design and dimensional modeling (Star schemas, SCDs, incremental loads)

Experience with Git-based workflows and CI/CD for data

• Strong ownership - you take projects from ambiguous requirements to production
• Excellent communication skills in English and Hebrew, and the ability to explain technical trade-offs to non-technical stakeholders
• B.Sc. in Industrial Engineering & Management, Information Systems, Computer Science or a related field

The Role

Our BI team is the backbone of how At-Bay makes decisions. We own the data warehouse and the models behind underwriting, pricing, claims, finance, sales and product analytics - and increasingly, the data that powers AI agents and self-serve analytics across the company.

As a Senior BI Engineer, you will design and build the data models and pipelines that turn raw events from our platform and partners into trusted, well-documented data. You will partner closely with analysts, actuaries, product, and engineering, and help shape how we use modern tooling - including AI - to deliver data faster and more reliably.

Model the business

design and own dimensional and domain data models in Snowflake that serve as the single source of truth for key metrics.

Requirements

4+ years of experience as a BI Engineer, Analytics Engineer or Data Engineer

Experience with Snowflake (performance tuning, cost management, RBAC)

• Experience with orchestration tools such as Airflow, Dagster or similar
• Hands-on experience with dbt in production (models, tests, macros, documentation)
• Proficiency in Python for data pipelines, automation and integrations

Advantages

Experience with a semantic layer / metrics store and BI tools (e.g., Looker, Tableau, Power BI, Sigma)

Experience with data observability and quality tooling

• Experience building data foundations for LLMs or AI agents (e.g., text-to-SQL, MCP, RAG over structured data)
• Background in insurance, fintech or cybersecurity data

Our Stack

Snowflake · dbt · Python · Airflow · PostgreSQL · MySQL · AWS · Git / GitHub Actions · AI-assisted development tools

Location

Tel Aviv, Israel (near the train station and main bus stops) · Hybrid- 3 days in office

and benefits package

A real impact on how a leading cyber insurer prices risk and makes decisions

A genuine emphasis on work-life balance

• we mean it, not just say it
• Beautiful offices in the heart of Tel Aviv, easily accessible by train and bus
• Smart, passionate, and fun colleagues who take pride in their work
• Challenges you won't find anywhere else we're a unique blend of a fast-moving tech startup, an international firm, and an insurance company