Product Analyst Lead, Ecommerce

  • San Francisco, CA
  • Full-time

Company Description

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.

Job Description

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. 

You Will:

  • 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

  • Python, R

  • Machine learning and statistical modeling frameworks

Additional Information

At Square, our purpose is to empower – within and outside of our walls. In order to build the best tools for the businesses and customers we support all over the world, we have to start at home with a workforce as diverse and empowered as our sellers. To this end, we take great care to evaluate all employees and job applicants equally, based on merit, competence, and qualifications. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability status, or any other characteristic protected by law. We encourage candidates from all backgrounds to apply and always consider qualified applicants with arrest and conviction records, in accordance with the San Francisco Fair Chance Ordinance. Applicants in need of special assistance or accommodation during the interview process or in accessing our website may contact us by sending an email to assistance(at) We will treat your request as confidentially as possible. In your email, please include your name and preferred method of contact, and we will respond as soon as possible. Perks At Square, we want you to be well and thrive. Our global benefits package includes: Healthcare coverage, Retirement Plans, Employee Stock Purchase Program, Meal reimbursements, Wellness perks, Paid parental leave, Flexible time off, Learning and Development resources