Product Analyst Lead, Ecommerce
- San Francisco, CA
We believe the economy is better when everyone has access. When everyone has room to grow. No one should be left out because the cost is too great or the technology too complex. We started with a little white credit card reader but haven’t stopped there. We’re empowering the independent electrician to send invoices, setting up the favorite food truck with a delivery option, helping the ice cream shop pay its employees, and giving the burgeoning coffee chain capital for a second, third, and fourth location. We’re here to help sellers of all sizes start, run, and grow their business—and helping them grow their business is good business for everyone.
This role will be focused on working with the product team to build and improve the Square Ecommerce experience. This role is a lead role over a small but high output team focused on both Commerce Store analytics and Customer Success analytics.
The ideal candidate understands and loves seeing the impact of their work translate into product changes and improvements. The role will involve working on the product from end-to-end, but with a key focus on Store experience, Checkout success, and the behind the curtains aspects eCommerce. You’ll be leading other analysts and formulating analyses using a rich dataset to track feature usage, performance, identify potential gaps and opportunities, and make recommendations to stakeholders. In addition to the day-to-day tasks, this role will challenge you to think strategically and contribute to high-level discussions with senior leadership and peers across Square.
Be the expert on eCommerce store data and lead a small team of Product analysts on the journey of discovery for all Commerce Store activity in Square
Be the point of contact for strategic customer success analytics as they arise
Define KPIs, build ETLs, construct dashboards and other tools for you and other stakeholders to monitor Store health for both Sellers and buyers
Break down nuanced, complex data for stakeholders, while keeping customer and business context in mind.
Get your hands dirty, challenge assumptions and pressure-test analyses.
Join a broader team of motivated, intelligent analysts and contribute your learnings back to the broader analyst community at Square.
Partner with product managers, engineers and senior strategy leaders to improve the product. Make sure the right questions are being asked, solicit feedback, and iterate until you reach meaningful analysis
Design and analyze A/B experiments to evaluate the impact of changes we make to the product
Perform complex data analysis using SQL on a daily basis
Break down nuanced, complex data for stakeholders, keeping context at the forefront of communication
Be faced with tough, open-ended questions with rabbit-holes abound. You’ll need to develop a strategy and stay focused, use your judgement to follow leads that improve the likelihood of reaching your goal, ignore ones that don’t
Roll up your sleeves to solve problems and challenge assumptions. Don’t be afraid to speak up when you’ve formulated a well researched/substantiated opinion
Develop, debug and improve data models. Our product moves fast and new data doesn’t always play nice with existing models. Think about how to ingest data in the most useful and scalable format.
Define KPIs, build ETLs, construct dashboards and other tools for you and other stakeholders
5+ years of experience in an analytics role with 1-2 years of experience on leading people
Strong SQL required, familiarity with scripting languages such as Python and R a plus
Great product instincts and natural curiosity towards analytics
Ability to manage competing priorities from multiple stakeholders
Confident and thoughtful communication style. You need to be able to develop trust and accept feedback
Excellent troubleshooting skills and attention to detail
Experience with BI reporting tools is preferred (Looker, Tableau, etc)
Quantitative background (eg, bachelor’s degree or applicable training/experience)
Sharp data intuition and attention to detail; an ability to focus on the most essential challenges of a data problem.
Demonstrated experience using data analysis and visualization tools (e.g. SQL, R, Tableau, Looker).
Prior experience with Dimensional modeling and Version control tool (e.g. GitHub)
A track record of delivering on impactful data projects with multiple, often senior, stakeholders.
Technical initiative, curiosity and the desire to grow as an individual.
Technologies we use and teach
SQL (Snowflake, BigQuery), Airflow, Looker, Tableau
Google Cloud, AWS
Machine learning and statistical modeling frameworks