On-Site Data Analyst: Alteryx, SQL & Tableau

Advantage Technical; Plano (TX); On-site; USD 52,000 - 75,000; Full time

Benefits offered by this job

Medical

Dental

Vision

401k

Paid Time Off

Job summary

Staffmark Total Talent Solutions is seeking a Data Analyst for an on-site role in Plano, TX, Monday through Friday 8:00 AM to 5:00 PM, with a pay rate of $46.15 per hour. The position emphasizes ETL, SQL, and Tableau dashboards to support sales operations.

You will oversee OLAP-based sales data models, validate outputs, and design automated ETL pipelines using Alteryx or similar tools. The role requires strong communication with Sales, Finance, and executive leadership and a focus on data

Qualifications

• Bachelor’s degree in Business Administration, Information Systems, Data Analytics, or a related discipline.
• 4+ years of experience in sales operations, BI, or data analytics in a B2B environment.
• Advanced experience building and maintaining ETL workflows in Alteryx or a similar platform.
• Proficiency in SQL, including writing complex queries against large datasets.
• Demonstrated Tableau expertise spanning dashboard design, data source management, and governance.
• Solid understanding of dimensional modeling and OLAP/cube concepts.
• Experience with CRM (e.g., Salesforce), BI (e.g., Power BI), and ERP platforms.

Responsibilities

• Oversee the performance, reliability, and scheduled refresh of the division’s OLAP-based sales data model.
• Validate model outputs through structured quality checks; diagnose and remediate discrepancies, missing records, or load failures.
• Assess existing data structures for inefficiencies and propose enhancements that improve scalability and query performance.
• Design, deploy, and support automated ETL pipelines using Alteryx or comparable tools.
• Proactively monitor scheduled jobs, triage failures, and restore data flows with minimal business disruption.
• Adapt pipeline logic in response to territory changes, account restructuring, and product portfolio updates.
• Conduct periodic health reviews of pipelines, retiring outdated inputs and correcting logic inconsistencies.
• Lead the development of Tableau dashboards from initial stakeholder discovery through deployment and user training.
• Administer the reporting environment, ensuring data sources, extracts, and refresh schedules operate as intended.
• Evaluate the reporting portfolio on a recurring basis to confirm metric definitions remain accurate and current.
• Streamline the report catalog by sunsetting low-usage content and merging redundant views.
• Maintain sales hierarchy and product reference tables, reflecting personnel movements, territory adjustments, product launches, and end-of-life items.
• Administer product-to-material relationships within the ERP environment and resolve data quality exceptions.
• Enforce consistent classification logic across all dependent systems and reports.
• Evaluate sales performance to identify trends, variances, and growth opportunities, translating results into concise recommendations.
• Deliver timely, well-structured analysis in response to requests from Sales, Finance, and executive leadership.
• Communicate findings to senior audiences through dashboards, written summaries, and presentations.
• Map existing workflows, pinpoint inefficiencies, and recommend practical, well-documented improvements.
• Serve as a liaison among Sales Operations, Finance, IT, and external vendors to resolve data issues and integrate new data sources.
• Assist with periodic reconciliation of sales data against financial records to ensure alignment.

Skills

Alteryx

SQL

Tableau

Education

Bachelor’s degree in Business Administration, Information Systems, Data Analytics, or a related discipline

Tools

Alteryx

SQL

Tableau

Job description

Staffmark Total Talent Solutions is seeking a Data Analyst for an on-site role in Plano, TX, Monday through Friday 8:00 AM to 5:00 PM, with a pay rate of $46.15 per hour. The position emphasizes ETL, SQL, and Tableau dashboards to support sales operations.

You will oversee OLAP-based sales data models, validate outputs, and design automated ETL pipelines using Alteryx or similar tools. The role requires strong communication with Sales, Finance, and executive leadership and a focus on data