JOBSEARCHER

Data Analyst 2

Job Description
Pay rate range: $43/hr. to $46/hr.
Schedule: Fully onsite
Job Description: Top skills: Advanced experience building and maintaining ETL workflows in Alteryx or a similar platformProficiency in SQL, including writing complex queries against large datasetsDemonstrated Tableau expertise spanning dashboard design, data source management, and governanceKEY 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 platformProficiency in SQL, including writing complex queries against large datasetsDemonstrated 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