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

The Reconciliation Team oversees all money movement at Square, ensuring that our merchants, as well as external financial institutions, correctly settle with Square on every single transaction. We empower Accounting, Finance, Analytics, Payments, and product teams by delivering accurate data that is crucial to Square’s financials and provides early warning indicators for many product systems at Square.

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 Looker dashboards that support Accounting, Treasury, and product teams; and develop data pipelines to support early detection and alerting of anomalies.

You will:

  • Work with non-technical business partners to understand their needs and come up with an automated end-to-end solution.

  • Translate business requirements into actionable data tasks.

  • Design, develop, curate, and document robust ETL pipelines to ensure highly accurate and reliable financial reporting.

  • Bridge the gap between business requirements and ETL logic by troubleshooting data discrepancies and implementing scalable solutions.

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

  • Proactively identify ways to improve existing reports and processes.

  • Teach and encourage others to self-serve while building reports that make it simpler and faster for them to do so.

Qualifications

You have:

  • Bachelor's degree in a quantitative field, or equivalent work experience

  • 3+ years of experience building reporting infrastructure and dashboards.

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

  • Ability to understand non-technical business customers’ needs and translate them into automated reporting

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

  • Strong technical accomplishments in SQL and data analysis skills.

  • Experience designing, developing, and maintaining ETL pipelines.

  • Familiarity with schema design, query optimization, and data pipeline maintenance.

  • Snowflake, BigQuery, MySQL or similar data handling experience.

Bonus points:

  • Data Visualization experience, e.g. Tableau, Looker

  • Airflow experience

  • Experience with financial data, accounting, or auditing

  • Experience with Python or Java (automation/scripting)

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