Data Analyst: Alteryx, Tableau & Advanced Excel Expert

LanceSoft, Inc.; Plano (TX); On-site; USD 65,000 - 90,000; Full time

Job summary

LanceSoft, Inc. is seeking a detail-oriented Data Analyst to transform raw data into structured datasets, build ETL workflows in Alteryx, and deliver Tableau dashboards that drive business decisions.

This role requires hands-on experience with Advanced Excel and SQL, and will work closely with sales teams to validate POS data on-site in Plano, TX. You will translate business requirements into robust data processing and visualization solutions, perform data quality checks, and support AI-driven

Qualifications

• Bachelor’s degree in a relevant field.
• Minimum of 4 years of relevant professional experience.
• Hands-on experience with Alteryx, including building and maintaining ETL workflows.
• Advanced Excel proficiency, particularly Power Query and macros.
• Hands-on experience developing dashboards and reports using Tableau.
• Foundational SQL knowledge for data extraction and analysis.
• Strong analytical, logical thinking, and problem-solving skills.
• Excellent communication and collaboration skills.
• Ability to work fully on-site in Plano, TX.

Responsibilities

• Build, maintain, and optimize ETL workflows using Alteryx to process and transform raw data.
• Use Advanced Excel features, including Power Query and macros, to clean, manipulate, and format datasets.
• Develop and maintain Tableau dashboards and visualizations to communicate business insights.
• Use SQL for data extraction, validation, and analysis.
• Collaborate with internal and external sales teams and vendors to validate POS data and resolve discrepancies.
• Support the development of AI-driven reporting and dashboard solutions using emerging AI tools.
• Perform data quality checks, troubleshoot workflow issues, and identify opportunities to improve reporting efficiency.
• Translate business requirements into effective data processing and visualization solutions.

Skills

Data analysis

ETL development

Dashboard development

SQL knowledge

Collaboration

Education

Bachelor's degree in a relevant field

Tools

Alteryx

Tableau

Power Query

Macros

SQL

Job description

LanceSoft, Inc. is seeking a detail-oriented Data Analyst to transform raw data into structured datasets, build ETL workflows in Alteryx, and deliver Tableau dashboards that drive business decisions.

This role requires hands-on experience with Advanced Excel and SQL, and will work closely with sales teams to validate POS data on-site in Plano, TX. You will translate business requirements into robust data processing and visualization solutions, perform data quality checks, and support AI-driven