Gal Unger Email & Phone Number

• Design, maintain and develop ETL processes from various data sources including data warehouse (DWH) and various databases: Teradata, SQL Server and Hive using complex SQL scripts and Alteryx. Improve performance of old ETL processes and SQL queries • Maintain the department’s DB tables for analysts including monitoring the data integrity and validity.• Design end-to-end advanced dashboards including developing data models, calculated fields and visualizations using Power BI and… Show more • Design, maintain and develop ETL processes from various data sources including data warehouse (DWH) and various databases: Teradata, SQL Server and Hive using complex SQL scripts and Alteryx. Improve performance of old ETL processes and SQL queries • Maintain the department’s DB tables for analysts including monitoring the data integrity and validity.• Design end-to-end advanced dashboards including developing data models, calculated fields and visualizations using Power BI and Tableau. Optimize old dashboards for better performance.• Utilize advanced data modeling and DWH techniques to create robust data structures for BI reporting and analytics needs.• Collaborate with multidisciplinary stakeholders and cross-functional teams including DBAs, product managers, software developers, data analysts and data scientists to develop customized BI solutions. Show less

Rishon Lezion Area, Israel

• Develop and maintain ETL/ELT pipelines from various data sources: CRM, marketing data, DBs, Google Analytics and more using GCP BigQuery, cloud functions, Dataflow, Dataform (DBT equivalent) Fivetran, Python and SQL scripts.• Plan and develop BI dashboards and reports using Google Looker Studio and Power BI for CEOs, CMOs, CTOs, product managers and analysts. Advise on which tech stack is best for the client’s needs.• Design the client’s data structure based on the project needs and… Show more • Develop and maintain ETL/ELT pipelines from various data sources: CRM, marketing data, DBs, Google Analytics and more using GCP BigQuery, cloud functions, Dataflow, Dataform (DBT equivalent) Fivetran, Python and SQL scripts.• Plan and develop BI dashboards and reports using Google Looker Studio and Power BI for CEOs, CMOs, CTOs, product managers and analysts. Advise on which tech stack is best for the client’s needs.• Design the client’s data structure based on the project needs and for future scalability on GCP BigQuery, develop data from various sources to one source of truth for BI reports.• Lead digital data measurement projects, including managing teams of 3-5 multidisciplinary team members in each project. • Implement Google Analytics (GA) measurement using Google Tag Manager (GTM), GA4, Firebase and digital measurement solutions in web products and apps including specification documents, event in JavaScript and technical implementation in measurement tools. Show less

Or Yehuda, Tel Aviv, Israel

• Developed and Maintained the marketing data warehouse on Google BigQuery, includingThe design and data modeling, ETL/ELT processes from various data sources using complex SQL scripts, Fivetran.• Wrote complex SQL queries to extract and transform data from the data warehouse (DWH) and from various data sources using Microsoft SQL Server (SSMS) and Google Big Query (GCP), and optimized queries in BI reports.• Designed end-to-end advanced dashboards including developing data models… Show more • Developed and Maintained the marketing data warehouse on Google BigQuery, includingThe design and data modeling, ETL/ELT processes from various data sources using complex SQL scripts, Fivetran.• Wrote complex SQL queries to extract and transform data from the data warehouse (DWH) and from various data sources using Microsoft SQL Server (SSMS) and Google Big Query (GCP), and optimized queries in BI reports.• Designed end-to-end advanced dashboards including developing data models, calculated fields and visualizations using Datorama, Power BI, PowerQuery and Google Data Studio. • Translated business requirements to data solutions by writing technical specification documents, defining tasks and implementing them with relevant tools.• Collaborated with multidisciplinary stakeholders including product managers, developers, analysts, data scientists and business users as part of different data projects and analysis. Show less

Rishon Lezion, Center District, Israel

• Developed and maintained data models, dashboards and reports using Power BI and Google Looker Studio.• Conducted advanced analysis to extract valuable business insights.• Implement Google Analytics (GA) measurement using Google Tag Manager (GTM), Google Analytics, Firebase and digital measurement solutions • Collaborated with stakeholders to gather requirements and translate them into technical specifications for marketing, product and sales dashboards and reports.

ReẖOvot, Central, Israel

Planned and executed digital strategy, analyzes data and increases business growth.• Extracted and transformed marketing, sales and products data using Excel to clean and enrich data, and loaded the data to the organizational data warehouse (DWH).• Designed and implemented BI dashboards and reports in Excel and Google Data Studio and conducted data analysis to provide recommendations to support marketing and sales decision makers.• Collaborated with multidisciplinary teams of R&D… Show more Planned and executed digital strategy, analyzes data and increases business growth.• Extracted and transformed marketing, sales and products data using Excel to clean and enrich data, and loaded the data to the organizational data warehouse (DWH).• Designed and implemented BI dashboards and reports in Excel and Google Data Studio and conducted data analysis to provide recommendations to support marketing and sales decision makers.• Collaborated with multidisciplinary teams of R&D developers, sales managers, operations managers, vendors, business partners and high management as part of digital projects.• Successfully planned and executed digital marketing strategy, managed PPC campaigns on multiple platforms and managed the company’s digital assets which assisted the growth of the company’s revenue. Show less

Industrial And Management Engineering, Business Intelligence

Practical Engineering, Civil Engineering