Business Analyst

Job Description

Job Description

This role primarily supports Brand Execution and Retail Operations reporting. Key responsibilities include, but are not limited to:

• Workflow Audit & Documentation : Audit and document the current library of Alteryx workflows, including macros, joins, formulas, data blending logic, and scheduled outputs that support Brand Execution and Retail Operations reporting.
• KNIME Migration & Validation : Rebuild and validate equivalent (or improved) logic in KNIME Analytics Platform, ensuring output parity with existing Alteryx-generated reports before cutover.
• AI-Enabled Reporting Solution : Design and build an AI-assisted internal reporting/dashboard solution (leveraging KNIME's AI extensions and/or other generative AI tools) to display migrated workflow output for internal stakeholders only — no external or customer-facing data exposure.
• Stakeholder Partnership & Sign-Off : Partner with the Business Process Manager and business stakeholders (channel managers, program managers) to confirm requirements, test outputs, and obtain sign-off on migrated workflows.
• Documentation & Knowledge Assets: Produce clear documentation: a workflow inventory, a migration runbook, a KNIME workflow style guide, and a summary of the AI reporting solution's architecture and data sources.
• QA & Issue Resolution: Perform QA and troubleshoot data discrepancies between legacy Alteryx outputs and new KNIME outputs, escalating and resolving issues quickly given the fixed project timeline.
• Knowledge Transfer & Training: Deliver a knowledge-transfer session to the internal team covering how to maintain, extend, and troubleshoot the new KNIME workflows and AI reporting tool after the engagement ends.

Required Qualifications

• 3+ years of hands-on experience building and maintaining workflows in Alteryx Designer (data blending, macros, spatial and predictive tools).
• Demonstrated hands-on experience with KNIME Analytics Platform; prior experience migrating workflows from another ETL/analytics tool into KNIME strongly preferred.
• Practical experience using AI/LLM tools (e.g., Claude, Gemini, or similar) to build, accelerate, or automate reporting and data solutions.
• Strong SQL skills and general ETL/data-blending proficiency.
• Familiarity with Tableau or comparable BI/visualization tools, and an understanding of how to translate existing dashboards into a new platform.
• Ability to work independently, manage priorities, and deliver production-ready results within an aggressive, fixed 60-day timeline.
• Excellent written documentation and stakeholder communication skills; comfortable presenting technical work to non-technical audiences.

Nice-to-Have Skills

• Experience supporting retail operations, merchandising, or facility maintenance reporting (Brand Execution, fixture installs, compliance, or R&M reporting a plus).
• Background in business process management or process improvement.
• Experience deploying AI tooling in a data-governance-aware, internal-only environment.
• Bachelor's degree in Business, Data Analytics, Information Systems, or a related field, or equivalent practical experience.

Key Technologies & Tools

• Data Preparation & ETL: Alteryx Designer, KNIME Analytics Platform, SQL
• Visualization & Reporting: Tableau, KNIME dashboard/reporting extensions
• AI & Automation: Claude, Gemini, KNIME AI extensions, or comparable generative AI tools
• Collaboration & Communication: Microsoft 365 (Teams, SharePoint, Outlook)