Yaniv Vainer Email & Phone Number

Tel Aviv District, Israel

Tel Aviv District, Israel

• Data Pipelines: Developed robust pipelines using Python and DBT, integrating multiple data sources into AWS S3 and Athena.
• Orchestration (Airflow): Enhanced workflow efficiency with Apache Airflow and Kubernetes; created a wrapper to reduce new DAG creation time from hours to minutes.
• Orchestration (Prefect): Migrated from Apache Airflow to Prefect, supporting multiple production environments per client.
• Data Access: Implemented Metabase as the primary UI platform for company-wide data access.
• AWS Integration: Integrated multiple AWS services, including DynamoDB Streams, Kinesis, and Firehose, with our data lake for efficient data processing.

Tel Aviv District, Israel

• Tableau Instruction: Taught Tableau with hands-on practice sessions to enhance practical understanding.
• Storytelling and Data Visualization: Discussed theories of storytelling and data visualization to provide a strong conceptual foundation.
• Presentations: Delivered presentations both in-class and online, engaging with diverse audiences.
• Content Development: Authored teaching materials and home assignments to support the learning process.

Tel Aviv, Israel

• End-to-End Data Solution: Designed and built a comprehensive data solution from the ground up as the first Data professional in the company. This included setting up a data warehouse and ELT data pipelines using Python.
• Data Warehousing: Modeled and constructed a data warehouse in AWS Redshift and S3 to support extensive data storage and retrieval needs.
• Dashboard and KPI Development: Created dashboards and KPIs using Tableau to provide actionable insights.
• Data Analysis Tools: Conducted extensive work with Redash and Mixpanel for additional data analysis capabilities.
• Guided Analytics: Provided guided analytics and insights to multiple stakeholders and business units including sales, marketing, accounting, finance, logistics, product, customer service, and production.
• Self-Management and Stakeholder Collaboration: Managed projects independently, collaborated with multiple stakeholders, designed solutions, and provided proactive data analysis as well as responses to ad hoc queries.

• ETL Pipeline Development: Developed ETL data pipelines using Python and Databricks to streamline data processing.
• Automation: Automated various manual tasks performed by the Data Analysis team using Python, improving efficiency.
• Data Warehousing: Modeled and maintained the data warehouse in AWS Redshift to ensure accurate and reliable data storage.
• Dashboard and KPI Development: Created dashboards and KPIs using Tableau to provide actionable business insights.

• BI System Development: Designed and developed new modules for an existing Business Intelligence solution.
• End-to-End Development: Managed the full development lifecycle, including:
• ETL: Utilized SSIS 2012 for efficient ETL processes.
• Data Modeling: Implemented data models using Analysis Services Tabular Model 2012.
• Dashboards and UI: Created dashboards and user interfaces with SSRS 2012, Tableau, and PowerBI.

Development and maintenance of the Oracle data warehouse all Hyperion applications are based on. Maintaining a Hyperion application - working closely with planners and accountants.Working with the BI team as a mediator between BI and Hyperion.

In charge of maintaining and developing the DWH in the organization (SQL Server 2012) by creating new modules, adding ETL processes with SSIS, designing reports and dashboards for business functions and managers within the organization - with SSRS and Business Object.Led a conversion project of hundreds of Business Object reports from BOXI3 to webBO.

Building complex reports in SSRS and BO, SQL and PL-SQL. Working with TM-1 as a data cube analysis tool. Developing in OLAP 2008r2.

Maintenance and development of the client entire BI solution.It includes complex reports and dashboards in Panorama, complex queries in SQL, handing JAVA malfunctions, developing in Microsoft SQL Server 2000/2005/2008r2 (SSIS (and DTS), SSAS,SSRS).

Ba, Economics, Logisitcs

Bi, Business Intelligence