KNIME Data & Analytics Engineer

Ektello; Plano (TX); On-site; USD 55,000 - 63,000; Full time

Job summary

Ektello is seeking a KNIME Data & Analytics Engineer for an onsite Plano, TX engagement. The role focuses on migrating workflows from Alteryx to KNIME, validating outputs, and delivering an AI-assisted internal reporting tool within a tight 60-day window.

You will audit current analytics assets, build migration runbooks, and train the internal team to sustain KNIME workflows and dashboards using KNIME AI extensions, Claude, or Gemini, ensuring parity with legacy outputs.

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.

Responsibilities

• Audit and document the current Alteryx workflow library, including macros and data blending logic.
• Rebuild and validate equivalent logic in KNIME, ensuring parity with legacy outputs.
• Design and build an AI-assisted internal reporting/dashboard solution using KNIME AI extensions and other tools.
• Collaborate with stakeholders to confirm requirements, test outputs, and obtain sign-off on migrations.
• Produce documentation: workflow inventory, migration runbook, KNIME style guide, and architecture summary.
• Perform QA and resolve discrepancies between legacy and KNIME outputs within project timelines.
• Deliver a knowledge-transfer session to the internal team on maintaining KNIME workflows and the AI reporting tool.

Skills

Workflow development

Documentation

Stakeholder communication

Independent work

Problem solving

Education

Bachelor's degree in Business, Data Analytics, Information Systems, or a related field

Tools

Alteryx Designer

KNIME Analytics Platform

SQL

Tableau

KNIME AI extensions

Claude

Gemini

Tableau extensions

Microsoft 365

Job description

KNIME Data & Analytics Engineer

W2 contract, min of 2 months. ONSITE out of Plano, TX. W2 $42/hr

KEY RESPONSIBILITIES

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

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)

QUALIFICATIONS & SKILLS

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