Professional III, Online Biz Sales Management

Summary Role and Responsibilities Architect and maintain automated Single Version of Truth (SVOT) data pipelines and GAAP-aligned P&L frameworks using advanced SQL, Power Query, and VBA/Macros to consolidate Finance, Supply Chain, CRM, and e-commerce data. Design, write, and optimize complex SQL queries (multi-table joins, CTEs, aggregations, performance tuning) to process and analyze large, structured datasets at scale. Eliminate manual reporting dependencies through workflow automation, improving system reliability, accuracy, and operational efficiency. Perform SKUlevel, cohort-based, and funnel-level analyses to identify statistically significant drivers of conversion, revenue, and margin performance. Build and maintain quantitative models in Excel using advanced formulas, Power Query, scenario analysis, and sensitivity modeling to support: Revenue and demand forecasting; Inventory optimization and risk modeling; Promotional lift, elasticity, and ROI analysis; and Pricing, margin, and P&L simulations. Develop VBA/Macro-based automation to streamline recurring analytical workflows and improve reproducibility. Enable stakeholders to perform structured what-if analyses via scalable, parameter-driven modeling frameworks. Define and operationalize standardized KPI frameworks across traffic, conversion, revenue, margin, inventory health, and customer behavior. Design and analyze A/B and multivariate experiments to quantify the impact of pricing, promotions, merchandising, and UX changes on conversion rate, engagement, and revenue. Forecast Modeling: Perform historical back-testing and scenario simulation to improve forecast accuracy for new product categories. Funnel Decomposition: Quantitatively deconstruct customer journeys to identify system-level inefficiencies and optimize marketing ROI. Pricing & Elasticity Modeling: Model price-response relationships to evaluate volume lift, margin impact, and profitability trade-offs. Develop automated weekly, monthly, and quarterly reporting systems to support technical business reviews. Translate analytical outputs into quantitative, data-backed recommendations for senior leadership. Architect and govern enterprise-level Tableau dashboards that deliver real-time and historical visibility into DTC performance metrics. Implement advanced Tableau features including calculated fields, parameters, LOD expressions, filters, and blended data sources. Design executive scorecards that function as a governed analytical layer supporting strategic decision-making. Develop enterprise-grade Tableau dashboards for real-time monitoring, trend detection, and anomaly analysis. Analyze clickstream and funnel data from Adobe Analytics (or equivalent platforms) to identify friction points and conversion optimization opportunities. Own quantitative and statistical analytical frameworks supporting end-to-end category performance, including revenue, units, ASP, margin, conversion, traffic, attachment rate, and inventory health. Perform SKU-level and category-level quantitative analysis to identify performance drivers, risks, and optimization opportunities. Support category P&L management through quantitative modeling and scenario simulations across pricing, promotions, assortment mix, and inventory positioning. Develop executive-ready performance readouts with clear insights, implications, and data-backed recommendations. Monitor inventory coverage, sell-through, weeks of supply, aging, and out-of-stock risk using quantitative thresholds and predictive signals. Identify early demand shifts and inventory risks, partnering with Supply Chain and Operations on corrective actions. Support assortment and inventory decisions to balance growth, margin protection, and operational efficiency. Lead data-driven and model-based analytical support for end-to-end smartphone product launches, including pre-launch forecasting, launch readiness metrics, and post-launch performance evaluation. Skills and Qualifications