Financial Data 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 (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.

Job Description

The Financial Analysis team combines the functions of financial planning and data analysis. We take an end-to-end view of the business financially and operationally. The team is responsible for reporting cadence & dashboard development, budgeting & forecasting, long-term financial planning, risk management & pricing, company-wide business intelligence, and decision support for sales & operational business units. We use complex modeling to build connective tissue between raw data and financial performance as well as partner with all parts of the business.

The Financial Data Analyst will work in the revenue & expense analysis segment of the team. This group reports and builds models related to the company’s sales performance and operating expenses, while working closely with senior management to monitor & forecast performance. The Analyst will support the Manager in the group in creating financial and operating reports, budgets and forecasts for operating expenses, and developing financial support for operating decisions. Well-qualified candidates will have experience building and maintaining financial models in Excel, organizing data in SQL and building dashboards in business intelligence tools (e.g., Tableau). This position will also provide other ad hoc analyses and data as needed.

This role provides opportunities to get involved with complex projects that touch a variety of different teams throughout the company and will challenge you to use your analytical skills to solve problems creatively. The position reports to the Finance Director.

Responsibilities:

• In-depth exploration of causes or trends to identify problems, opportunities and specific actions required
• Build and use financial models that simulate and forecast business elements and margin implications; quantify uncertainty and statistical variance in projections/scenarios
• Identify and research monthly and quarterly variances to forecast or prior year’s results, actively recognizing opportunities for improvement
• Uncover new opportunities to grow and optimize the business through analytics, financial modeling, and business case development
• Improve processes for current reporting, automation, frequency, efficiency, etc.
• Create and overhaul dashboards and underlying data structures
• Ensure integrity of financial models, reporting and databases
• Support operational departments with ad hoc analysis and reporting
• Presenting analysis to senior level management

Qualifications

• 2-5 years of work experience as an analyst, or similar position
• Bachelor’s Degree in Business, Economics, Mathematics, Statistics, or a related field
• Advanced degree (i.e.: an MBA or Master's in an analytics-oriented field) is a plus
• Experience building, updating, and maintaining financial models
• Advanced Microsoft Excel skills
• Familiarity with reporting tools (Tableau) and SQL skills are a plus
• Ability to draw conclusions from raw data then summarize results quickly and efficiently
• Experience working with large data volumes required
• Ability to meet deadlines in a fast-paced environment
• Organized and detail oriented
• Strong writing and presentation skills

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 

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