Senior analyst, inside sales analytics & reporting

A position at White Cap isn’t your ordinary job. You’ll work in an exciting and diverse environment, meet interesting people, and have a variety of career opportunities. The White Cap family is committed to Building Trust on Every Job. We do this by being deeply knowledgeable, fully capable, and always dependable, and our associates are the driving force behind this commitment.

Job Summary

Responsible for developing and maintaining sales datasets, reporting solutions, dashboards, and analyses that support sales performance management and commercial decision-making. Gathers, validates, and transforms data from multiple enterprise sources while building scalable reporting assets using Power BI and Databricks. Documents business logic and metric definitions, and investigates questions raised by sales leaders or identified through exploratory analysis.

Major Tasks, Responsibilities and Key Accountabilities

• Builds, tests, and maintains sales datasets, dashboards, and reporting assets for recurring reporting, executive requests, and field sales decision-making.
• Develops Power BI reports, semantic models, and self-service analytics experiences focused on clarity, usability, performance, and adoption.
• Uses SQL, Databricks, Python, and related tools to extract, transform, validate, analyze, and automate sales data across source systems.
• Validates transformations, calculations, metric definitions, and business logic to ensure outputs are accurate, reusable, and structured for downstream analysis.
• Documents data definitions, reporting logic, limitations, quality checks, and process steps so users and analytics partners can understand and trust outputs.
• Investigates questions brought forward by sales leaders or surfaced through exploratory analysis, including trends, risks, opportunities, outliers, productivity drivers, and performance patterns.
• Performs ad hoc analyses and recurring reporting for planning, forecasting, territory strategy, customer growth, pipeline management, pricing, and executive business reviews.
• Supports advanced analytics use cases, including segmentation, clustering, customer lifetime value, regression, forecasting, and propensity modeling, by preparing data, testing assumptions, interpreting outputs, and summarizing implications.
• Monitors and troubleshoots data quality issues, including missing attributes, inconsistencies, logic errors, and anomalies that may impact reporting or analysis.
• Works with Sales, Sales Strategy, Finance, Operations, IT, Data Services, and other partners to clarify requests, align on definitions, and deliver practical outputs.
• Uses Databricks AI/BI, Power BI, generative AI, and other modern analytics tools where appropriate to accelerate analysis, prototyping, documentation, and insight generation.
• Prepares clear summaries, dashboards, and presentations that connect analytical findings to business implications and next steps.
• Performs other duties as assigned.

Nature and Scope

Identifies key barriers/core problems and applies problem solving skills in order to deal creatively with complex situations. Troubleshoots and resolves complex problems. Makes decisions under conditions of uncertainty, sometimes with incomplete information, that produce effective end results. Independently performs assignments with instruction limited to the expected results. Determines and develops an approach to solutions. Receives technical guidance only on unusual or complex problems or issues. May oversee the completion of projects and assignments, including planning, assigning, monitoring and reviewing progress and accuracy of work, evaluating results, etc. Contributes to employees' professional development but does not have hiring or firing authority.

Work Environment

Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable. Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles. Typically requires overnight travel less than 5% of the time.

Education and Experience

Typically requires BS/BA in a related discipline. Generally 5-8 years of experience in a related field OR MS/MA and generally 3-5 years of experience in a related field. Certification is required in some areas.

Preferred Qualifications

• Strong experience in hands-on analytics, business intelligence, reporting, and commercial functions such as sales operations or finance analytics.
• Advanced Power BI expertise, including dashboard development, data modeling, DAX, visualization design, performance tuning, and stakeholder-facing reporting.
• Advanced SQL skills with experience working across large, complex datasets in enterprise data environments.
• Experience with Databricks or similar cloud-based analytics platforms for data transformation, exploration, modeling, and reporting support.
• Proficiency in Python for data manipulation, automation, validation, and building repeatable analytical workflows.
• Experience in data validation, cleansing, transformation, documentation, and governance, including metric definition and data quality standards.
• Ability to investigate analytical requests, uncover insights through exploratory and advanced techniques (e.g., regression, forecasting, segmentation), and clearly communicate findings to technical and non-technical stakeholders.

If you’re looking to play a role in building America, consider one of our open opportunities. We can’t wait to meet you. White Cap and its affiliates serve as a one-stop shop, providing concrete accessories and chemicals, tools and equipment, building materials and fasteners, erosion and waterproofing products, and safety products to professional contractors by meeting their distinct and customized supply needs in non-residential, infrastructure, and residential end markets. White Cap operates approximately 500 branches across North America with more than 11,000 employees supporting approximately 200,000 customers. For more information about White Cap, visit about.whitecap.com.