Data Analyst 2

Pay rate range - $43/hr. to $46/hr.
Schedule: Fully onsite

Job Description:

Top skills:
1. Advanced experience building and maintaining ETL workflows in Alteryx or a similar platform
2. Proficiency in SQL, including writing complex queries against large datasets
3. Demonstrated Tableau expertise spanning dashboard design, data source management, and governance

KEY RESPONSIBILITES/REQUIREMENTS:

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