Technical Reporting Analyst, Reconciliation

  • 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 technical reporting analyst on the Reconciliation team, you will be responsible for working with business users and engineering to design, build, and test reconciliation pipelines, build reporting dashboards with Looker that support Accounting, Treasury and product teams, and develop data pipelines to support easy detection and alerting of anomalies.

You will:

  • Partner with business users to understand their needs and come up with an end-to-end solution.

  • Translate business requirements to actionable data tasks.

  • Design and develop scalable ETL pipelines.

  • Become a subject matter expert on Square’s reporting platforms for development and visualization.

  • Be responsible for maintaining security and data access models within Square’s reporting platforms.

  • Design, develop, and test reconciliation pipelines that drive Square’s financials.

Qualifications

You have:

  • 2+ years experience in building reporting infrastructure and dashboards.

  • Strong business intuition and ability to understand complex business systems.

  • Substantial attention to detail and a tenacious dedication to quality.

  • Proven ability to work with business users and iterate upon existing reporting.

  • Strong technical accomplishments in SQL and data analysis skills.

  • Expertise in visualization technologies, e.g. Tableau, Looker, or other tools.

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

  • Familiarity with structuring and writing ETLs.

Bonus points:

  • Prior Looker experience

  • Prior Airflow experience

  • Experience with financial data, accounting, or auditing

  • Experience with Python or Java

  • 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.