Business Intelligence Analyst
- Information Technology
- Full time
- Trinidad and Tobago
- 3 hour(s) ago
- Undisclosed
Job Summary:
This is a senior individual contributor role with team leadership responsibilities. The
Lead BI Analyst is the primary owner of commercial analytics at SMJ — responsible for data visualisation, commercial data management, and demand forecasting that directly inform sales strategy, distribution planning, and territory performance decisions. The successful candidate will translate complex commercial data into clear, decision-ready insights for senior leadership and cross-functional stakeholders across the Caribbean.
Key Responsibilities:
• Design, develop, and maintain Power BI dashboards and reports that deliver actionable commercial and operational insights to business units and senior
leadership across SMJ's Caribbean territories.
• Own the delivery of the monthly director-level commercial performance report, including sales by brand, customer, and channel; trend analysis; and territory level KPI tracking.
• Build and maintain executive dashboards that consolidate group-wide commercial and financial data into concise, visually compelling narratives for senior stakeholders.
• Establish and enforce data visualisation standards across the BI team, ensuring consistency, accuracy, and usability of all published reports.
• Continuously refine dashboard design based on stakeholder feedback; proactively identify gaps in current reporting coverage and propose solutions.Serve as the primary custodian of commercial data — including sales, customer, pricing, and distribution data — ensuring integrity, consistency, and accessibility across source systems and the data warehouse.
• Design and maintain commercial data models in Power BI and dbt Core that support accurate aggregation across brands, pack formats, customers, channels, and territories.
• Develop and maintain Business Activity Queries (BAQs) in Epicor Kinetics to extract and stage commercial data for pipeline ingestion and ad hoc analysis.
• Partner with Commercial, Sales, and Finance teams to define and standardise commercial KPIs, hierarchies, and reporting dimensions; document agreed definitions in the data dictionary.
• Identify and resolve data quality issues in commercial datasets; implement automated validation checks to reduce manual reconciliation effort.
• Support the implementation of SMJ's data governance framework as it applies to commercial data; maintain lineage documentation for all key commercial metrics.
• Lead the development and maintenance of SMJ's demand forecasting models,
integrating historical sales data, promotional calendars, seasonality patterns, and market intelligence.
• Produce and publish rolling demand forecasts by brand, SKU, territory, and channel; clearly communicate forecast assumptions, confidence intervals, and revision rationale to commercial stakeholders.
• Conduct variance analysis between forecast and actuals; identify root causes of forecast error and implement model improvements on an ongoing basis.
• Develop scenario and sensitivity analyses to support commercial planning decisions, including new product launches, promotional uplift estimation, and territory expansion modelling.
• Collaborate with Supply Chain and Production teams to ensure demand forecasts are integrated into operational planning cycles.
• Monitor market-level performance indicators across SMJ's Caribbean territories; surface emerging trends or distribution anomalies that require commercial response.
• Provide day-to-day technical guidance and mentorship to junior BI team members; review deliverables and support skills development in visualisation and commercial analytics.
• Manage assigned workstreams through SMJ's BI intake and delivery process, maintaining accountability to agreed timelines and acceptance criteria.
• Contribute to the BI team's stand-up and sprint ceremonies; maintain task visibility in Azure DevOps.
• Stay current on emerging BI and analytics technologies; recommend tools and approaches that strengthen SMJ's commercial intelligence capability.
Qualifications & Experience
• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Science, Statistics, Business Administration or a related field.
• Minimum four (4) years of experience in business intelligence, commercial analytics or a related field with demonstrated progression in technical responsibility.
• Proven experience delivering Power BI solutions — including data modelling, DAX development, and executive dashboard design — in a commercial, FMCG, or retail environment.
• Demonstrated experience building and maintaining demand forecasting models in a commercial or supply chain context; familiarity with time-series forecasting methods is required.
• Strong hands-on experience with SQL for commercial data extraction, transformation, and analysis across relational database platforms.
• Experience managing commercial master data — including customer, product, and pricing hierarchies — in an ERP or data warehouse environment.
• Familiarity with Epicor Kinetics or similar ERP systems for commercial data extraction is a significant advantage.
• Experience with dbt Core or equivalent transformation frameworks is preferred.
• Python proficiency (pandas, statsmodels, or equivalent forecasting libraries) is an asset.