Associate Manager - Sales Analytics Business Analyst

WTW; New York (NY); On-site; USD 75,000 - 80,000; Full time

Job summary

WTW in United States (New York) seeks a Sales Analytics Business Analyst to align with our analytics strategy, execute requirements, and partner with the sales analytics team to improve data models and insights that support decision-making and go-to-market strategies.

The role focuses on predictive analytics for sales trends, pipeline connectivity, and collaboration with sales, finance, and marketing to translate needs into technical solutions.

Qualifications

• Global analyst with Power BI and Excel Power Query capabilities.
• Experience designing and maintaining Power BI dashboards.
• Ability to translate data needs into technical requirements.
• Strong data cleansing and validation across large datasets.
• Understanding of sales data models by business/geography.

Responsibilities

• Align with sales analytics strategy to execute requirements across WTW.
• Partner with analytics team to improve data models and insights.
• Develop predictive analytics on sales trends and pipeline.
• Provide go-to-market insights to support decision making.

Skills

Power BI

Excel Power Query

Financial acumen

Dashboard design

Stakeholder collaboration

Microsoft Dynamics

Data validation

Data cleansing

Sales data model

Data modeling improvements

Tools

Power BI

Power Query/Excel

Microsoft Dynamics

Job description

The Role

The Sales Analytics Business Analyst will align with WTW’s broader sales analytics strategy to execute requirements (for all WTW, including specific segments and businesses). This role will partner closely with the broader sales analytics team to improve the overall effectiveness of our data model and sales insights to support decision-making and go-to-market strategies. This role will foster growth by improving our sales analytics to provide predictive analytics on sales trends, pipeline, and connectivity across businesses.

Description

The Role

The Sales Analytics Business Analyst will align with WTW’s broader sales analytics strategy to execute requirements (for all WTW, including specific segments and businesses). This role will partner closely with the broader sales analytics team to improve the overall effectiveness of our data model and sales insights to support decision-making and go-to-market strategies. This role will foster growth by improving our sales analytics to provide predictive analytics on sales trends, pipeline, and connectivity across businesses.

Qualifications

The Requirements

• Partner with businesses as a global analyst with Power BI, excel power query, financial acumen skills


• Develop, design, and maintain Power BI dashboards and reports to provide actionable sales insights.


• Collaborate with sales, finance and marketing teams to understand their data needs and translate them into technical requirements.


• Utilize Microsoft tools, particularly above-average expertise in Microsoft Dynamics, Power BI, Power query/excel


• Ability to identify data inaccuracies, raise issues as required and collaborate with business stakeholders to manage queries


• Proficiency in cleansing large data sets and utilizing internal enterprise data sources for mapping requirements


• Ensure data accuracy and integrity by performing regular data validation and quality checks.


• Understanding of the sales data model applied to business and geography


• PM changes required in data models and make suggestions on improvements in communicating analytics

Note: Employment-based non-immigrant visa sponsorship and/or assistance is not offered for this specific job opportunity.

Compensation And Benefits

Base salary range and benefits information for this position are being included in accordance with requirements of various state/local pay transparency legislation. Please note that salaries may vary for different individuals in the same role based on several factors, including but not limited to location of the role, individual competencies, education/professional certifications, qualifications/experience, performance in the role and potential for revenue generation (Producer roles only).

Compensation

The base salary compensation range being offered for this role is $75,000.00-$80,000.00 USD annually. This role is also eligible for an annual short-term incentive bonus.

Company Benefits

WTW provides a competitive benefit package which includes the following (eligibility requirements apply):

• Health and Welfare: Mental health/emotional wellbeing (including Employee Assistance Program), medical (including prescription drug coverage and fertility benefits), dental, vision, Health Savings Account, Commuter Accounts, Health Care and Dependent Care Flexible Spending Accounts, company-paid life insurance, supplemental life insurance, AD&D, group accident, group critical illness, group legal, identity theft protection, wellbeing program, adoption assistance, surrogacy assistance, auto/home insurance, pet insurance, and other work/life resources.


• Leave Benefits: Paid Holidays, Annual Paid Time Off (includes state/local paid leave where required), Short-Term Disability, Long-Term Disability, Other Leaves (e.g., Bereavement, FMLA, ADA, Jury Duty, Military Leave, and Parental and Adoption Leave), Paid Time Off (only included for Washington roles)


• Retirement Benefits: Qualified contributory pension plan (if eligible) and 401(k) plan with annual nonelective company contribution. Non-qualified retirement plans available to senior level colleagues who satisfy the plans’ eligibility requirements.

Pursuant to the San Francisco Fair Chance Ordinance and Los Angeles County Fair Chance Ordinance for Employers, we will consider for employment qualified applicants with arrest and conviction records.

This position will remain posted for a minimum of three business days from the date posted or until sufficient/appropriate candidate slate has been identified.

EOE, including disability/vets