Sr. BI Analyst

Position Summary

The Business Intelligence Coordinator will be responsible for analyzing and providing strategic insights to support decision-making within the Distributor Cluster including Puerto Rico.

• Key relationships internally will include Sales, Marketing, Finance, Supply, HR and Distributor contacts.
• Supports business reviews and provides analysis upon request.
• Participates in forecasting, pricing, incentives and reporting processes.

Universal Accountabilities                                     

• Behave in a manner that aligns with The Company’s business goals, objectives, values and code of conduct
• Understand and operate in accordance with Company policies and procedures
• Reporting & Analysis: Develop and maintain regular ad-hoc reports on key performance indicators (KPIs) such as sales, inventory, and customer metrics.
• Strategic Decision Support: Provide strategic analysis and recommendations to support decision-making
  • Business Insights: Provide actionable insights to support strategic decision-making, such as market expansion, product offerings, sales strategies or business trends
• Cross-Functional Collaboration: Act as a liaison between business units (sales, mkt, finance, etc.) to ensure their data needs are met.
• Optimization Recommendations: Identify and develop opportunities to improve process and system efficiency and effectiveness, based on BI insights to drive performance improvement.
• Continuous Improvement and Innovation: Stay up-to-date with industry trends and emerging technologies in business intelligence

Specific Accountabilities

• Data Management and Integration: Gather and consolidate data from various sources (sales, inventory, financial systems, etc.) across the distributor cluster to ensure all relevant information is centralized. (e.g. Sell In with all necessary details: Vol, NIS, DFF, NCS; and integrate Sell Out of Strategic markets/Accounts).
• BI Tool Management. Coordinate with relevant teams to manage the setup, configuration, and ongoing maintenance of BI tools (such as Power BI, Tableau, or other analytics platforms)
• Data Visualization and Dashboards: Create and maintain interactive dashboards for different stakeholders within the distributor cluster, including senior management, sales teams, and operational staff. Present data in a visually appealing and easily understandable format to help decision-makers quickly grasp key insights.
• Training and Support: Provide training to internal teams on how to interpret BI reports and use BI tools effectively
• Forecasting: Work on forecasting models that help predict future trends in sales, inventory, or market demand based on historical data.
  • Actively participate in EBP focus on commercial meetings and provide inputs in other key meetings like: Monthly Locks (FAST) and full ownership in the SLOBs process
• Pricing Process: Supporting Cluster Pricing analysis and Price setup
• Incentives: Management of incentive programs for sales forces and merchandisers, including calculation and payment

Required Skills and Experience

• Market Analysis and Strategic Thinking: Ability to assess market trends, key players, consumer behaviors, identify opportunities, and develop data-driven strategies
• Financial Acumen: Ability to evaluate the financial viability of business opportunities.
• Problem Solving and Innovation: Ability to think creatively to overcome challenges and propose innovative solutions
• Educational Background: Bachelor’s degree in business administration, Economics, Statistics, or related field
• Proven Track Record: Minimum 2 years of experience in business intelligence or data analysis
• Industry Knowledge: Experience in industries relevant to the Company (FMCG / Personal Care).
• Advanced knowledge of data analysis tools such as Excel, SQL, Tableau, Power BI, etc.
• Effective communication and presentation skills
• Cultural adaptability: Ability to work in a dynamic environment and adapt to changing priorities
• Leadership and Collaboration: Experience working in cross-functional and multicultural teams. Ability to lead regional initiatives and influence stakeholders at all levels.
• Language Proficiency: Fluency in English and Spanish (written and spoken)
• Preferences/Optional: Knowledge of customer relationship management (CRM) tools, Certification in business intelligence or data analysis

Working Relationships

• Reports directly to LATAM Distributor Cluster Director
• Key relationships internally will include Sales, HR, MKT, Supply and Finance

Work Environment

• Ability to lead processes / projects virtually
• Understanding of multicultural differences across the markets in the region being respectful and careful with the way of communicating and interacting with the local teams and with Corporate
• The position will be based in the Edgewell COL City offices
• Work schedule: Hybrid Model 3 times at office from 8:00am – 5:00PM

LI-INT