Commercial Planning Analyst

Description

The Commercial team is responsible for managing all brand sales points, including stores, gazebos, and digital sales representatives, executing the sales strategy and aligning the teams across each Tania Bulhões branch. **About the role** We are seeking a dedicated and proactive individual to join our Commercial team. If you are communicative, customer experience–focused, skilled at building lasting relationships and connections, and capable of facilitating collaboration between stores and other teams, this role is for you. This person will be responsible for monitoring national commercial performance, developing strategic analyses, providing operational support to stores, and managing Tania Bulhões’ commercial tools and processes—ensuring indicator visibility, decision-making support, and continuous operational improvement. **Responsibilities and duties** **Key Responsibilities** **Commercial Management and Performance** * Monitor daily sales results from stores, gazebos, and outlets; * Track commercial KPIs such as revenue, average transaction value, PA (Productivity per Associate), target achievement, productivity, and margin; * Prepare daily, weekly, and monthly reports for the commercial leadership; * Identify commercial opportunities and operational deviations; * Develop action plans and performance diagnostics; * Conduct seasonality, campaign, and sales behavior analyses; * Support the commercial team in defining and tracking targets; * Create executive materials for management and board meetings; * Monitor commercial performance by collection and pricing phase (full price, promotion, clearance), cross-referencing sell\-out data with available inventory; * Monitor P\&L per store. * Monitor mystery shopper program. **Reporting and Dashboards** * Build dashboards in Excel; * Monitor dashboards in Power BI; * Automate operational controls and reporting; * Consolidate national commercial information; * Validate consistency of databases and KPIs; * Structure financial and operational analyses to support decision-making; * Produce presentations to communicate results to the board and partner areas. **Excel, SQL, and Data Processing** * Develop and maintain advanced control and tracking spreadsheets; * Create and update pivot tables, advanced formulas, and automations; * Process, clean, and structure databases; * Develop SQL queries for data extraction via Metabase; * Cross-reference data from multiple sources; * Validate sales, order, and operational KPI data; * Structure segmented analyses by transaction value, category, region, and customer profile; **Operational Standardization** * Support implementation of SOPs (Standard Operating Procedures); * Organize operational implementation timelines and phases; * Ensure process standardization across stores; * Monitor supplier payments, opening tickets with Finance as needed. **Commercial Campaigns and Incentives** * Design sales incentive campaigns ("commercial races"); * Create and maintain commercial rankings by store and consultant; * Consolidate results and rewards; * Ensure timely reward deliveries with logistics coordination. **Commission Analysis and Modeling** * Model and simulate commission scenarios for sales teams, comparing the impact of different rules on individual consultants’ and stores’ outcomes; * Decompose remuneration variations into volume effect and rule effect, quantifying the isolated impact of commercial policy changes; * Validate commission spreadsheets against actual revenue data, identifying inconsistencies and correcting calculation bugs; **Cross-Functional Interface** * Interface with Commercial, Supply, Operations, Marketing, Finance, and Technology teams; * Ensure alignment of information across departments; * Support implementation of new processes and projects; **Requirements and qualifications** * Prior experience in sales; * Exceptional communication and persuasion skills; * Results orientation and motivation to achieve sales targets; * Advanced Excel (formulas, pivot tables, Power Query, automations); * Power BI; * SQL (data extraction, joins, filters, aggregations in data warehouse); * Advanced Office suite; * Dashboard development; * Analysis of commercial and financial KPIs; * Commission scenario modeling; * Project management and product roadmap; * Executive presentations; * Process organization and structuring; * Corporate communication. **Additional information** **Behavioral Profile** * Organization; * Analytical mindset; * Proactivity; * Sense of urgency; * Strong communication; * Attention to detail; * Ability to handle multiple simultaneous demands; * Prioritization capability; * Collaborative attitude; * Results orientation; * Autonomy to manage end-to-end projects. #### **ABOUT TANIA BULHÕES** With over **30 years in the market**, we are an authentically Brazilian brand specializing in **authorial products** across tableware, perfumery, and wellness. The uniqueness of Brazil and the delicacy of nature are ever-present in our creations—be it hand-painted porcelain or fragrances that evoke olfactory explosions. #### **WHAT IT’S LIKE TO WORK HERE** Our work environment is dynamic. Experience, learning, and innovation happen constantly. We are in full expansion, present in nearly all states of Brazil and with international operations headquartered in Miami. In early 2022, we formed a partnership with the private equity fund Treecorp, which became a minority shareholder in the company—a significant step toward increasing the share of fragrance and skincare verticals within the brand, investing further in communications and new product development. #### **OUR BENEFITS** * **Transportation Allowance** – Support for commuting to work; * **Meal Allowance** – For meals during your workday; * **Life Insurance** – Coverage for unforeseen situations, ensuring security and peace of mind; * **Medical and Dental Assistance (employee only)** – Care for your health, exclusively for you; * **Exclusive Discount on Tania Bulhões Products** – Take home the beauty and essence of our brand; * **Birthday Day Off** – A day off to celebrate your way; * **Access to Gympass/Wellhub** – Physical and mental well-being with flexibility and convenience; * **Monthly Zenklub Consultations** – Two sessions per month with emotional health professionals to care for your mind; * **Discounts on MBAs and Postgraduate Programs** – Encouragement for your development with special conditions through partner institutions. Want to grow with us? Check out the **available opportunities**! Also explore other career pages from the brand: **Tania Bulhões International** **Bosque Tania Bulhões**