Business Intelligence Developer

  • Full-time

Company Description

We believe everyone should be able to participate and thrive in the economy. So we’re building tools that make commerce easier and more accessible to all. We started with a little white credit card reader but haven’t stopped there. Our new reader helps our sellers accept chip cards and NFC payments, and our Cash app lets people pay each other back instantly. 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. Let’s shorten the distance between having an idea and making a living from it. 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 Analyst/Developer, you will be responsible for defining, developing and managing curated datasets, key business metrics and reporting across functional units at Square.

This role will be responsible for partnering with the People Analytics team to architect and develop data models and ETLs that power accurate, fast, and thorough analyses. You will play an integral part in enabling the People team to take data-driven decision making to the next level.

You will:

  • Partner with functional leads on the People team to understand their data and reporting requirements, and translating them into definitions and technical specifications (PRD)
  • Be responsible for defining, developing and optimizing curated datasets and schemas with standardized metrics and definitions across the company
  • Develop, deploy and maintain ETL jobs and visualizations
  • Work closely with technical partners in the data platform engineering team on designing and developing robust data structures and highly reliable data pipelines
  • Troubleshoot technical issues with platforms, data discrepancies, alerts etc
  • Perform ad hoc analysis, insight requests, and data extractions to resolve critical business issues

Qualifications

  • 6+ years working in a successful business intelligence team
  • Strong business intuition and ability to understand complex business systems
  • Expert knowledge in data modeling concepts and implementation
  • Strong technical accomplishments in SQL, ETLs and data analysis skills, particularly familiarity with technologies such as Airflow is a plus
  • Work experience with with Python or Ruby is a plus
  • Experience with Linux/OSX command line, version control software (git), and general software development
  • MySQL, Hadoop/HIVE, Vertica and/or Redshift data handling experience
  • Expertise in visualization technologies including Tableau, Looker and others
  • Hands on experience in processing extremely large data sets. Knowledge of payment network transactional data and SAS products a plus

Additional Information

At Square, we value diversity and always treat all employees and job applicants based on merit, qualifications, competence, and talent. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of the San Francisco Fair Chance Ordinance.

Privacy Policy