Tzachi Golan

Vast experience as a BI System Analyst & Project Manager in companies in the finance, insurance & retail industries. Having extensive expertise in planning and implementing complex BI systems and designing end-to-end BI solutions. I held leadership roles in global organizations and successfully managed BI departments effectively to reach company's goals and deliver data quality BI solutions.

BI Projects Manager at Ayalon insurance, Raval & Novolog (2025-01 – 2026-12)

• Lead the end-to-end Power BI lifecycle from business requirements gathering to delivery of executive dashboards
• Translated business needs into clear KPIs and reporting specifications
• Created analytical data models for several departments and quality processes to ensure trusted and consistent insights
• Responsible for dashboards design to deliver clear, actionable, decision-focused visualizations

BI Training Program Lead at Experis Academy (2023-01 – 2024-12)

• Leading the BI Data analysts Developers training program (650 hr.) from both operational and academic perspectives
• Developed a comprehensive curriculum from scratch, and created a high-quality content, focusing SQL Server, SSIS, SSAS, Tabular models, Python, Data Visualization in Power BI & implementing modern BI methodologies in Azure cloud platform

BI Team Leader at Nespresso (Nestlé Group) (2021-01 – 2023-12)

• Leading the BI Project Vision - An overall replacement of the existing BI solution to a modern, unified DWH in Azure
• Leading the strategic planning of the BI department Roadmap & budget - from the business requirements gathering, all through design, development and delivery - to managing and training 6 BI Developers & Data analysts
• Main responsible for business models definition, development, reports and dashboards creation - using Microsoft Cloud technologies in Azure & Power-BI
• Building a Business Information solution from scratch for departments such as B2B, B2C (including Nespresso's boutique stores), Customer Service, and Finance
• Overall responsibility for the roll-out of the BI solution across all company's departments in Israel

BI Project Manager at Factory 54 (2020-01 – 2021-12)

• Hands on DWH Project Manager
• Building a Data roadmap and managing the implementation processes for multiple internal data suites ETL's and dashboards in Power-BI
• Defining architecture, data models and ETL design in order to insure data governance and single source of truth in Azure using VM, Server, Cloud DB and Data Factory
• Building specification documents, mockups and Stored procedures
• Working with C-level on data requirements
• Recruiting BI Developers for our BI department through Interviews and designed technical tests

BI System Analyst & Project Manager at Freelance (2020-01 – 2026-12)

BI Lead at Carebox Healthcare Solutions (2019-01 – 2020-12)

Top Projects: AstraZeneca, All Covid-19 Clinical Trials

• Responsible for the design and architecture of the analytics platform used by Carebox clients (major global pharma companies such as AstraZeneca). Main responsible for data architecture, data quality, and data visualization in Power-BI
• Create and execute work plans according to strategic goals
• Specific responsibilities include the design and maintenance of databases in SQL Server; Planning ETL processes and implementing it by writing SQL stored procedures, visual design using Power-Bi including end-user presentation for senior management

BI System Analyst at Altria Israel (2017-01 – 2019-12)

• Closely working with various departments and Brand managers at Altria, studying their needs and requirements to provide analysis that drives business decisions
• Building and analyzing interactive, self-updating data reports to provide on-demand insights for product managers and decision makers
• Ran analysis sessions for Altria management to provide an overview of Brands and product operation
• Writing specifications for BI system development for Altria's products

BI Team Leader at BG BOND (Ashtrom Group) (2015-01 – 2017-12)

• Managed BI & DWH team through full lifecycle projects including gap analysis, MDM, and OLAP implementation
• Designed and delivered enterprise-wide dashboards and KPIs
• Led executive-level requirement gathering and architectural planning

BI Developer at HOT Mobile (2013-01 – 2015-12)

• Developed and maintained SSIS packages and dynamic ETLs to centralized DWH
• Built stored procedures and SSRS reports based on business requests
• Improved data reliability and performance through scalable design