Technical Business/Data Analyst - Reconciliation

  • Full-time

Company Description

Block is one company built from many blocks, all united by the same purpose of economic empowerment. The blocks that form our foundational teams — People, Finance, Counsel, Hardware, Information Security, Platform Infrastructure Engineering, and more — provide support and guidance at the corporate level. They work across business groups and around the globe, spanning time zones and disciplines to develop inclusive People policies, forecast finances, give legal counsel, safeguard systems, nurture new initiatives, and more. Every challenge creates possibilities, and we need different perspectives to see them all. Bring yours to Block.

Job Description

The Reconciliation Team oversees all money movement at Block, ensuring that our merchants, as well as external financial institutions, correctly settle with Block on every single transaction. We empower Accounting, Finance, Product, Analytics, and Payments teams by delivering accurate data that is crucial to Square’s financials and provides early warning indicators for many product systems at Block. As a technical analyst on the Reconciliation team, you will work with our 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 partners and product teams to understand their needs and come up with an automated end-to-end solution
  • Translate our requirements into applicable data requirements
  • Design, curate, and document robust ETL pipelines to ensure highly accurate and reliable financial reporting
  • Bridge the gap between our requirements and ETL logic by troubleshooting data discrepancies and implementing scalable solutions
  • Become an expert on Square’s reporting platforms for development and visualization
  • Maintain 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
  • 4+ years of experience building reporting infrastructure and dashboards
  • Strong business intuition and ability to understand complex business systems
  • Critical problem solving ability with the willingness to fail fast and iterate quickly 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

Even better:

  • Data Visualization experience, e.g. Looker, Tableau
  • 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

We’re working to build a more inclusive economy where our customers have equal access to opportunity, and we strive to live by these same values in building our workplace. Block is a proud equal opportunity employer. We work hard to evaluate all employees and job applicants consistently, without regard to race, color, religion, gender, national origin, age, disability, veteran status, pregnancy, gender expression or identity, sexual orientation, citizenship, or any other legally protected class. 

We believe in being fair, and are committed to an inclusive interview experience, including providing reasonable accommodations to disabled applicants throughout the recruitment process. We encourage applicants to share any needed accommodations with their recruiter, who will treat these requests as confidentially as possible. Want to learn more about what we’re doing to build a workplace that is fair and square? Check out our I+D page

Additionally, we consider qualified applicants with criminal histories for employment on our team, assessing candidates in a manner consistent with the requirements of the San Francisco Fair Chance Ordinance.

Perks

We want you to be well and thrive. Our global benefits package includes:

  • Healthcare coverage
  • Retirement Plans
  • Employee Stock Purchase Program
  • Wellness perks
  • Paid parental leave
  • Paid time off
  • Learning and Development resources

Block, Inc. (NYSE: SQ) is a global technology company with a focus on financial services. Made up of Square, Cash App, Spiral, TIDAL, and TBD, we build tools to help more people access the economy. Square helps sellers run and grow their businesses with its integrated ecosystem of commerce solutions, business software, and banking services. With Cash App, anyone can easily send, spend, or invest their money in stocks or Bitcoin. Spiral (formerly Square Crypto) builds and funds free, open-source Bitcoin projects. Artists use TIDAL to help them succeed as entrepreneurs and connect more deeply with fans. TBD is building an open developer platform to make it easier to access Bitcoin and other blockchain technologies without having to go through an institution.

Privacy Policy