Business Analyst 2

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. • 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.

Pay rate range - $40/hr. to $42/hr.
Schedule: Fully onsite

Job Description:

Top skills:
-Process Improvement
-Artificial Intelligence
-Backend Development

KEY RESPONSIBILITES/REQUIREMENTS:

KEY RESPONSIBILITIES
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.

QUALIFICATIONS & SKILLS

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)