Data Analyst (Pricing)
Current• Data Standards & Efficiency: Established new data standards and metrics, improving record accuracy and data gathering efficiency, boosting team productivity.• Advanced Excel & Pivot Tables: Streamlined datasets using advanced Excel functions and Pivot Tables, enabling rapid retrieval of product details and pricing, enhancing team efficiency.• ETL Processes & Regression Analysis: Led SQL-based ETL processes and applied Python-based linear regression to shift from value-based to demand-based pricing, increasing profits by 9% in 2023.• Time-Series Forecasting: Analyzed order and quotation records with Python, developing time-series forecasting models to dynamically adjust pricing, improving product win rates by 11% in 2023.• Data Visualizations: Conducted Exploratory Data Analysis (EDA) on quotation records, creating charts and dashboards using Tableau to support data-driven decision-making.• Cross-team Collaboration: Worked with sales and marketing departments to present data insights, optimizing marketing strategy for slow-moving products, boosting sales by 24% and reducing costs by 31% in 2023.• Market Price Dataset: Set up a historic market price dataset from supplier and competitor quotes, enhancing pricing competitiveness and increasing win rates by 21% in 2023.• Training & Development: Educated colleagues on basic data analysis and visualization with Tableau, accelerating task completion.
