Business Analyst

Company Description

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 (Amazon, Walmart, The Home Depot 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.

Job Description

Our 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, 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.

We are seeking an analyst who will work in the business intelligence & data analysis segment of the team, focusing on growth initiatives both in the U.S. and globally. Qualified candidates will have experience developing exceedingly complex financial models in Excel, crafting their own SQL queries and tables, and constructing thorough 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 craft solutions. The position reports to an Analytics Director.

Responsibilities:

• 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
• Assisting on major company growth/expansion opportunities 
• Building out various in-depth reporting with Tableau 
• Developing complex Excel models to glean insight into company operations 
• Optimizing pricing on new and existing products in conjunction with Business Development 
• Monitoring and managing company risk 
• Providing financial and analytical support to drive the Executive team’s operating decisions 

Qualifications

• 2-5 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 
• Familiarity with 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) 

An Ideal Candidate would also have/be :

• Strong writing, presentation, and organizational skills 
• Ability to set and meet deadlines in a fast-paced environment
• Above all: self-driven and demonstratively motivated to make an impact

Additional Information

At SquareTrade you'll have access to: 

• Robust medical, dental and vision coverage with generous employer contributions tailored for our diverse workforce
• Inclusive fertility care plan
• 5% company match into 401(k)
• Open access to mental health benefits including 1:1 therapy, coaching sessions and digital resources
• $75 monthly allowance to support self-care and well-being
• Career experience programs, tuition reimbursement and unlimited access to online courses to support your professional growth
• Supportive leave policies including paid parental, grieving and loss, and domestic violence protected leaves
• Flexible paid time off plus a generous holiday schedule
• Paid volunteer time to give back to the community
• Hybrid work arrangements
• $80 monthly internet connectivity stipend
• Reimbursement for in-home office setup
• Various corporate perks and discounts

(California Only) Pursuant to applicable law, SquareTrade estimates the possible compensation for this role, if hired in California, to be within the following range: 90K-110K 

(Colorado Only) Pursuant to applicable law, SquareTrade estimates the possible compensation for this role, if hired in Colorado, to be within the following range: 70K-90K

SquareTrade is proud to be an Equal Employment Opportunity employer. We are committed to creating an inclusive work environment for all employees. We celebrate diversity and encourage applications from all qualified individuals regardless of race, religion, color, national origin, sex, gender identity, gender expression, sexual orientation, age, marital status, veteran status, or ability status.  

The Team:  http://www.squaretrade.com/leadership