Business Intelligence Analyst

Analyze and interpret multi-platform e-commerce data from Amazon, Shopify, and TikTok Shop to identify sales trends, customer behaviors, and product performance across different markets and channels.

Develop predictive models using Python and SQL to forecast demand by product, season, and category, aiding inventory planning and revenue forecasting.

Utilize regression analysis, time-series forecasting, and trend decomposition to support strategic pricing and merchandising decisions.

Design and maintain interactive dashboards and real-time KPI monitors in Power BI and Tableau to track sales metrics, conversion rates, profit margins, and fulfillment efficiency.

Collaborate with supply chain, finance, and marketing teams to translate data insights into actionable business strategies.

2.

Digital Marketing and Customer Behavior Analysis (25%) Conduct customer segmentation, cohort analysis, and behavioral profiling using transactional data and CRM exports to identify target audiences and optimize outreach strategies.

Monitor key performance indicators for digital ad campaignssuch as CTR, CPA, ROAS, bounce rates, and engagement levelsacross platforms including TikTok Ads Manager and Facebook Ads Manager.

Apply attribution modeling to understand the impact of multi-channel marketing efforts and customer journey touchpoints.

Design and execute A/B tests to evaluate the effectiveness of different promotional strategies, ad creatives, and conversion funnels.

Generate weekly and monthly marketing performance reports with recommendations to enhance targeting, reduce cost-per-acquisition, and increase customer lifetime value.

3.

Supply Chain and Inventory Optimization (20%): Partner with production and logistics teams to analyze supply chain data from manufacturing sites in China and Cambodia, ensuring alignment between inventory levels and demand forecasts.

Track SKU-level turnover rates, identify stock imbalances, and build forecasting models using Python and SQL to optimize restocking schedules and warehouse allocations.

Utilize ETL processes and data warehousing techniques to clean, integrate, and manage large datasets for improved demand planning and fulfillment accuracy.

Develop Power BI and Tableau dashboards to monitor inventory KPIs, supplier lead times, and warehouse performance, enabling fast, data-informed decisions across operations.

4.

Project Management and Internal Collaboration (10%) Lead cross-functional analytics initiatives involving sales, marketing, and inventory management teams to align strategic objectives.

Develop data pipelines and ensure consistent data quality for key reports used by executive management and retail partners.

Track project timelines, identify potential bottlenecks, and implement solutions to maintain data deliverables on schedule.

5.

Compliance Reporting and Executive Decision Support (10%) Generate periodic reports and presentations for executives and licensing partners (e.g., Wrangler, MLB) to support decision-making.

Monitor compliance with digital platform policies and e-commerce data protection standards.

Participate in audit preparation and ensure data accuracy in tax and financial filings related to e-commerce transactions.

These duties demand a high level of specialization and expertise in data analytics, strategic decision support, project management, and compliance.

The Business Intelligence Analyst will employ specific methodologies and advanced analytical techniques to perform these tasks effectively, ensuring the smooth operation and strategic advancement of our company's practices.

This role is crucial for transforming complex data sets into actionable insights that drive business optimization and client engagement, reinforcing our commitment to innovative and effective solutions.

Skill Requirements: 1.

Technical Skills: Proficiency in data modeling and visualization using Power BI, Tableau, and SQL.

Advanced Python skills for data analysis, automation, and statistical modeling.

Experience with e-commerce analytics tools such as Shopify Analytics, Amazon Seller Central, and TikTok Shop backend.

Strong understanding of data warehousing (ETL) processes and cloud-based data storage.

2.

Marketing and E-commerce Insight: Knowledge of digital marketing KPIs and tools, including ad tracking, engagement metrics, and campaign attribution.

Familiarity with customer journey mapping, sales funnel optimization, and cohort analysis.

3.

Project Management: Experience using Asana, Trello, or Basecamp to manage analytics projects and cross-departmental reporting workflows.

Ability to coordinate deliverables across marketing, sales, and supply chain teams.

4.

Communication and Presentation: Excellent written and verbal communication skills to present data-driven recommendations clearly.

Ability to prepare visual reports and lead discussions with executives and external stakeholders.

Tools Needed: 1 Data Analysis and Visualization Tools: Power BI: Utilized for creating advanced interactive data visualizations and business intelligence reports, allowing for real-time data analysis.

SQL: Essential for managing and manipulating data within relational databases, performing complex queries and data manipulation.

Tableau: Highly effective for creating complex visualizations and integrating with various data sources for in-depth analytics.

Python: Widely used for data manipulation, machine learning, and automation within data analysis workflows.

2.

E-commerce and Marketing Analytics: Amazon Seller Central: For managing product listings, tracking sales performance, and analyzing customer feedback on Amazon.

Shopify Analytics: Provides insights into online store traffic, sales trends, and customer behaviors.

TikTok Ads Manager: Used for planning, executing, and tracking advertising campaigns on TikTok.

Facebook Ads Manager: For creating and monitoring ad campaigns on Facebook and Instagram, with detailed performance metrics.

Google Analytics: Helps in understanding website traffic sources, user engagement, and conversion rates.

3 Project Management Software: Basecamp: Offers a visual way to manage projects and tasks, popular for its simplicity and effectiveness in collaborative settings.

Trello: A flexible, card-based project management tool used for organizing tasks and workflows.

Asana: Enables detailed project tracking, task assignments, and deadline management across teams.

4.

Communication and Collaboration Tools: Slack: For instant messaging and integration with many other productivity and management tools, enhancing team communication.

Microsoft Teams: Supports team collaboration, video conferencing, file sharing, and integration with Microsoft Office products.

Zoom: Offers reliable video conferencing for meetings, webinars, and group collaborations with external stakeholders.

Bachelor degree in Business Analytics or related.