- Department of one- Creating company-wide KPIs/metrics, and providing insight to C-level weekly basis to reinforce data-informed business decisions- Conducting divergent data analyses around feature performance and user behaviors- Contributing brainstorming sessions around the construction of new features - Spotting the bugs and improvement areas by reviewing qualitative user data, creating backlog tickets- Owning end-2-end ELT processes- Building and maintaining efficient & reliable data models- Implementing data quality & monitoring best practices- Continuously collaborating with other departments to serve data needsStack: Fivetran, BigQuery, dbt, Git, Elementary, Metabase

-Maintained and built data pipelines and model transformations in ETLeap & dbt and made sure data is up-to-date, available and reachable-Built cockpit dashboards which facilitate understanding areas of improvement, defining KPIs, and getting an understanding of Looker's health in performance and costs-Developed best practices and standards around Looker among dbt model and content development, onboarding/offboarding and archiving processes that have an impact on optimization, performance and cost-Identified and resolved various issues that occurred across our data stack (dashboard, lookml and dbt model level) that had an impact on cost and performanceStack: Looker, dbt, ETLeap, Git, Snowflake, Datadog

-Owned whole project aiming at the automation of fulfillment CPO(Cost per Order) calculation for operations team-Created cross-departmental KPI for the perfect order estimation by analysing customer support and operational data-Saved company’s data infrastructure costs by migrating Power BI dashboards to Looker-Created extensive monitoring around crucial company’s datasets to ensure data accuracy and qualityStack: Looker, Azure Data Factory, Git, Fivetran, Stitch, dbt, PostgreSQL

-Supported the category management team in all operational matters by placing the purchase orders into the system and checking them for accuracy-Raised the repurchased orders to ensure the availability of the products in the warehouse-Helped the team by fulfilling the product catalogs and preparing presentations to have a seasonal overviewStack: MS Office Products

-Restructured the PMS (Portfolio Management System) data mart by detecting redundant sources and re-developing the ETL implementations-Created & scheduled efficient working pipelines in Informatica PowerCenter-Modelled the new structured data mart in PowerDesignerStack: PL/SQL, Informatica PowerCenter, SAP PowerDesigner