Sr. Business Data Analyst

New American Funding

  • Tustin, CA
  • $100,000-150,000 per year
  • Permanent
  • Full-time
  • 9 days ago
Overview:Business Data Analyst - Compensation Retail SalesLocation: Remote or Hybrid if local (two days a week if you reside within 30 miles of Tustin, CA or a local branch)Starting Salary: $100k to $150k DOEPosition SummaryAre you passionate about data analytics and driving insights, analyzing sales performance and ensuring accurate, timely, and transparent compensation calculations? We are seeking an analyst with a strong data engineering background to meet the needs of flexible comp structure for a large sales team. This role will be responsible for designing, calculating, validating, and reporting on compensation plans that drive performance and align with business goals. You will partner closely with Sales, Finance, and Operations leadership to ensure compensation processes run smoothly and effectively. In addition, this role will be a key participant in driving lead data modeling helping DW team in building clean scalable data models.Responsibilities:Duties and Responsibilities
  • Own the calculation, validation, and processing of monthly/quarterly retail sales compensation across multiple plan types and incentive structures.
  • Build, maintain, and automate compensation reporting and dashboards (Power BI, Excel, SQL, or equivalent).
  • Collaborate with Sales Leadership, HR, and Finance to ensure alignment between compensation plans and company strategy.
  • Troubleshoot discrepancies and proactively resolve compensation issues with accuracy and timeliness.
  • Analyze sales performance metrics and compensation outcomes to provide insights and recommendations.
  • Ensure compliance with company policies and industry regulations in all compensation processes.
  • Present compensation reports and analysis clearly to stakeholders, including executives and sales leadership.
  • Support ad-hoc analyses related to incentive design, plan modeling, and sales performance trends.
  • Regular analytical support for the line of business in need
Qualifications:Qualifications
  • Bachelor’s degree in Business, Finance, Mathematics, Statistics, or a related field.
  • 3+ years of experience in compensation analysis, sales incentive management, or financial/sales analysis.
  • Strong SQL skills for data extraction and validation.
  • Proficiency in Power BI (or equivalent visualization tools) for building and automating compensation dashboards.
  • Advanced Excel skills (complex formulas, pivot tables, modeling).
  • Strong attention to detail and ability to work with high volumes of data accurately.
  • Excellent problem-solving, analytical, and communication skills.
  • Ability to manage multiple priorities in a fast-paced environment.
  • Experience in retail or sales incentive compensation is highly preferred.
Desired Skills & Experience
  • Experience working with sales performance management Compensafe
  • Knowledge of retail sales processes and incentive structures.
  • Familiarity with data warehousing solutions such as Snowflake.
Work Authorization: Must be able to verify identity and employment eligibility to work in the U.S.Other Duties: This job profile is not intended to be an all-inclusive list of job duties and responsibilities, as one may perform additional related duties as assigned in order to meet the needs of the organization.Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Must be able to lift up to ten pounds. Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull light to moderate amounts of weight; to operate office equipment requiring repetitive hand movement and fine coordination including use of a keyboard; and to verbally communicate to exchange information. VISION: See in the normal visual range with or without correction. HEARING: Hear in the normal audio range with or without correction.[EOE/M/F/D/V. Drug-free workplace.]#LI-KH1#LI-REMOTE

New American Funding