What are the responsibilities and job description for the Sales Analytics Business Analyst position at WTW?
Description
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.
Note: Employment-based non-immigrant visa sponsorship and/or assistance is not offered for this specific job opportunity.
The Role
- 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 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 and raise issues as required
- 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 data model applied to business and geography
- PM changes required in data models and make suggestions on improvements in communicating analytics
Qualifications
- The Requirements:
- At least 1 year of related work experience
- Proven experience as a Power BI Developer or in a similar role
- Strong proficiency in Power BI, including DAX and Power Query.
- Understanding of CRM systems and data lakes
- Strong project management and analytical skills
- Technically savvy
- Ability to coordinate teams across businesses and internal stakeholders
- Team-oriented and collaborative
- Broad understanding of WTW capabilities and expertise
This position will remain posted for a minimum of three business days from the date posted or until a sufficient/appropriate candidate slate has been identified.
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 base 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-$82,000 USD.
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 Benefits: Medical (including prescription coverage), Dental, Vision, Health Savings Account, Commuter Account, Health Care and Dependent Care Flexible Spending Accounts, Group Accident, Group Critical Illness, Life Insurance, AD&D, Group Legal, Identify Theft Protection, Wellbeing Program and Work/Life Resources (including Employee Assistance Program)
- Leave Benefits: Paid Holidays, Annual Paid Time Off (includes paid 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
- Retirement Benefits: Contributory Pension Plan and Savings Plan (401k). All Level 38 and more senior roles may also be eligible for non-qualified Deferred Compensation and Deferred Savings Plans.
EOE, including disability/vets
Salary : $75,000 - $82,000