Key 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 audiences through dashboards, written summaries, and presentations
Operational Excellence & Partnership
- 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
Required Skills & Competencies
- 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
Qualifications
- 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
- Preferred: experience with Python or AI-enabled automation tools