Business Analyst / Senior Business Analyst

SquareTrade is the fastest growing company of its kind. We're revolutionizing a $30b industry with service innovation and attention to customer satisfaction. We partner with some of the largest, most sophisticated retailers and carriers in the world (Walmart, Target, Amazon, Costco, and T-Mobile to name a few), consistently win industry awards, have received tens of thousands of 5-star reviews… and we're just getting started. A member of the Allstate family, SquareTrade has headquarters in San Francisco and London. We are currently expanding in Europe and Asia Pacific, including Japan and Australia.

The Team
The Financial Analytics team combines the functions of data analytics, business intelligence, and financial planning. We take an end-to-end view of the businesses' operations and finances. The team has a wide variety of responsibilities: company-wide business intelligence, financial reporting, dashboard development, forecasting and budgeting, risk management, pricing, and decision support for various business units. We use complex modeling to build connective tissue between raw data and financial performance.

The Position
The Business Analyst will work in the New Business / Growth Analytics segment of the team, focusing on growth initiatives both within the U.S. and globally.

Specifically for this position, the employee is responsible for:

• Assisting on modeling company growth/expansion opportunities
• Optimizing pricing on new and existing products in conjunction with Business Development
• Building out various in-depth reporting with Tableau
• Developing complex Excel models to glean deep insights into operational performance
• Monitoring and managing company financial risk
• Providing financial and analytical support to drive the executive team's operating decisions

Qualified candidates will have experience developing exceedingly intricate financial models in Excel, crafting their own thorough SQL queries and tables, and constructing complex dashboards using BI visualization tools (e.g. Tableau). This position will also provide other ad hoc analyses and data as needed. This role provides opportunities to work on challenging projects with virtually every team in the company, requiring the employee to use their creativity and analytical skills to find optimal solutions.

Responsibilities include:

• In-depth exploration of causes and trends to identify problems/opportunities
• Utilization of financial models that simulate and forecast business elements
• Creation and redesign of dashboards and their underlying data structures to support the needs of various teams
• Quantification of uncertainty and statistical variance in projections/scenarios
• Ad hoc support of the sales, finance, and operational departments
• Improve processes for current reporting, automation, frequency, and efficiency
• Ensure integrity of financial models, reporting, and databases

• 3-6 years of work experience as an analyst, or similar position
• Bachelor's Degree in Business, Economics, Statistics, or a related field is required
• Advanced degree (i.e.: an MBA or Masters in an analytics-oriented field) is a plus
• Proficiency with heavy operational and financial modeling is required
• Strong SQL skills and experience working with large data volumes required
• Hands-on experience with BI reporting tools required (Tableau preferred)
• Python or R experience is a plus
• Ability to set and meet deadlines in a fast-paced environment
• Strong writing, presentation, self-management, and organizational skills

Some of the benefits of include:

• Competitive salaries, benefits (medical, dental, vision), flex PTO, 401k matching, paid parental leave
• $80 per month connectivity reimbursement directly in your paycheck
• Respect for your work-life balance
• A paid volunteer day to give back to the community
• Flexible work schedules - some roles are hybrid allowing you to work from home a few days per week
• Not feeling stuck! This team has exposure to many different parts of the business, making transitioning easy...we work on developing careers based on what people enjoy

The Team:

SquareTrade is an Equal Opportunity Employer