Lead Data Analyst

Role Overview

• Gather, cleanse, validate, transform, and organize compensation, incentive, sales performance, payout, and operational data from multiple sources.
• Analyze data to identify trends, risks, gaps, opportunities, and actionable insights related to compensation effectiveness, seller attainment, payouts, productivity, incentive performance, and business outcomes.
• Evaluate whether compensation plans are driving intended seller behaviors, business priorities, performance outcomes, and growth objectives.
• Support reporting and measurement for strategic incentives, SPIFFs, accelerators, and special compensation programs, including participation, attainment, payout impact, business lift, and program effectiveness.
• Develop leadership dashboards, scorecards, business reviews, executive summaries, and senior leadership presentations that translate complex analysis into clear insights, decision points, and recommended actions.
• Identify, investigate, resolve, and document data discrepancies across source systems, dashboards, trackers, payout files, and reporting outputs.
• Support initiatives focused on automation, governance, process improvement, scalable analytics, standardized reporting, intake processes, and improved operating rhythms.
• Design, prototype, or support agentic solutions using frameworks and platforms such as LangChain, LangGraph, CrewAI, Microsoft AutoGen, Semantic Kernel, OpenAI API, Azure OpenAI, Microsoft Copilot Studio, Power Automate, Power Apps, and Python-based orchestration.
• Build or support AI-enabled workflows using retrieval-augmented generation, embeddings, semantic search, document retrieval, vector databases, prompts, tool calls, API integrations, validation checks, and human-in-the-loop controls.
• Identify and develop practical use cases such as incentive intake triage, compensation rule interpretation, tracker generation, SQL/query assistance, anomaly detection, payout validation, recurring report creation, executive summary generation, action-item tracking, meeting preparation, and senior leadership briefing support.
• Lead or support cross-functional projects by managing timelines, deliverables, risks, dependencies, stakeholder follow-ups, documentation, and status updates while partnering with Compensation, Sales, Finance, Operations, Compliance, Technology, HR, incentive design, enablement, auditing, and payout teams.
• Use SQL, Python, Power BI, Excel, Tableau, Snowflake, Salesforce, Varicent, and related tools to analyze data, automate processes, validate results, and deliver business insights.
• Analyze sales planning, quota, territory, coverage, segmentation, pipeline, productivity, and go-to-market data to support compensation and performance decisions.

Requirements

• Bachelor’s degree (BS/BA) desired in Computer Science, Math, etc.
• 5+ years of related experience.
• Certification is required in some areas.
• Preferred experience includes: Advanced SQL, including complex joins, CTEs, window functions, validation, reconciliation, and performance optimization.
• Python for data analysis, automation, data cleaning, API integration, and workflow improvement, including pandas, NumPy, openpyxl, matplotlib, requests, FastAPI, Streamlit, or similar libraries/frameworks.
• Power BI, Tableau, Excel, Snowflake, Salesforce, SharePoint, Varicent, or similar reporting, data, sales, or compensation platforms.
• Compensation analytics, incentive analytics, SPIFFs, accelerators, quota attainment, sales performance, payout processes, seller productivity, or core plan compensation effectiveness.
• Sales planning experience, including territory, quota, coverage, segmentation, pipeline, performance planning, or go-to-market analysis.
• Leadership reporting, executive dashboards, senior leadership presentations, business reviews, strategic recommendations, and decision-support materials.
• Project management experience leading cross-functional initiatives, managing timelines, dependencies, risks, requirements, stakeholder follow-ups, and executive updates.
• Project management certifications preferred, such as PMP, CAPM, PMI-ACP, Certified ScrumMaster, SAFe Agile, Lean Six Sigma Green Belt / Black Belt, or similar.
• Hands-on experience or strong working knowledge of agentic AI frameworks and orchestration tools such as LangChain, LangGraph, CrewAI, Microsoft AutoGen, Semantic Kernel, OpenAI API, Azure OpenAI, Microsoft Copilot Studio, Power Automate, Power Apps, or similar.
• Experience with retrieval-augmented generation, embeddings, vector databases, semantic search, document retrieval, prompt engineering, tool calling, function calling, workflow orchestration, API integrations, or AI-assisted analytics.

Tech Stack

• Azure
• Numpy
• Pandas
• PMP
• Python
• SQL
• Tableau

Benefits

• Medical/Dental/Vision coverage
• 401(k) plan
• Tuition reimbursement program
• Paid Time Off and Holidays (based on date of hire, at least 23 days of vacation each year and 9 company-designated holidays)
• Paid Parental Leave
• Paid Caregiver Leave
• Additional sick leave beyond what state and local law require may be available but is unprotected
• Adoption Reimbursement
• Disability Benefits (short term and long term)
• Life and Accidental Death Insurance
• Supplemental benefit programs: critical illness/accident hospital indemnity/group legal
• Employee Assistance Programs (EAP)
• Extensive employee wellness programs
• Employee discounts up to 50% off on eligible AT&T mobility plans and accessories, AT&T internet (and fiber where available) and AT&T phone