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.

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.

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

• 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

At SquareTrade you'll have access to: 

• Medical, dental and vision coverage with network optionality to support our dispersed workforce
• HSAs and FSAs
• 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
• Up to 4% company match into 401(k)
• Supportive leave policies including paid parental, grieving and loss, and domestic violence protected leaves
• Paid Time Off 
• Work flexibility
• Talent shares
• Tuition reimbursement
• Learning opportunities
• Hybrid work arrangements
• $80 monthly internet connectivity stipend
• Various corporate perks and discounts

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

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

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.  

Thank you for your interest in a career at SquareTrade. Throughout your job search, please be mindful of recruitment fraud.