Business Intelligence Analyst - Sales Operations.

Ektello; Plano (TX); On-site; USD 55,000 - 63,000; Part time

Job summary

Ektello is seeking a Business Intelligence Analyst – Sales Operations for an onsite W2 contract in Plano, TX (min 6 months). The role focuses on data architecture, ETL, and BI development to support Sales Operations.

You will build and maintain ETL pipelines, develop Tableau dashboards, govern data sources, and partner with Sales, Finance, IT and vendors to ensure data quality and timely insights.

Qualifications

• 4+ years in sales operations, BI, or data analytics in a B2B environment.
• Experience with Python or AI-enabled automation tools.
• Advanced ETL experience with Alteryx or similar platform.
• SQL proficiency with complex queries on large datasets.
• Tableau expertise for dashboards, data sources, governance.

Responsibilities

• Oversee OLAP sales data model performance, reliability, and refreshSchedule.
• Validate model outputs with quality checks and diagnose issues.
• Assess data structures for efficiency and propose scalability improvements.
• Design, deploy, and support automated ETL pipelines using Alteryx or comparable tools.
• Monitor jobs, triage failures, and restore data flows with minimal disruption.
• Develop Tableau dashboards from discovery to deployment and training.
• Govern sales hierarchies and product reference data within ERP systems.
• Collaborate with Sales Ops, Finance, IT and external vendors to resolve data issues.

Skills

ETL workflows

SQL

Tableau

Education

Bachelor's degree

Tools

Alteryx

Python

Job description

Business Intelligence Analyst – Sales Operations W2 contract, min of 6 months ONSITE out of Plano, TX Target W2 $40-46/hr

Top Skills

• 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

What you’ll be doing

• 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

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
• 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