Business Analyst II, Refunds CX, WW Refunds Experience

Key job responsibilities

• Own the design, development, and maintenance of scalable solutions for ongoing metrics, reports, analyses, dashboards, etc. to support analytical and business needs.
• Work with team leadership to understand the customer needs and concerns as well as define solutions.
• Translate basic business problem statements into analysis requirements. Work with internal customers to define best output based on expressed stakeholder needs.
• Use analytical and statistical rigor to solve complex problems and drive business decisions.
• Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting.
• Design and drive experiments, A/B testing, outlier deep dives and form actionable recommendations. Manage the implementation of those recommendations.
• Write queries and output efficiently, and have in-depth knowledge of the data available in area of expertise. Pull the data needed with standard query syntax; periodically identify more advanced methods of query optimization. Convert data to make it analysis-ready.
• Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.
• Monitor and troubleshoot operational or data issues in the data pipelines
• Review and audit existing ETL jobs and SQL queries.

Basic Qualifications

• 3+ years of tax, finance or a related analytical field experience
• 5+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Tableau experience
• 3+ years of business or financial analysis experience
• Bachelor's degree or equivalent
• Experience defining requirements and using data and metrics to draw business insights
• Experience with Excel
• Experience with SQL
• Experience making business recommendations and influencing stakeholders

Preferred Qualifications

• Experience in customer segmentation, customer behavior analysis, conjoint/trade-off modeling
• Experience partnering with executive-level leaders to identifying and solving business issues