Supply Chain Business Analyst

SMART TECH SKILLS LLC

3d•Remote

About The Position

The Supply Chain Business Analyst serves as the primary analytics partner for Supply Chain, Procurement, Logistics, and Warehousing operations within a fast-growing consumer products organization. This role sits at the intersection of business operations and technology, translating complex operational requirements into scalable data and analytics solutions. The ideal candidate will remain hands-on with Power BI, SQL, and cloud platforms while utilizing AI tools to accelerate business decision-making. This is a 3 to 6-month contract position.

Requirements

3 or more years of experience as a Business Analyst, Supply Chain Analyst, or Data Analyst.
3 or more years of experience in a Consumer Packaged Goods (CPG), FMCG, or consumer products environment.
Demonstrated experience supporting multiple supply chain functions, including demand/supply planning, procurement, logistics, or warehousing.
Advanced proficiency with Microsoft Power BI, including Power Query (M), DAX, semantic modeling, and dashboard development.
Hands-on experience working with one or more Microsoft Azure data platforms (such as Azure Data Factory, Azure Synapse Analytics, Azure SQL Database, Azure Data Lake, or Microsoft Fabric).
Advanced SQL skills for data extraction, transformation, joins, aggregations, and dimensional modeling.
Active working knowledge of prompt engineering and utilizing at least one enterprise LLM tool (e.g., Claude, ChatGPT, or Microsoft Copilot) within professional analytical workflows.
Strong skills in Microsoft 365, with advanced Excel proficiency (Power Query, Pivot Tables, formulas).
Bachelor’s degree in Supply Chain Management, Data Analytics, Business, Information Systems, or a related field.
Excellent analytical, problem-solving, and diagnostic abilities to maintain high data accuracy.
Strong business partnering and stakeholder management skills to bridge functional business units and technical teams.
Outstanding written and verbal communication skills with the ability to summarize complex data into clear operational narratives.
High attention to detail with a self-motivated approach to working independently in a fully remote environment.

Nice To Haves

Hands-on experience with Microsoft Fabric and the evolution of Azure analytics.
Experience using Microsoft Business Central ERP or similar mid-market ERP platforms.
Experience with Kinaxis Maestro or similar Advanced Planning and Scheduling (APS) systems.
Familiarity with Trade Promotion Management (TPM) tools or data (e.g., UpClear BluePlanner).
Exposure to integration middleware (e.g., Boomi, Azure Logic Apps) and API-based data flows.
Proficiency in Python (specifically Pandas and NumPy) for data manipulation and analytics automation.
Professional certifications such as Microsoft Power BI (PL-300) or Azure Data Engineer Associate (DP-203).
Experience supporting private equity-backed, high-growth, or M&A-active CPG organizations.

Responsibilities

Design, develop, and maintain robust Power BI dashboards supporting Demand Planning, Supply Planning, Procurement, S&OP, Logistics, and Warehousing.
Develop standardized executive reports and KPI dashboards tracking critical operational metrics such as Forecast Accuracy, OTIF (On-Time In-Full), Inventory Turns, Fill Rate, PPV, and Carrier performance.
Gather, document, and translate business requirements from Supply Chain stakeholders into Business Requirements Documents (BRDs), functional specifications, user stories, and UAT test plans.
Act as the primary liaison between Operations and IT/Data Engineering teams to define source-to-target mappings, data transformation logic, and ETL/ELT requirements.
Perform SQL-based data analysis and assist in designing dimensional models supporting Azure-based enterprise analytics.
Monitor and validate data quality across ERP, planning, and operational systems, identifying anomalies and establishing automated exception reporting.
Maintain comprehensive data dictionaries, business glossaries, and metadata documentation to support enterprise data governance.
Leverage generative AI and Large Language Model (LLM) tools such as Claude, ChatGPT, and Microsoft Copilot to optimize analytical workflows, compile report narratives, and draft operational documentation.