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