Data Analyst

Smart IMS • Plano, TX

14d • Onsite

About The Position

This role focuses on Data Architecture, Sales Data Model management, Data Pipeline Development & Automation, Business Intelligence & Reporting, Reference & Master Data Governance, Commercial Analytics, and Operational Excellence & Partnership. The Data Analyst will oversee the performance and reliability of the division's sales data model, validate model outputs, and enhance data structures for scalability. They will design, deploy, and support automated ETL pipelines, monitor jobs, and adapt logic for business changes. The role also involves leading the development of Tableau dashboards, administering the reporting environment, and ensuring data accuracy. Maintaining sales hierarchy and product reference tables, enforcing classification logic, and evaluating sales performance to identify trends and opportunities are key. The analyst will also map workflows, serve as a liaison between departments, and reconcile sales data with financial records.

Requirements

• Bachelor's degree in business administration, Information Systems, Data Analytics, or a related discipline
• Minimum of 4 years of experience in sales operations, business intelligence, or data analytics, preferably within 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 managing hierarchies and reference data within a sales operations setting
• Working knowledge of CRM (e.g., Salesforce), BI (e.g., Power BI), and ERP platforms
• Strong communication skills, with the ability to explain technical concepts to non-technical stakeholders
• Meticulous attention to detail and the ability to manage multiple priorities independently

Nice To Haves

• Experience with Python or AI-enabled automation tools

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.

Benefits

• The hourly range for roles of this nature are $40.00 to $80.00/hr. Rates are heavily dependent on skills, experience, location, and industry.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level