Data Analyst 2

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

Preferred

• experience with Python or AI-enabled automation tools
• Glassdoor
• 4.0
• "Intelliswift, an LTTS Company, delivers world-class Digital Product Engineering, Data Management, Analytics & AI, and Digital Ent Solutions It is a sub-organization of L&T Technology Services.
• Santa Clara, California, USA
• https://www.intelliswift.com
• H1B Sponsorship
• Data Powered by
• Distribution of Different Job Fields Receiving Sponsorship
• Represents job field similar to this job
• Engineering and Development
• Management and Executive
• Product Management
• Sales
• Human Resources
• Customer Service and Support
• Trends of Total Sponsorships
• *2026
• (13)

Qualifications

• 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
• 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
• Experience with Python or AI-enabled automation tools

Required skills

• Alteryx, SQL, Tableau, Dimensional Modeling, OLAP, Sales Hierarchy and Reference Data Management, Sales Operations, Salesforce, Power BI, Python

Preferred skills

• experience with Python or AI-enabled automation tools, Glassdoor, 4.0, Santa Clara, California, USA, https://www.intelliswift.com, H1B Sponsorship, Data Powered by, Distribution of Different Job Fields Receiving Sponsorship, 81, Represents job field similar to this job, Engineering and Development, Management and Executive, Product Management, Sales, Human Resources, Customer Service and Support, Trends of Total Sponsorships, *2026, (13), 2025, (28), 2024, (35), 2023, (44), 2022, (27), 2021, (38), 2020

Experience

• 4+ years