Business Intelligence Analyst

  • 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

As a Business Intelligence Developer, you will play a crucial role in implementing, improving, and maintaining Square’s executive-level dashboards. This includes partnering and consulting with product analysts in order to provide guidance and assistance in maintaining data fidelity and to stay current with internal and external factors that affect metric behavior. As part of the BI team, you’ll also serve as a consultant to analysts across Square to provide guidance and assistance in creating and streamlining dashboards and underlying ETL pipelines. Your expertise and attention to detail will inform the organization and inspire people across Square to adopt and innovate reporting!

You will:

  • Partner with product analysts, data scientists, business users, and others to understand their needs and come up with an end-to-end solution 

  • Translate business requirements to actionable data tasks (English <-> SQL)

  • Design and develop scalable turn-key ETL pipelines 

  • Become a subject matter expert on top-level product metrics, both in the calculation methodology and in observing week-over-week trends

  • Assist in office hours, training sessions, brown bags and more to evangelize reporting and ETL best practices throughout the company with an emphasis on Looker

  • Be responsible for maintaining security and data access models within Looker

Qualifications

You have:

  • 2+ years working on a successful business intelligence team

  • Strong technical accomplishments in SQL and data analysis skills

  • Extreme attention to detail and the ability to detect anomalies across dozens of weekly metrics

  • Strong business intuition and ability to understand complex business systems

  • Expertise in visualization technologies including Looker, Tableau and/or another BI tool

  • Snowflake, Redshift, MySQL, Vertica, or similar data handling experience

  • Familiarity with structuring and writing ETLs

Bonus points:

  • Prior Looker experience

  • Prior Airflow experience

  • Work experience with Python, Ruby, or Javascript (D3)

  • Experience with Linux/OSX command line and git

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)squareup.com. 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.