Business Intelligence Analyst – Sales Operations.

W2 contract, minimum 6 months. Onsite in Plano, TX. Target rate: $40–46/hr (W2).

Responsibilities

• Data Architecture & Sales Data Model
  • 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
• Data Pipeline Development & Automation
  • 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
• Business Intelligence & Reporting
  • 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
• Reference & Master Data Governance
  • 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
• Commercial Analytics
  • 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