Role: Supply Chain Business Analyst
Department: Operations / Supply Chain
Reports To: Chief Operating Officer
Travel: Occasional (up to 10%)
Systems & Tool Environment
The Analyst will operate within the following technology environment. Familiarity with any subset is an advantage; full proficiency will be developed on the job.
ERP: Microsoft Business Central (on-premises v22 transitioning to SaaS v28)
Supply Chain Planning: Kinaxis Maestro
Trade Promotion Management: UpClear BluePlanner
Integration: Boomi (iPaaS)
BI / Analytics: Microsoft Power BI, Microsoft Fabric
Cloud Platform: Microsoft Azure (ADF, Synapse, ADLS Gen2, Azure SQL)
Productivity: Microsoft 365 (Teams, SharePoint, Excel, Outlook)
Identity & Access: Microsoft Entra ID, Intune
AI / LLM: Claude (Anthropic) — primary; Microsoft Copilot (M365); ChatGPT
Required Qualifications
Education & Experience
Bachelor's degree in Supply Chain Management, Data Analytics, Business, Information Systems, or a related field.
3–6 years of experience in a supply chain analytics, business analyst, or data analyst role within a CPG, FMCG, or consumer products environment.
Demonstrated experience supporting at least two supply chain functions (e.g., demand/supply planning, procurement, logistics, or warehousing) in an analytical capacity.
Technical Skills — Required
Microsoft Power BI: Advanced proficiency in report and dashboard development, DAX, Power Query (M), data modeling, and workspace/gateway management.
Microsoft Azure: Hands-on experience with one or more of the following—Azure Data Factory, Azure Synapse Analytics, Azure SQL Database, Azure Data Lake Storage Gen2, or Azure Databricks.
SQL: Proficient in writing complex queries, joins, aggregations, and window functions for data extraction and transformation.
Data warehousing concepts: Working knowledge of dimensional modeling, ETL/ELT patterns, and enterprise data warehouse architecture.
Microsoft 365: Proficient in Excel (Power Query, pivot tables, advanced formulas) and Teams/SharePoint for collaboration and documentation.
Domain Knowledge — Required
Deep understanding of CPG supply chain operations including demand and supply planning, S&OP/IBP processes, procurement, inventory management, logistics and transportation, and warehouse operations.
Familiarity with supply chain master data concepts: item hierarchies, customer/vendor master, UOM, lead times, safety stock parameters, and BOM structures.
Experience translating supply chain business processes into data requirements and analytical frameworks.
AI & LLM Tools
Active working knowledge of at least one enterprise LLM tool (Claude, ChatGPT, or Microsoft Copilot) as applied to professional analytical workflows.
Ability to construct effective prompts for data interpretation, summarization, documentation drafting, and exception narrative generation.
Awareness of responsible AI use, including data privacy considerations when working with enterprise and supplier data.

Supply Chain Business Analyst

Similar Analytics Jobs

Quality Assurance Analyst

Apprentice Business Analyst

Cyber Security Analyst II (Developer)

Program Support Analyst

Sr. ServiceNow Business Analyst

Senior Business Systems Analyst - Remote