Senior BI Engineer

The role

You will design and build data models and pipelines to turn raw events into trusted data. You will partner with analysts, actuaries, product, and engineering to shape modern tooling and AI usage.

What you will do

• Design and own dimensional and domain data models in Snowflake
• Develop incremental, tested and version-controlled transformations with dbt, Python and Airflow
• Implement tests, data contracts, monitoring and alerting
• Tune queries, warehouses and models to optimize performance and cost
• Build a semantic/metrics layer and clean data for analysts and AI agents
• Use AI-assisted tooling to accelerate development
• Drive POCs, migrations and architecture decisions
• Translate business questions into scalable data solutions

Required qualifications

• 4+ years of experience as a BI Engineer, Analytics Engineer or Data Engineer
• 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 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
• Experience with Git-based workflows and CI/CD for data
• Strong ownership
• Excellent communication skills in English and Hebrew

Nice to have

• 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
• B.Sc. in Industrial Engineering & Management, Information Systems, Computer Science or a related field

Benefits

• Competitive salary and benefits package
• Emphasis on work-life balance
• Offices in the heart of Tel Aviv

About the company

At-Bay is an insurance company built by cybersecurity experts that leverages technology to understand digital risks. They are distributed globally with hubs in San Francisco, New York City, Atlanta, and Tel Aviv.